최신 070-473 무료덤프 - Microsoft Designing and Implementing Cloud Data Platform Solutions
You need to implement monitoring for the ListTest database.
Which three statements should you use in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.
Which three statements should you use in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.
정답:
Explanation
Your environment contains a Microsoft Azure virtual machine and an Azure SQL database. The virtual machine has Microsoft SQL Server installed and contains several applications. You need to recommend a solution to migrate one of the applications to the Azure SQL database. The solution must minimize downtime.
Which solution should you recommend?
Which solution should you recommend?
정답: B
You need to recommend a database strategy to support the planned new customers. The solution must minimize costs.
What should you recommend?
What should you recommend?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)
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 SQL Server instance on a Microsoft Azure virtual machine.
The members of an Active Directory group named HelpDesk can log in to the SQL Server instance.
You need to ensure that the members of HelpDesk can query dynamic management views and gather performance metrics from the SQL Server instance.
Which three actions should you perform? Each correct answer presents part of the solution.
The members of an Active Directory group named HelpDesk can log in to the SQL Server instance.
You need to ensure that the members of HelpDesk can query dynamic management views and gather performance metrics from the SQL Server instance.
Which three actions should you perform? Each correct answer presents part of the solution.
정답: B,C,E
설명: (DumpTOP 회원만 볼 수 있음)
You are provisioning a virtual machine in Microsoft Azure to host a Microsoft SQL Server database named DB1.
The tempdb database on the SQL server is not expected to grow to more than 20 GB during the next five years.
You add a 1-TB disk to the virtual machine and configure the disk as drive F.
The disk is not configured for read or write caching.
You need to reduce the amount of time required to read data from DB1 and tempdb.
On which drive should you place each database? To answer, select the appropriate options in the answer area.
The tempdb database on the SQL server is not expected to grow to more than 20 GB during the next five years.
You add a 1-TB disk to the virtual machine and configure the disk as drive F.
The disk is not configured for read or write caching.
You need to reduce the amount of time required to read data from DB1 and tempdb.
On which drive should you place each database? To answer, select the appropriate options in the answer area.
정답:
Explanation
You are implementing a new Microsoft SQL Server environment on a Microsoft Azure virtual machine. The environment has the following requirements:
Database backups must be encrypted.
Database backups must be retained for 10 years.
Database backups must be restored daily to a development environment.
You need to recommend solutions to meet the requirements. The solutions must minimize cost.
Which solution should you recommend for each requirement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Database backups must be encrypted.
Database backups must be retained for 10 years.
Database backups must be restored daily to a development environment.
You need to recommend solutions to meet the requirements. The solutions must minimize cost.
Which solution should you recommend for each requirement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
정답:
Explanation
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?
정답: A
You have Microsoft SQL Server installed on a Microsoft Azure virtual machine. The virtual machine is on the Standard D3 service tier. All of the data files for the databases on the virtual machine are located on a single volume that is mounted as drive E.
The virtual machine experiences performance issues.
You view the wait statistics and discover a high number of GEIOLATCH_SH waits associated to the tempdb data files.
You need to resolve the performance issues.
What should you do?
The virtual machine experiences performance issues.
You view the wait statistics and discover a high number of GEIOLATCH_SH waits associated to the tempdb data files.
You need to resolve the performance issues.
What should you do?
정답: A
Your company has two offices. The offices are located in London and New York.
The London office has a public IP of 131.107.1.1 and a private IP subnet of 192.168.4.0/24. The New York office has a public IP of 131.107.15.1 and a private IP subnet of 192.168.8.0/24.
You have a Microsoft SQL Server database that is hosted on a Microsoft Azure virtual machine. Currently, only the users in the London office use the database.
You need to create a new firewall rule to provide the users in the New York office with access to the database.
The solution must protect the database from being accessed by users on the public Internet.
What should you do?
The London office has a public IP of 131.107.1.1 and a private IP subnet of 192.168.4.0/24. The New York office has a public IP of 131.107.15.1 and a private IP subnet of 192.168.8.0/24.
You have a Microsoft SQL Server database that is hosted on a Microsoft Azure virtual machine. Currently, only the users in the London office use the database.
You need to create a new firewall rule to provide the users in the New York office with access to the database.
The solution must protect the database from being accessed by users on the public Internet.
What should you do?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)