Online Access Free 70-473 Exam Questions

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.Azure SQL Database Index Advisor
• B.Database Engine Tuning Advisor
• C.Azure Throughput Analyzer
• D.Index Tuning Wizard

You have a Microsoft SQL Server instance that is hosted on a Microsoft Azure virtual machine.
You need to identify the most recent wait type for all of the currently running queries in the instance.
What should you use?

• A.the sp_who2 stored procedure
• B.the sys.dm_exec_connections view
• C.the sys.dm_exec_requests view
• D.the sys.syscacheobjects view

Your company's data center contains two databases named DB1 and DB2.
DB1 contains 500 MB of data. DB2 contains 400 GB of data that is read-only. Both databases contain sensitive data.
Each database regularly has more than 1,000 concurrent connections.
You need to migrate the databases to Microsoft Azure SQL Database. The solution must minimize costs.
Which tier and service level should you choose for each database? To answer, select the appropriate options in the answer area.

Correct Answer:

Explanation

References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-dtu-resource-limits-single-databases#single-dat

You have a Microsoft Azure SQL database.
You need to provide a copy of the database to an auditor.
What should you do?

• A.Run the BACKUP DATABASE statement and the RESTORE DATABASE statement.
• B.Run the CREATE DATABASE statement and use the AS COPY OF clause.
• C.Run the sp_detach_db stored procedure and the sp_attach_db stored procedure.
• D.Run the CREATE DATABASE statement and use the AS SNAPSHOT OF clause.

You plan to create a database named DB1.
You need to ensure that all the data in DB1 is encrypted when the database is at rest.
Which four actions should you perform in sequence after you create DB1? To 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://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/transparent-data-encryption?view=