NEW QUESTION NO: 10
DRAG DROP
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.

Answer: 


NEW QUESTION NO: 11
DRAG DROP
You need to back up the Listings database to meet the high-availability and recovery requirements.
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.

Answer: 


NEW QUESTION NO: 12
You recently implemented a Microsoft Azure SQL data warehouse.
You discover that during peak hours, the data warehouse takes longer than expected to generate reports.
You need to reduce the amount of time it takes to generate the reports.
What should you do from the Azure portal?
A. Increase the number of Data Warehouse Units (DWUs).
B. Increase the number of Database Throughput Units (DTUs).
C. Add storage to the data warehouse.
Answer: B

NEW QUESTION NO: 13
You are planning the consolidation of the databases from Host1.
You need to identify which methods to use to back up the data after the consolidation completes. What are two possible methods that achieve this goal? Each correct answer presents a complete solution.
A. BACKUP TO URL
B. a maintenance plan
C. AlwaysOn Availability Groups
D. AlwaysOn failover clustering
Answer: A,B

NEW QUESTION NO: 14
You need to configure a runbook to execute when a Microsoft Azure SQL database uses more than 80 percent of the Database Throughput Unit (DTU) resources.
What should you configure in the runbook?
A. a job
B. a connection
C. a webhook
D. a trigger
Answer: C

NEW QUESTION NO: 15
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?
A. Change the service tier of the virtual machine to Standard D12.
B. Move the tempdb data files to drive C.
C. Move the tempdb data files to drive D.
D. Change the service tier of the virtual machine to Standard DS3.
Answer: C

NEW QUESTION NO: 16
Your company has a Microsoft Azure MySQL database that is used by an Azure Web App.
The logical server that hosts the database contains other databases.
You move the database to another Azure tenant.
You need to ensure that the Web App can access the database.
What should you do?
A. Create a server-level firewall rule.
B. Create a database-level firewall rule.
C. Modify the SSL settings for the database server.
D. Add an Azure virtual network gateway.
Answer: A

NEW QUESTION NO: 17
You have a Microsoft Azure SQL database. The database is hosted in the West US region and uses the Premium service tier. Users of the database are located in Los Angeles, New York, and Singapore.
The users in Singapore report that when they run reports against the database, the reports take a long time to complete. The reports contain thousands of rows.
You need to recommend a solution to resolve the performance issue. The solution must maintain the performance for the other users. What should you include in the recommendation?
A. Move the Azure SQL database from the West US region to the East Asia region.
B. Configure pagination for the report.
C. Configure a readable geo-replica in the East Asia region.
D. Implement Azure ExpressRoute for the subscription.
Answer: C

NEW QUESTION NO: 18
You need to recommend a solution to migrate the Listings database to the cloud.
What should you recommend?
A. Run a full backup during the outage and restore the backup to the Azure virtual machine.
B. Stage the Listings database on an Azure virtual machine prior to the outage. During the outage, perform a data import from the main office by using SQL Server Management Studio.
C. Implement log-shipping between the main office and an Azure virtual machine prior to the migration date. During the planned outage, perform a final log backup, restore the backup to the secondary, and then switch the secondary to the primary role.
D. Implement merge replication between the main office and the Azure virtual machine.
Answer: C

NEW QUESTION NO: 19
You have an application that uses a Microsoft SQL Server database on a Microsoft Azure virtual machine.
The application experiences performance issues, which you suspect are related to the connection pooling. The issues are prevalent only when there are more than 150 concurrent connections.
You need to identify whether the performance issues are related to the connection pooling.
Which dynamic management view should you query?
A. sys.dm_os_memory_pools
B. sys.dm_exec_requests
C. sys.dm_exec_connections
D. sys.dm_exec_sessions
Answer: D
References:
https://blogs.msdn.microsoft.com/sql_pfe_blog/2013/10/08/connection-pooling-for-the-sql- server-dba/

NEW QUESTION NO: 20
A solution for the data warehouse system must be created to provide disaster recovery between SQL03 and an Azure virtual machine named SQL04.
You need to recommend an auditing solution that meets the business goals.
Which three events should you include in the recommendation? Each correct answer presents part of the solution.
A. Stored Procedure
B. Transaction Management
C. Plain SQL
D. Failed Connections
E. Login
Answer: A,B,E