Microsoft Designing and Implementing Cloud Data Platform Solutions - 070-473 Exam Practice Test
Question 1
Your environment contains a Microsoft Azure virtual machine and an Azure SQL database. The virtual machine has Microsoft SQL Server installed and contains several applications. You need to recommend a solution to migrate one of the applications to the Azure SQL database. The solution must minimize downtime.
Which solution should you recommend?
Which solution should you recommend?
Correct Answer: C
Question 2
You have a Microsoft Azure SQL database named DB1.
You need to monitor DB1 to identity all regressed queries.
Which command should you use?
You need to monitor DB1 to identity all regressed queries.
Which command should you use?
Correct Answer: A
Question 3
You plan to implement row-level security for the CWDB database.
You create the fn_limitusers function under the restriction schema.
You need to create the policy.
How should you complete the policy? To answer, drag the appropriate elements to the correct locations. Each element 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.
You create the fn_limitusers function under the restriction schema.
You need to create the policy.
How should you complete the policy? To answer, drag the appropriate elements to the correct locations. Each element 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.
Correct Answer:
Explanation
References:
https://msdn.microsoft.com/en-us/library/dn765131.aspx
Question 4
You have an on-premises database hosted on a Microsoft SQL Server instance.
You plan to back up the database to Microsoft Azure.
You create a storage account in Azure for the backups.
You need to back up the database to Azure. The solution must ensure that the backups are encrypted before they are sent to Azure.
Which three 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.
You plan to back up the database to Microsoft Azure.
You create a storage account in Azure for the backups.
You need to back up the database to Azure. The solution must ensure that the backups are encrypted before they are sent to Azure.
Which three 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.
Correct Answer:
Explanation
Question 5
You need to configure auditing to meet the technical requirements.
Which three 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.
Which three 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.
Correct Answer:
Explanation
References:
http://solutioncenter.apexsql.com/how-to-setup-and-use-sql-server-audit-feature/
Question 6
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.
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.
Correct Answer:
Explanation
References:
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-elastic-pool-create-portal/
Question 7
What should you use to schedule the nightly jobs to meet the technical requirements?
Correct Answer: A
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 8
You need to configure server-level access to the ListTest database. adatum What statement should you use? To answer, drag the appropriate elements to the correct locations. Each element may be used 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 one point.
You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation
Question 9
You need to create a Microsoft Azure Resource manager template.
Which file format should you use?
Which file format should you use?
Correct Answer: D
Question 10
Your company has a data center located in Europe. The company has a 10 Mbps connection to the Internet that is 80 percent saturated on average. You have an on-premises Microsoft SQL Server database that is 6 TB. You plan to migrate the database the database to Microsoft Azure.
You need to recommend a solution to migrate the database to Azure. The solution must meet the following requirements:
- Ensure that the database is hosted in the West US region.
- Minimize any changes to the current network infrastructure.
- Minimize the amount of time required to migrate the database.
What is the best recommendation to achieve the goal? More than one answer choice may achieve the goal.
Select the BEST answer.
You need to recommend a solution to migrate the database to Azure. The solution must meet the following requirements:
- Ensure that the database is hosted in the West US region.
- Minimize any changes to the current network infrastructure.
- Minimize the amount of time required to migrate the database.
What is the best recommendation to achieve the goal? More than one answer choice may achieve the goal.
Select the BEST answer.
Correct Answer: A
Question 11
Your company identifies a stored procedure that runs slowly.
You review the execution plan for the stored procedure, and you discover the properties of a Clustered Index Scan operator as shown in the exhibit. (Click the Exhibit button.)
The stored procedure contains the following code.
You need to improve the performance of the stored procedure.
What should you do?
You review the execution plan for the stored procedure, and you discover the properties of a Clustered Index Scan operator as shown in the exhibit. (Click the Exhibit button.)
The stored procedure contains the following code.
You need to improve the performance of the stored procedure.
What should you do?
Correct Answer: B
Question 12
You have a Microsoft Azure virtual machine that has Microsoft SQL Server installed.
You need to increase the disk space available to store database files on the virtual machine.
Which three 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.
You need to increase the disk space available to store database files on the virtual machine.
Which three 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.
Correct Answer:
Explanation
Question 13
You plan to deploy a data platform solution for 4 TB of data. The solution will be used to generate analytic reports during business hours only. All reports will be generated by using Microsoft Excel.
You need to recommend a data platform for the data. The solution must minimize costs and provide the highest possible read performance.
Which data platform should you recommend?
You need to recommend a data platform for the data. The solution must minimize costs and provide the highest possible read performance.
Which data platform should you recommend?
Correct Answer: C
