최신 070-473 무료덤프 - Microsoft Designing and Implementing Cloud Data Platform Solutions
Your environment contains a Microsoft Azure machine that has Microsoft SQL Server Standard installed.
An application named App1 uses the data stored in SQL server. The Service level Agreement (SLA) for App1 states that the application can lose a maximum of 10 minutes of data and that the data must be available if two Azure regions fail.
You need to implement a solution that provides disaster recovery for App1.
In two other Azure regions, you deploy an Azure virtual machine that has SQL Server installed.
What should you implement next?
An application named App1 uses the data stored in SQL server. The Service level Agreement (SLA) for App1 states that the application can lose a maximum of 10 minutes of data and that the data must be available if two Azure regions fail.
You need to implement a solution that provides disaster recovery for App1.
In two other Azure regions, you deploy an Azure virtual machine that has SQL Server installed.
What should you implement next?
정답: A
You have a Microsoft Azure virtual machine that has Microsoft SQL Server installed. The virtual machine contains five databases. You need to identify whether the performance of queries to the databases has degraded during the last two weeks. Which SQL Server feature should you use?
정답: B
You have 10 Microsoft Azure SQL databases.
One of the databases is named DB1.
You need to ensure that only a specific IP address can be used to access DB1. The solution must affect only DB1.
What should you use?
One of the databases is named DB1.
You need to ensure that only a specific IP address can be used to access DB1. The solution must affect only DB1.
What should you use?
정답: C
An Azure virtual machine named Server1 hosts an application named Appl. App1 uses a database named DB1.
You create a login named Login1 for Server1.
You need to create a user account in DB1 for Login1.
How should you complete the T-SQL query? To answer, drag the appropriate values to the correct targets.
Each value 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.
You create a login named Login1 for Server1.
You need to create a user account in DB1 for Login1.
How should you complete the T-SQL query? To answer, drag the appropriate values to the correct targets.
Each value 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.
정답:
You need to recommend a disaster recovery solution for the CRM application that meets the business requirements.
What should you recommend?
What should you recommend?
정답: A
You need to recommend a solution to implement high availability for the Listings database.
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.
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.
정답:
Explanation
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.
정답: B,E
You need to provision the database for DB2 in Azure.
How should you provision the database? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
How should you provision the database? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
정답:
Explanation
Box 1: Azure Database for MySQL
Azure Database for MySQL provides fully managed, enterprise-ready community MySQL database as a service.
Box 2:
Incorrect Answres:
Not Azure Database for MySQL
You can create an Azure Database for MySQL server in one of three different pricing tiers: Basic, General Purpose, and Memory Optimized.
Scenario: 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. None of the developers at Tailspin Toys are skilled in using MySQL. DB2 is supported by a team of external developers.
DB2 is 20 GB and is expected to reach 50 GB during the next five years. DB2 has a storage performance requirement of 200 IOPs.
DB2 must be highly available.
Reference:
https://docs.microsoft.com/en-us/azure/mysql/concepts-pricing-tiers
https://azure.microsoft.com/en-us/services/mysql/
Your Microsoft Azure environment contains an elastic pool that has 2,000 eDTUs. The current available storage for the pool is 500 GB. At 10:00 each morning, the databases in the pool are slow to respond to queries. You need to improve the response time of the databases. What should you do?
정답: B
You have an on-premises database hosted on a Microsoft SQL Server instance.
You plan to back up the database to Microsoft Azure.
You create a storage account in Azure for the backups.
You need to back up the database to Azure. The solution must ensure that the backups are encrypted before they are sent to Azure.
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.
You plan to back up the database to Microsoft Azure.
You create a storage account in Azure for the backups.
You need to back up the database to Azure. The solution must ensure that the backups are encrypted before they are sent to Azure.
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
