Microsoft Designing and Implementing Cloud Data Platform Solutions - 070-473 Exam Practice Test
You need to prepare the Azure environment for the planned migration of DB1. The solution must meet the requirements of the finance department.
Which two tasks should you perform in Azure? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Which two tasks should you perform in Azure? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Correct Answer: B,C
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
You have a Microsoft SQL Server instance that hosts a database named DB1.
You plan to back up DB1 to Microsoft Azure Blob storage. You need to configure the required access to Azure blob storage for the planned backup.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You plan to back up DB1 to Microsoft Azure Blob storage. You need to configure the required access to Azure blob storage for the planned backup.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Correct Answer: A,C
Vote an answer
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?
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?
Correct Answer: B
Vote an answer
You need to recommend a solution to meet the reporting requirements of App3.
What should you include in the recommendation?
What should you include in the recommendation?
Correct Answer: C
Vote an answer
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.
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=
You have a Microsoft Azure virtual machine that hosts a Microsoft SQL Server database instance. Users report that during peak workloads, the database is slower than expected.
You query sys.dm_os_waiting_tasks and you discover that there are a high number of PAGEIOLATCH waits.
You need to receive an alert if the storage on the Azure virtual machine is throttled.
What should you use?
You query sys.dm_os_waiting_tasks and you discover that there are a high number of PAGEIOLATCH waits.
You need to receive an alert if the storage on the Azure virtual machine is throttled.
What should you use?
Correct Answer: A,D
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
You are evaluating moving the data from WebData1 to an Azure SQL database.
You need to recommend a solution to generate the consolidated report for billing. The solution must meet the business requirements.
What should you include in the recommendation?
You need to recommend a solution to generate the consolidated report for billing. The solution must meet the business requirements.
What should you include in the recommendation?
Correct Answer: A
Vote an answer
You plan to deploy a Microsoft Azure SQL database named DB1 to support a new application named Appl.
You need to recommend a solution for DB1 that meets the following requirements if a single region fails:
* DB1 must remain available.
* App1 must reconnect automatically.
What should you recommend implementing to meet each requirement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You need to recommend a solution for DB1 that meets the following requirements if a single region fails:
* DB1 must remain available.
* App1 must reconnect automatically.
What should you recommend implementing to meet each requirement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation
References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-geo-replication-overview
You have an organizational data mart that contains 3.5 TB of uncompressed data.
The size of the data is expected to grow 2 annually. Reporting is performed only during business hours.
You plan to move the data to the cloud.
You need to design a cloud architecture for the data mart. The solution must minimize costs and administrative overhead.
What is the best design to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.
The size of the data is expected to grow 2 annually. Reporting is performed only during business hours.
You plan to move the data to the cloud.
You need to design a cloud architecture for the data mart. The solution must minimize costs and administrative overhead.
What is the best design to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.
Correct Answer: C
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
You have an Azure SQL Database elastic database pool that contains two databases named database1 and database2.
Users of database1 report poor performance during peak business hours.
You discover that database2 consumes most of the available resources.
You need to resolve the performance issue.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Users of database1 report poor performance during peak business hours.
You discover that database2 consumes most of the available resources.
You need to resolve the performance issue.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Correct Answer: C,D
Vote an answer
You need to identify which methods to use to migrate MovieReviewDB and CWDB.
Which method should you identify for each database? To answer, select the appropriate options in the answer area.
Which method should you identify for each database? To answer, select the appropriate options in the answer area.
Correct Answer:
Explanation
References:
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-cloud-migrate-compatible-using-ssms-mi
Topic 3, Contoso, Ltd.Overview
Contoso, Ltd. is a national scientific research company that has sales, marketing, and research departments.
Contoso has a main office in Dallas and more than 20 satellite offices across the United States. Some employees work off-site at customer locations.
Contoso is expected to double in size during the next two years.
Existing Environment
The Microsoft SQL Server environment contains the servers configured as shown in the following table.
Contoso currently uses SQL Server 2008 R2 on all of the database servers. SQL01 currently requires six cores and 50 GB of memory.
Once a day, database snapshots are taken on the mirror to provide ad hoc reporting and to load the data warehouse.
One report is used for ad hoc reporting by using the mirrored copy of the OLTP database.
Research Gen II is a Windows application that users currently access by using Remote Desktop.
Requirements
Business Goals
Contoso identifies the following business goals:
Planned changes
Contoso plans to implement the following changes:
Departmental Requirements
Senior research project leaders must be able to upload databases to the cloud. Initially, the databases will be less than 3 GB. Some databases may grow to 50 GB. The databases must be recoverable to any point during the past two weeks.
The research project leaders must monitor the performance of their databases. They must view statistics, such as query performance and overall database performance.
The marketing department plans to use cloud services to host web applications for marketing campaigns. The databases for the web applications have the requirements shown in the following table.
Technical Requirements
Contoso identifies the following technical requirements:
You have a Microsoft Azure SQL database named DB1 attached to a server named Server 1. A web application named App1 connects to Server1.
You configure Active Geo-Replication for DB1. For the replica, you deploy another Azure SQL database server named ServerFailover to a different region.
You plan to use a failover group named FG1 that will have a read-write listener.
You need to configure App1 to reconnect to the database automatically after a failover.
Which value should you include in the connection string of App1?
You configure Active Geo-Replication for DB1. For the replica, you deploy another Azure SQL database server named ServerFailover to a different region.
You plan to use a failover group named FG1 that will have a read-write listener.
You need to configure App1 to reconnect to the database automatically after a failover.
Which value should you include in the connection string of App1?
Correct Answer: C
Vote an answer