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

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?

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

You need to deploy a new Microsoft Azure SQL database that must meet the following requirements:
* Will be available it a single Azure region becomes unavailable
* Will be able to fail over to another Azure region automatically
Which two configuration tasks should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

Your organization contains several Microsoft Azure SQL databases.
You need to ensure that an administrator is notified when SQL injection is detected on one of the databases.
Which two features should you enable? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

解説: (GoShiken メンバーにのみ表示されます)
You need to implement a solution to meet the technical requirements for the encryption of the data in Appl.
Which two features should you enable? Each correct answer presents pan of the solution. NOTE: Each correct selection is worth one point

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

Which database platform should App3 use?

You have several SQL Server instances on Microsoft Azure virtual machines.
Periodically, one of the virtual machines runs more slowly than expected. The issue typically persists for up to
30 minutes. You investigate the issue and discover that when the issue occurs, there is high CPU usage on the virtual machines.
You need to be notified automatically when the performance issue occurs. You want to achieve this goal by using the minimum amount of administrative effort.
What should you configure?

解説: (GoShiken メンバーにのみ表示されます)
Your company has a Microsoft Azure subscription that contains an AlwaysOn availability group. The availability group contains a single database named DB1.
You recently forced a manual failover of the availability group.
You discover that DB1 on a secondary replica has a status of Not Synchronizing.
You need to ensure that DB1 synchronizes correctly.
What should you do?

解説: (GoShiken メンバーにのみ表示されます)
A solution for the data warehouse system must be created to provide disaster recovery between SQL03 and an Azure virtual machine named SQL04.
You are designing the data warehouse.
You need to recommend a solution that meets the business goals and the technical requirements.
What should you recommend?