<< Prev Question Next Question >>

Question 20/35

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?

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (35q)
Question 1: You have a failover cluster deployed to Microsoft Azure virt...
Question 2: Note: This question is part of a series of questions that pr...
Question 3: You have an organizational data mart that contains 3.5 TB of...
Question 4: You have a Microsoft Azure Infrastructure as a Service (IaaS...
Question 5: Relecloud recently implemented the planned changes. you plan...
Question 6: You have an application that uses a Microsoft SQL Server dat...
Question 7: A solution for the data warehouse system must be created to ...
Question 8: You have Microsoft SQL Server installed on a Microsoft Azure...
Question 9: DRAG DROP You have four Microsoft Azure SQL databases locate...
Question 10: You have a Microsoft Azure SQL database that is used for rep...
Question 11: You need to recommend a solution to migrate the Listings dat...
Question 12: You have an on-premises Microsoft SQL Server 2014 database i...
Question 13: A solution for the data warehouse system must be created to ...
Question 14: Your company has a Microsoft Azure MySQL database that is us...
Question 15: You are evaluating moving the data from WebData1 to an Azure...
Question 16: HOTSPOT You are evaluating the migration of the databases fr...
Question 17: DRAG DROP You need to recommend a solution to implement high...
Question 18: You are evaluating whether to replace CRM-B with an Azure vi...
Question 19: DRAG DROP You need to back up the Listings database to meet ...
Question 20: You recently implemented a Microsoft Azure SQL data warehous...
Question 21: You need to recommend a disaster recovery solution for the C...
Question 22: You have a hybrid Microsoft SQL Server environment that has ...
1 commentQuestion 23: HOTSPOT You need to migrate an on-premises postgreSQL databa...
Question 24: HOTSPOT You need to provision the database for DB2 in Azure....
Question 25: DRAG DROP A marketing department manager reports that the ma...
Question 26: You are planning the consolidation of the databases from Hos...
Question 27: HOTSPOT Your company has a Microsoft Azure subscription that...
Question 28: DRAG DROP You have a Microsoft Azure virtual machine that ho...
Question 29: DRAG DROP You are designing a hybrid data analytics solution...
Question 30: A solution for the data warehouse system must be created to ...
Question 31: You have an application named App1 that uses a Microsoft Azu...
Question 32: What should you use to schedule the nightly jobs to meet the...
Question 33: You have a Microsoft Azure SQL database. The database is hos...
Question 34: You have a Microsoft SQL Server instance on a Microsoft Azur...
Question 35: You need to configure a runbook to execute when a Microsoft ...