Microsoft Designing and Implementing Cloud Data Platform Solutions (070-473) Free Practice Test
Question 1
You need to recommend a solution to host a database in Microsoft Azure. The solution must meet the following requirements:
* Backups can be performed from a non-production node.
* Premium storage is used.
Which high-availability and storage redundancy solutions should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
* Backups can be performed from a non-production node.
* Premium storage is used.
Which high-availability and storage redundancy solutions should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Correct Answer:
Question 2
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
Question 3
You have a hybrid Microsoft SQL Server environment that has multiple servers and services that run in both Microsoft Azure and on-premises.
If the network fails, you need to ensure that users can authenticate and connect to the resources available in Azure.
Which two server roles should you deploy to Azure? Each correct answer presents part of the solution.
If the network fails, you need to ensure that users can authenticate and connect to the resources available in Azure.
Which two server roles should you deploy to Azure? Each correct answer presents part of the solution.
Correct Answer: A,E
Question 4
You need to recommend a backup solution for the ListTest database. What should you include in the recommendation?
Correct Answer: D
Question 5
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:
Question 6
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: A
Question 7
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: E
Question 8
You have an AlwaysOn availability group between several Microsoft Azure virtual machines.
You need to ensure that the databases meet the following requirements:
The solution must prevent any disruption to replication.
Which four actions should you perform in sequence? I 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 the databases meet the following requirements:
The solution must prevent any disruption to replication.
Which four actions should you perform in sequence? I 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://blogs.msdn.microsoft.com/alwaysonpro/2014/01/28/how-to-enable-tde-encryption-on-a-database-in-an-av
Question 9
Your company has a data warehouse that contains a database named DB1.
You plan to implement data encryption for DB1.
You need to configure DB1 to meet the following requirements:
* Prevent the system administrators of App1 from reading the Personally Identifiable Information (PII) stored in DB1.
* Ensue that all backups are Stored in an on-premises local drive for three days.
* Ensure that all backups are stored in a remote location for 10 days.
* Encrypt all backups.
All solution must support the ODBC Driver for Microsoft SQL Server 2012.
Which two solutions should you implement for DB1? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You plan to implement data encryption for DB1.
You need to configure DB1 to meet the following requirements:
* Prevent the system administrators of App1 from reading the Personally Identifiable Information (PII) stored in DB1.
* Ensue that all backups are Stored in an on-premises local drive for three days.
* Ensure that all backups are stored in a remote location for 10 days.
* Encrypt all backups.
All solution must support the ODBC Driver for Microsoft SQL Server 2012.
Which two solutions should you implement for DB1? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Correct Answer: A,D
Question 10
You have a Microsoft Azure SQL database named Database1.
You need to implement the Always Encrypted feature for Database1.
In which sequence should you execute the code blocks? To answer, move all the code blocks from the list of code blocks to the answer area and arrange them in the correct order.
You need to implement the Always Encrypted feature for Database1.
In which sequence should you execute the code blocks? To answer, move all the code blocks from the list of code blocks to the answer area and arrange them in the correct order.
Correct Answer:
Explanation
Question 11
You need to migrate DB2 to Azure.
Which utility should you use for each task? To answer, drag the appropriate utilities to the correct tasks. Each utility may be used once, more than once, or not at all. You made need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Which utility should you use for each task? To answer, drag the appropriate utilities to the correct tasks. Each utility may be used once, more than once, or not at all. You made need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation
Box 1: mysqldump
Use common utilities and tools such as MySQL Workbench, mysqldump, Toad, or Navicat to remotely connect and restore data into Azure Database for MySQL.
Box 2: azcopy
AzCopy is a command-line tool for copying data to or from Azure Blob storage, Azure Files, and Azure Table storage, by using simple commands. The commands are designed for optimal performance. You can copy data between a file system and a storage account, or between storage accounts.
App2 is developed by using third-party open source code that is updated frequently. The database for App2 is named DB2. App2 only supports MySQL.
Reference:
https://docs.microsoft.com/en-us/azure/mysql/concepts-migrate-import-export
https://docs.microsoft.com/en-us/azure/storage/common/storage-use-azcopy-migrate-on-premises-data?tabs=win