Microsoft Designing and Implementing Cloud Data Platform Solutions - 070-473 Exam Questions
QUESTION NO: 1
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 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.
Correct Answer:
Explanation
QUESTION NO: 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 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.
Correct Answer: B,D
QUESTION NO: 3
You need to design a security strategy to support the planned changes for the customer databases, The solution must meet the security requirements.
Which two security roles should you grant to the customers? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You need to design a security strategy to support the planned changes for the customer databases, The solution must meet the security requirements.
Which two security roles should you grant to the customers? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Correct Answer: C,D
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 4
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 have a Microsoft Azure Database for MySQL Server named SQLDB1.
Four database administrators manage SQLDB1.
You need to prevent any administrator from deleting the server that hosts SQLDB1.
Solution: You create a delete lock on the server resource in Azure.
Does this meet the goal?
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 have a Microsoft Azure Database for MySQL Server named SQLDB1.
Four database administrators manage SQLDB1.
You need to prevent any administrator from deleting the server that hosts SQLDB1.
Solution: You create a delete lock on the server resource in Azure.
Does this meet the goal?
Correct Answer: B
QUESTION NO: 5
Relecloud recently implemented the planned changes.
you plan to add a new customer named Fabrikam, Inc.
You need to ensure that the administrators at Fabrikam can access their data after the data loading process.
You collect the IP addresses used by the Fabrikam administrators.
Which Transact-SQL command or Azure PowerShell cmdlet should you use next?
Relecloud recently implemented the planned changes.
you plan to add a new customer named Fabrikam, Inc.
You need to ensure that the administrators at Fabrikam can access their data after the data loading process.
You collect the IP addresses used by the Fabrikam administrators.
Which Transact-SQL command or Azure PowerShell cmdlet should you use next?
Correct Answer: D
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 6
You have an application named App1 that connects to a Microsoft Azure SQL database named AppDB1.
App1 uses columnstore indexes as part of the database schema.
You plan to deploy another Azure SQL database named AppDBDev that will be used as the development environment for Appl.
You create a copy of AppDBl for AppDBDev.
You need to identify which service tier must be used to store AppDBDev. The solution must minimize the cost to store AppDBDev.
Which service tier should you identify?
You have an application named App1 that connects to a Microsoft Azure SQL database named AppDB1.
App1 uses columnstore indexes as part of the database schema.
You plan to deploy another Azure SQL database named AppDBDev that will be used as the development environment for Appl.
You create a copy of AppDBl for AppDBDev.
You need to identify which service tier must be used to store AppDBDev. The solution must minimize the cost to store AppDBDev.
Which service tier should you identify?
Correct Answer: D
QUESTION NO: 7
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.
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.
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
QUESTION NO: 8
Your company has a Microsoft Azure subscription that contains 20 Azure SQL databases on a single Microsoft SQL Server.
You need to ensure that you can aggregate results from the databases in a single query.
Which five components should you create in sequence? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.
Your company has a Microsoft Azure subscription that contains 20 Azure SQL databases on a single Microsoft SQL Server.
You need to ensure that you can aggregate results from the databases in a single query.
Which five components should you create in sequence? To answer, move all 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/azure/sql-database/sql-database-elastic-query-horizontal-partitioning
QUESTION NO: 9
A marketing department manager reports that the marketing department database contains incorrect data. The manager reports that the data was correct yesterday.
You need to recommend a method to recover the data.
Which three actions should you recommend be performed in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
A marketing department manager reports that the marketing department database contains incorrect data. The manager reports that the data was correct yesterday.
You need to recommend a method to recover the data.
Which three actions should you recommend be performed 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 NO: 10
You have Microsoft SQL Server installed on a Microsoft Azure virtual machine named VM1. VM1 is provisioned by using the classic deployment model and is on the Standard GS5 service tier.
The virtual machine is used for testing purposes only.
You need to minimize the costs associated with VM1 when the virtual machine is unused.
Which command should you use?
You have Microsoft SQL Server installed on a Microsoft Azure virtual machine named VM1. VM1 is provisioned by using the classic deployment model and is on the Standard GS5 service tier.
The virtual machine is used for testing purposes only.
You need to minimize the costs associated with VM1 when the virtual machine is unused.
Which command should you use?
Correct Answer: B
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 11
You need to create a Microsoft Azure Resource manager template.
Which file format should you use?
You need to create a Microsoft Azure Resource manager template.
Which file format should you use?
Correct Answer: B
