QUESTION NO: 1
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.
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.
Correct Answer: D,E
Vote an answer
QUESTION NO: 2
Users at Relecloud report slow performance when viewing reports from AzD801.
You need to identify the cause of the performance issue as quickly as possible.
Which dynamic management view and performance monitor counter should you use? To answer, select the appropriate options in the answers area.
NOTE: Each correct selection is worth one point.
Users at Relecloud report slow performance when viewing reports from AzD801.
You need to identify the cause of the performance issue as quickly as possible.
Which dynamic management view and performance monitor counter should you use? To answer, select the appropriate options in the answers area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation
Box 1: Sys.dm_io_virtual_file_stats
Sys.dm_io_virtual_file_stats returns I/O statistics for data and log files.
Box 2:
Page reads/sec indicates the number of physical database page reads that are issued per second. This statistic displays the total number of physical page reads across all databases. Because physical I/O is expensive, you may be able to minimize the cost, either by using a larger data cache, intelligent indexes, and more efficient queries, or by changing the database design.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-io-virtual-
https://docs.microsoft.com/en-us/sql/relational-databases/performance-monitor/monitor-cpu-usage?view=sql-ser
QUESTION NO: 3
You need to recommend a solution to meet the network requirement.
What should you recommend?
You need to recommend a solution to meet the network requirement.
What should you recommend?
Correct Answer: C
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 4
You are planning the migration of SQL01 to an Azure virtual machine.
You need to identify which service tier to use for the virtual machine. The solution must meet the business goals and the technical requirements.
Which virtual machine service tier should you identify?
You are planning the migration of SQL01 to an Azure virtual machine.
You need to identify which service tier to use for the virtual machine. The solution must meet the business goals and the technical requirements.
Which virtual machine service tier should you identify?
Correct Answer: C
Vote an answer
QUESTION NO: 5
You have an AlwaysOn availability group between several Microsoft Azure virtual machines.
You need to ensure that the databases meet the following requirements:
The solution must prevent any disruption to replication.
Which four actions should you perform in sequence? I answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You have an AlwaysOn availability group between several Microsoft Azure virtual machines.
You need to ensure that the databases meet the following requirements:
The solution must prevent any disruption to replication.
Which four actions should you perform in sequence? I answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Correct Answer:
Explanation
References:
https://blogs.msdn.microsoft.com/alwaysonpro/2014/01/28/how-to-enable-tde-encryption-on-a-database-in-an-av
QUESTION NO: 6
You are evaluating the migration of the databases from Host1 and WebData1 to Azure.
You need to recommend the most cost-effective solution for storing the database in Azure. The solution must meet the business requirements.
In the table below, recommend the most cost-effective storage solution for Host1 and WebData1. NOTE:
Make only one selection in each column.
You are evaluating the migration of the databases from Host1 and WebData1 to Azure.
You need to recommend the most cost-effective solution for storing the database in Azure. The solution must meet the business requirements.
In the table below, recommend the most cost-effective storage solution for Host1 and WebData1. NOTE:
Make only one selection in each column.
Correct Answer:
Explanation
QUESTION NO: 7
You have Microsoft SQL Server installed on a Microsoft on a Microsoft Azure virtual machine.
One of the databases on the virtual machine supports a highly active Online Transaction Processing (OLTP) application.
Users report abnormally long wait times when they submit data in the application.
Which two tools can you use to identity the longest running queries? Each correct answer presents a complete solution.
You have Microsoft SQL Server installed on a Microsoft on a Microsoft Azure virtual machine.
One of the databases on the virtual machine supports a highly active Online Transaction Processing (OLTP) application.
Users report abnormally long wait times when they submit data in the application.
Which two tools can you use to identity the longest running queries? Each correct answer presents a complete solution.
Correct Answer: A,D
Vote an answer
QUESTION NO: 8
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: 9
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?
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?
Correct Answer: B
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 10
You have a Microsoft Azure SQL database named DB1 and a copy of DB1 named DB1Test.
You use DB1Test to test the deployment of major updates to the database.
You discover that DB1Test contains outdated data.
You need to ensure that DB1Test contains recent data from DB1.
Which two statements should you execute? Each correct answer presents part of the solution.
Not: Each correct selection is worth one point.
You have a Microsoft Azure SQL database named DB1 and a copy of DB1 named DB1Test.
You use DB1Test to test the deployment of major updates to the database.
You discover that DB1Test contains outdated data.
You need to ensure that DB1Test contains recent data from DB1.
Which two statements should you execute? Each correct answer presents part of the solution.
Not: Each correct selection is worth one point.
Correct Answer: C,D
Vote an answer
QUESTION NO: 11
You hire a new employee to assist in the management of a Microsoft Azure SQL database.
You need to ensure that the employee can query dynamic management views.
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 hire a new employee to assist in the management of a Microsoft Azure SQL database.
You need to ensure that the employee can query dynamic management views.
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.
Correct Answer:
Explanation
References:
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-monitoring-with-dmvs/
QUESTION NO: 12
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: A,C
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 13
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
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
Correct Answer: C,D
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 14
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 named DB1.
You need to monitor DB1 to identity all regressed queries.
Which command should you use?
Correct Answer: D
Vote an answer