Free Microsoft 70-473 Exam Dumps Questions & Answers

You have a Microsoft Azure SQL database named DB1.
You need to monitor DB1 to identity all regressed queries.
Which command should you use?

• A.  ALTER DATABASE DB1 SET QUERY_SSTORE (QUERY_CAPTURE_MODE All) GO
• B.  select *
  from sys.dm_exec_query_stats
• C.  select *
  from sys.dm_exec_query_stats
  cross apply sys.dm_exec_query_plan (plan_handle)
• D.  ALTER DATABASE DB1 SET QUERY_STORE (OPERATION_MODE READ_WRITE)

You have an AlwaysOn availability group between several Microsoft Azure virtual machines.
You need to ensure that the databases meet the following requirements:
The solution must prevent any disruption to replication.
Which four actions should you perform in sequence? I answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

Explanation

References:
https://blogs.msdn.microsoft.com/alwaysonpro/2014/01/28/how-to-enable-tde-encryption-on-a-database-in-an-av

You need to migrate DB2 to Azure.
Which utility should you use for each task? To answer, drag the appropriate utilities to the correct tasks. Each utility may be used once, more than once, or not at all. You made need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation

Box 1: mysqldump
Use common utilities and tools such as MySQL Workbench, mysqldump, Toad, or Navicat to remotely connect and restore data into Azure Database for MySQL.
Box 2: azcopy
AzCopy is a command-line tool for copying data to or from Azure Blob storage, Azure Files, and Azure Table storage, by using simple commands. The commands are designed for optimal performance. You can copy data between a file system and a storage account, or between storage accounts.
App2 is developed by using third-party open source code that is updated frequently. The database for App2 is named DB2. App2 only supports MySQL.
Reference:
https://docs.microsoft.com/en-us/azure/mysql/concepts-migrate-import-export
https://docs.microsoft.com/en-us/azure/storage/common/storage-use-azcopy-migrate-on-premises-data?tabs=win

You have a hybrid Microsoft SQL Server environment that has multiple servers and services that run in both Microsoft Azure and on-premises.
If the network fails, you need to ensure that users can authenticate and connect to the resources available in Azure.
Which two server roles should you deploy to Azure? Each correct answer presents part of the solution.

• A.  Active Directory Domain Services
• B.  Active Directory Certificate Services
• C.  DHCP Server
• D.  DNS Server
• E.  Active Directory Federation Services

You have a Microsoft Azure Infrastructure as a Service (IaaS) environment that contains a 3-TB data warehouse.
You need to recommend a solution to improve the read performance of the database. The solution must maintain data integrity.
Which task should you include in the recommendation?

• A.  Enable read caching.
• B.  Enable read/write caching.
• C.  Move the transaction logs to the temporary drive.
• D.  Set the interleave size to 64 KB.