070-473試験無料問題集「Microsoft Designing and Implementing Cloud Data Platform Solutions 認定」

You need to create a Microsoft Azure Resource manager template.
Which file format should you use?

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.
正解:

Explanation
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 remove the Delete permission for SQLDB1 from the Azure portal.
Does this meet the goal?

You plan to move a database to Microsoft Azure.
Users of the database will be located in the United States, Europe, and Asia. All modifications to the database will originate from the United States.
You need to recommend a database solution that will minimize latency for all of the users. The solution must minimize costs.
What should you recommend? To answer, drag the appropriate solutions to the correct locations. Each solution 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.
NOTE: Each correct selection is worth one point.
正解:

Explanation
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.

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 have a Microsoft Azure SQL database named DB1.
You need to monitor DB1 to identity all regressed queries.
Which command should you use?

You have a Microsoft Azure SQL database. You need to audit the data access of the database owners who use Microsoft SQL Server Management Studio.
What should you enable?

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.

解説: (GoShiken メンバーにのみ表示されます)
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.