- All Exams Instant Download
Which type of compression provides the greatest space reduction for the database?
You have an Azure SQL database that contains a table named factSales. FactSales contains the columns shown in the following table. FactSales has 6 billion rows and is loaded nightly by using a batch process. Which type of compression provides the greatest space reduction for the database?A . page compression...
Which two resources should you create in the subscription?
You have an Azure subscription that contains 50 instances of SQL Server on Azure Virtual Machines. The instances host 500 Azure SQL databases. You need to ensure that all the databases have the same configuration. The solution must meet the following requirements: • Auditing must be enabled. • Azure Defender...
You have an Azure SQL logical server
HOTSPOT You have an Azure SQL logical server. You run the following script. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. View AnswerAnswer:
Which three actions should you perform in sequence?
DRAG DROP You need to configure user authentication for the SERVER1 databases. The solution must meet the security and compliance 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...
What is the total number of data files that tempdb should contain?
You have SQL Server 2019 on an Azure virtual machine that runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory. You scale up the virtual machine to 16 vCPUSs and 64 GB of memory. You need to provide the lowest latency for tempdb. What...
Does this meet the goal?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you...
Which SQL deployment options should you select as the master server (MSX) and the target server (TSX)?
HOTSPOT You have an Azure subscription. You plan to migrate 10 on-premises Microsoft SQL Server instances to Azure. You need to ensure that the migrated environment can be managed by using multiserver administration and supports master/target (MSX/TSX) jobs. The solution must minimize administrative effort. Which SQL deployment options should you...
You have an Azure SQL database named DB1
HOTSPOT You have an Azure SQL database named DB1. The automatic tuning options for DB1 are configured as shown in the following exhibit. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation:...
Which should you include in the solution?
You are designing an anomaly detection solution for streaming data from an Azure IoT hub. The solution must meet the following requirements: ✑ Send the output to an Azure Synapse. ✑ Identify spikes and dips in time series data. ✑ Minimize development and configuration effort. Which should you include in...
Which four actions should you perform in sequence?
DRAG DROP You need to implement statistics maintenance for SalesSQLDb1. The solution must meet the technical requirements. 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. View AnswerAnswer: Explanation:...
