What is the best design to achieve the goal?

You have an organizational data mart that contains 3.5 TB of uncompressed data.The size of the data is expected to grow 2 ТВ annually. Reporting is performed only during business hours.You plan to move the data to the cloud.You need to design a cloud architecture for the data mart. The solution must minimize costs and […]

Read More

You need to provide additional resources to the data warehouse.

You have a Microsoft Azure SQL data warehouse.During peak usage, you discover that the data warehouse fails to meet performance expectations.You need to provide additional resources to the data warehouse.What should you do? A. Create an additional storage pool. B. Create an elastic database pool. C. Increase the number of Database Throughput Units (DTUs). D. […]

Read More

Which two server roles should you deploy to Azure?

You have a hybrid Microsoft SQL Server environment that has multiple servers and services that run in bothMicrosoft Azure and on-premises.It the network fails, you need to ensure that users can authenticate and connect to the resources available inAzure.Which two server roles should you deploy to Azure? Each correct answer presents part of the solution. […]

Read More

Which two actions should you perform?

You have an on-premises Microsoft SQL Server 2014 database in an AlwaysOn availability group.You are planning a backup solution for the database. Backups will run on a secondary replica.You need to create a backup procedure for the database. The solution must ensure that the backups are storedon-premises and in Microsoft Azure Blob storage.Which two actions […]

Read More

Which four actions should you perform in sequence?

DRAG DROPYou have four Microsoft Azure SQL databases located on the same database server.You need to configure the databases to be in an elastic database pool.Which four actions should you perform in sequence? To answer, move the appropriate actions from the list ofactions to the answer area and arrange them in the correct order.NOTE: More […]

Read More

What should you include in the recommendation?

You have a Microsoft Azure SQL database. The database is hosted in the West US region and uses thePremium 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 tocomplete. The reports […]

Read More

You need to reduce the amount of time it takes to complete the reports.

You have a Microsoft Azure SQL database that is used for reporting.You discover that some reports complete more quickly than other reports, even though the reports retrieveapproximately the same amount of data and use queries that have the same table structure.You need to reduce the amount of time it takes to complete the reports.What should […]

Read More