- All Exams Instant Download
Topic 2, Contoso Ltd
Topic 2, Contoso Ltd Case study This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to...
What should you do?
You have an Azure SQL database named sqldb1. You need to minimize the possibility of Query Store transitioning to a read-only state. What should you do?A . Halve the value of Data Flush Interval.B . Double the value of Statistics Collection Interval.C . Halve the value of Statistics Collection Interval.D...
What should you run as part of the implementation?
You need to implement authentication for ResearchDB1. The solution must meet the security and compliance requirements. What should you run as part of the implementation?A . CREATE LOGIN and the FROM WINDOWS clauseB . CREATE USER and the FROM CERTIFICATE clauseC . CREATE USER and the FROM LOGIN clauseD ....
Which restore option should you use on the secondary replica?
You have SQL Server on Azure virtual machines in an availability group. You have a database named DB1 that is NOT in the availability group. You create a full database backup of DB1. You need to add DB1 to the availability group. Which restore option should you use on the...
What should you use?
You plan to move two 100-GB databases to Azure. You need to dynamically scale resources consumption based on workloads. The solution must minimize downtime during scaling operations. What should you use?A . An Azure SQL Database elastic poolB . SQL Server on Azure virtual machinesC . an Azure SQL Database...
Which service should you use to ingest the data?
You are designing a streaming data solution that will ingest variable volumes of data. You need to ensure that you can change the partition count after creation. Which service should you use to ingest the data?A . Azure Event Hubs StandardB . Azure Stream AnalyticsC . Azure Data FactoryD ....
How should you configure the backup of DB1?
HOTSPOT You have an on-premises Microsoft SQL Server 2016 server named Server1 that contains a database named DB1. You need to perform an online migration of DB1 to an Azure SQL Database managed instance by using Azure Database Migration Service. How should you configure the backup of DB1? To answer,...
What should you do to ensure that the query uses the execution plan which executes in the least amount of time?
You have SQL Server on an Azure virtual machine that contains a database named DB1. You view a plan summary that shows the duration in milliseconds of each execution of query 1178902 as shown in the following exhibit: What should you do to ensure that the query uses the execution...
What should you do?
You have an Azure Synapse Analytics Apache Spark pool named Pool1. You plan to load JSON files from an Azure Data Lake Storage Gen2 container into the tables in Pool1. The structure and data types vary by file. You need to load the files into the tables. The solution must...
What should you include in the recommendation?
You need to recommend an availability strategy for an Azure SQL database. The strategy must meet the following requirements: ✑ Support failovers that do not require client applications to change their connection strings. ✑ Replicate the database to a secondary Azure region. ✑ Support failover to the secondary region. What...
