Online Access Free 070-473 Practice Test

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are managing a Microsoft Azure SQL database.
Users of the database report that queries to the database are slow to return results.
You need to recommend a solution to identify the most likely cause of the slow queries and to archive all database events for at least 90 days.
Solution: You deploy Intelligent Insights to identify the slow queries and an Azure event hub to archive all the database events.
Does this meet the goal?

• A.No
• B.Yes

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.

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 are planning the migration of SQL01 to an Azure virtual machine.
You need to identify which service tier to use for the virtual machine. The solution must meet the business goals and the technical requirements.
Which virtual machine service tier should you identify?

• A.Standard D3
• B.Standard G2
• C.Standard DS13
• D.Standard A7

You have 10 Microsoft Azure SQL databases.
One of the databases is named DB1.
You need to ensure that only a specific IP address can be used to access DB1. The solution must affect only DB1.
What should you use?

• A.the New-AzureSqlDatabaseServerFirewallRule cmdlet
• B.the Set-AzureSqlDtatabaseServerFirewallRule cmdlet
• C.the Azure portal to add an endpoint
• D.the sp_set_database_firewall_rule statement