Microsoft Designing and Implementing Cloud Data Platform Solutions - 070-473 Exam Practice Test
You need to recommend a backup solution for the ListTest database. What should you include in the recommendation?
Correct Answer: D
Vote an answer
You are evaluating the migration of an on-premises Microsoft SQL server database to a Microsoft Azure SQL database.
You need to identity the minimum service tier required to host the database.
Which three metrics should you evaluate? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You need to identity the minimum service tier required to host the database.
Which three metrics should you evaluate? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Correct Answer: A,C,E
Vote an answer
You need to back up the Listings database to meet the high-availability and recovery 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
You have a Microsoft Azure SQL database.
You need to ensure that you can use the Always Encrypted feature for the database.
Which two components should you configure? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You need to ensure that you can use the Always Encrypted feature for the database.
Which two components should you configure? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Correct Answer: A
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You plan to migrate an on-premises database to Microsoft Azure. The planned deployment will include an Always On Failover Cluster Instance of Microsoft SQL Server.
You need to implement a storage solution for the planned deployment.
Which storage solution should you implement?
You need to implement a storage solution for the planned deployment.
Which storage solution should you implement?
Correct Answer: D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You have a Microsoft Azure SQL database.
You discover that the workload grows over time.
You are evaluating whether to switch to a higher service tier for the database.
You need to examine the system utilization trends over time.
Which dynamic management view should you query?
You discover that the workload grows over time.
You are evaluating whether to switch to a higher service tier for the database.
You need to examine the system utilization trends over time.
Which dynamic management view should you query?
Correct Answer: D
Vote an answer
Your company has a Microsoft Azure SQL database that is hosted in the West US region and uses the S1 performance level.
You need to ensure that the database is available as quickly as possible if the database is deleted accidentally.
The solution must minimize data loss.
What should you implement for the database?
You need to ensure that the database is available as quickly as possible if the database is deleted accidentally.
The solution must minimize data loss.
What should you implement for the database?
Correct Answer: A
Vote an answer
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
Vote an answer
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/
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
Vote an answer
You have an on-premises Microsoft SQL Server 2014 database in an AlwaysOn availability group.
You are planning a backup solution for the database. Backups will run on a secondary replica.
You need to create a backup procedure for the database. The solution must ensure that the backups are stored on-premises and in Microsoft Azure Blob storage.
Which two actions should you perform? Each correct answer presents part of the solution.
You are planning a backup solution for the database. Backups will run on a secondary replica.
You need to create a backup procedure for the database. The solution must ensure that the backups are stored on-premises and in Microsoft Azure Blob storage.
Which two actions should you perform? Each correct answer presents part of the solution.
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
A solution for the data warehouse system must be created to provide disaster recovery between SQL03 and an Azure virtual machine named SQL04.
You need to tell the research project leaders how to migrate their databases.
Which task should you instruct the leaders to use from SQL Server Management Studio?
You need to tell the research project leaders how to migrate their databases.
Which task should you instruct the leaders to use from SQL Server Management Studio?
Correct Answer: B
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You are designing a hybrid data analytics solution that contains an on-premises Microsoft SQL Server environment and a Microsoft Azure SQL data warehouse.
You need to load data warehouse from the SQL Server environment as quickly as possible.
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 load data warehouse from the SQL Server environment as quickly as possible.
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
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?
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?
Correct Answer: C
Vote an answer
A solution for the data warehouse system must be created to provide disaster recovery between SQL03 and an Azure virtual machine named SQL04.
You are designing the data warehouse.
You need to recommend a solution that meets the business goals and the technical requirements.
What should you recommend?
You are designing the data warehouse.
You need to recommend a solution that meets the business goals and the technical requirements.
What should you recommend?
Correct Answer: B
Vote an answer