Dumps4Download Microsoft 70-473 Accurate Study Material & 70-473 Valid Questions

Question No : 1

You need to recommend a solution to migrate the Listings database to the cloud.What should you recommend?

A. Stage the Listings database on an Azure virtual machine prior to the outage. During the outage,perform a data import from the main office by using SQL Server Management Studio.

B. Implement log-shipping between the main office and an Azure virtual machine prior to the migration date. During the planned outage, perform a final log backup, restore the backup to the secondary, and then switch the secondary to the primary role.

C. Run a full backup during the outage and restore the backup to the Azure virtual machine.

D. Implement merge replication between the main office and the Azure virtual machine.

Answer: B

Question No : 2

You are evaluating whether an Azure SQL Database elastic database pool suits your workload and usage patterns.What are two possible ways to identify the elastic database transaction units (eDTUs)?Each correct answer presents a complete solution.

A. Aggregate data from sys.dm_os_wait_stats.
B. Run the Database Engine Tuning Advisor.
C. Run the Service Tier Advisor.
D. Aggregate data from sys.dm_db_resource_stats.
E. Aggregate data from sys.dm_os_performance_counters.


Answer: D,E

Microsoft 70-473 Exam dumps - Get 70-473 PDF With Actual Questions Answers 

Question No : 3

You have a Microsoft Azure virtual machine that hosts a Microsoft SQL Server database.You need to configure firewall rules to meet the following requirements:Which Azure endpoint ports should you open? To answer, drag the appropriate ports to the correct types of access. Each port may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

Answer:

Question No : 4

You have a Microsoft Azure SQL database.You need to ensure that you can use the Always Encrypted feature for the database.Which two components should you configure? Each correct answer presents part of the solution.

A. the Column Master Key
B. the database master key
C. the service master key
D. transparent data encryption (TDE)
E. the Column Encryption Key

Answer: A
Explanation:
References:

https://azure.microsoft.com/en-gb/documentation/articles/sql-database-always-encrypted/

Microsoft 70-473 Actual Dumps - Valid 70-473 Braindumps Questions & Answers

Question No : 5

DRAG DROP

You have four Microsoft Azure SQL databases located on the same database server.You need to configure the databases to be in an elastic database pool.Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct

orders you select.

Answer: 

Explanation:

References:

https://azure.microsoft.com/en-gb/documentation/articles/sql-database-elastic-pool-create- portal/

Question No : 6

Your company has two offices located in London and New York.

The London office has a public IP of 131.107.1.1 and a private IP subnet of 192.168.4.0/24.The New York office has a public IP of 131.107.15.1 and a private IP subnet of 192.168.8.0/24.

You have a Microsoft Azure SQL database.Currently, only the users in the London office use the database.You plan to provide the users in the New York office with access to the database.

You need to ensure that the New York office users can access the database.Which command should you execute?

A. EXECUTE sp_set_database_firewall_rule N'NewYork,'131.107.15.1','255.255.255.255'

B. EXECUTE sp_set_database_firewall_rule N'NewYork, '192.168.8.0', `192.168.8.255';

C. EXECUTE sp_set_database_firewall_rule N'NewYork,'192.168.8.0', '255.255.255.0';

D. EXECUTE sp_set_database_firewall_rule N'NewYork,'131.107.15.1','131.107.15.1';

Answer: B

Explanation:

http://azure.patrickkeisler.com/2015/11/configuring-the-azure-sql-database-firewall/

https://msdn.microsoft.com/en-gb/library/dn270010.aspx

Microsoft 70-473 Exam Study Questions & 70-473 PDF Training Material

Question No : 7

You have an application that uses a Microsoft SQL Server database on a Microsoft Azure virtual machine.The application experiences performance issues, which you suspect are related to the connection

pooling.The issues are prevalent only when there are more than 150 concurrent connections.You need to identify whether the performance issues are related to the connection pooling.

Which dynamic management view should you query?

A. sys.dm_os_memory_pools

B. sys.dm_exec_requests

C. sys.dm_exec_connections

D. sys.dm_exec_sessions

Answer: D

Explanation:

https://blogs.msdn.microsoft.com/sql_pfe_blog/2013/10/08/connection-pooling-for-the-sql- serverdba/

Question No : 8

You have a report that runs against a Microsoft Azure SQL database.The report takes more time to return results than expected.You add an index to a table in the database.You need to identify whether adding the index improves the performance issue.What should you use?

A. Database Engine Tuning Advisor

B. Index Tuning Wizard

C. Azure Throughput Analyzer

D. Azure SQL Database Index Advisor

Answer: D

Explanation:

https://azure.microsoft.com/en-gb/documentation/articles/sql-database-advisor/

Microsoft 70-473 Exam dumps - Get 70-473 PDF With Actual Questions Answers

Question No : 9

You have Microsoft SQL Server installed on a Microsoft Azure virtual machine.The virtual machine is on the Standard D3 service tier.All of the data files for the databases on the virtual machine are located on a single volume that ismounted as drive E.The virtual machine experiences performance issues.You view the wait statistics and discover a high number of GEIOLATCH_SH waits associated to the tempdb data files.You need to resolve the performance issues.What should you do?

A. Move the tempdb data files to drive D.

B. Move the tempdb data files to drive

C. Change the service tier of the virtual machine to Standard D12.

D. Change the service tier of the virtual machine to Standard DS3.

Answer: A

Question No : 10

You are a database administrator for a retail e-commerce web application solution.Your databases for this solution are all stored in the Azure SQL Database service.You learn that compliance certifications require that credit card data is encrypted at rest, in transit, and during queries.You must enable encryption in Azure SQL Database to meet this requirement.Which feature should you use?

A. Row-Level Security (RLS)

B. Dynamic Data Masking

C. Always Encrypted

D. Transparent Data Encryption (TDE)

Answer: C

Explanation:

You should use the Always Encrypted feature of Azure SQL Database. This feature enables encryption in transit, in memory, on disk (at rest) and during query processing.You should not use Transparent Data Encryption. TDE enables encryption that does not require any changes to your applications, but the encryption is only while the data is at rest.You should not use the Row-Level Security or Dynamic Data Masking features. Neither of these features encrypts your data. Both features modify what data is visible to client applications.

Microsoft 70-473 Exam 100% Passing Guarantee | 70-473 Study Tips Dumps4Download.us