What are two possible ways to identify the elastic database transaction units (eDTUs)?

You are evaluating whether an Azure SQL Database elastic database pool suits your workload and usage patterns. What are two possible ways to identify the elastic database transaction units (eDTUs)? Each correct answer presents a complete solution.A . Aggregate data from sys.dm_os_wait_stats.B . Run the Database Engine Tuning Advisor.C ....

June 17, 2019No CommentsREAD MORE +

Which three actions should you perform in sequence?

DRAG DROP You need to implement a storage architecture for the Azure virtual machines that will host the OLTP database. The solution must meet the business goals and the technical requirements. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions...

June 15, 2019No CommentsREAD MORE +

Which command should you execute?

Your company has two offices 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 Azure SQL...

June 12, 2019No CommentsREAD MORE +

What should you recommend?

You need to recommend a solution to migrate the Listings database to the cloud. What should you recommend?A . 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.B ....

June 12, 2019No CommentsREAD MORE +

Which method should you identify for each database?

Topic 1, Proseware, Inc. Overview General Overview Proseware, Inc. is a software engineering company that has 100 employees. Proseware has sales, marketing, accounts, human resources IT, and development departments. The IT department has one team dedicated to managing the internal resources and one team dedicated to managing customer resources, which...

June 10, 2019No CommentsREAD MORE +

Which two tasks should you perform in Azure?

You need to prepare the Azure environment for the planned migration of DB1. The solution must meet the requirements of the finance department. Which two tasks should you perform in Azure? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.A . Configure a...

June 9, 2019No CommentsREAD MORE +

How should you complete the policy?

DRAG DROP You plan to implement row-level security for the CWDB database. You create the fn_limitusers function under the restriction schema. You need to create the policy. How should you complete the policy? To answer, drag the appropriate elements to the correct locations. Each element may be used once, more...

June 9, 2019No CommentsREAD MORE +

Which three actions should you recommend be performed in sequence?

DRAG DROP 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. View AnswerAnswer:...

June 9, 2019No CommentsREAD MORE +

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?A . Standard D3B . Standard A7C...

June 7, 2019No CommentsREAD MORE +

Which dynamic management view and performance monitor counter should you use?

HOTSPOT 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...

June 7, 2019No CommentsREAD MORE +