Online Access Free 070-473 Exam Questions

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.ALTER DATABASE DB1 SET QUERY_STORE (OPERATION_MODE READ_WRITE)
• C.select *
  from sys.dm_exec_query_stats
• D.select *
  from sys.dm_exec_query_stats
  cross apply sys.dm_exec_query_plan (plan_handle)

You need to export a Microsoft Azure SQL database named DB1from a server named Server1. The credentials to connect to Server1 are stored in a variable named Credential.
The backup of the database must be stored in a storage account named Storage1 in a container named container1.
Which commands should you run in an Azure PowerShell script? To answer, drag the appropriate values to the correct targets. Each value 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.
NOTE: Each correct selection is worth are point.

Correct Answer:

Explanation

You need to recommend a solution to meet the reporting requirements of App3.
What should you include in the recommendation?

• A.SQL Server replication
• B.Azure Data Sync
• C.database mirroring
• D.AlwaysOn Availability Groups

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/write caching.
• B.Move the transaction logs to the temporary drive.
• C.Enable read caching.
• D.Set the interleave size to 64 KB.

You have a Microsoft SQL Server database named DB1 in the data center of your company.
You export DB1 to a script file.
You need to import DB1 to a Microsoft Azure SQL database.
What should you use?

• A.mssql-scripter.exe
• B.SqlLogShip.exe
• C.ssms.exe
• D.dtutil.exe