HOTSPOT You have two Azure virtual machines named VM1 and VM2 that run Windows Server 2019. VM1 and VM2 each host a default Microsoft SQL Server 2019 instance. VM1 contains a database named DB1 that is backed up to a…
HOTSPOT You have an Azure Data Lake Storage Gen2 container. Data is ingested into the container, and then transformed by a data integration application. The data is NOT modified after that. Users can read files in the container but cannot…
HOTSPOT You have an Azure Data Lake Storage Gen2 account named account1 that stores logs as shown in the following table. You do not expect that the logs will be accessed during the retention periods. You need to recommend a…
You plan to perform batch processing in Azure Databricks once daily. Which type of Databricks cluster should you use? A. automated B. interactive C. High Concurrency
HOTSPOT You have an Azure SQL Database managed instance named sqldbmi1 that contains a database name Sales. You need to initiate a backup of Sales. How should you complete the Transact-SQL statement? To answer, select the appropriate options in the…
HOTSPOT You have SQL Server on an Azure virtual machine that contains a database named DB1. The database reports a CHECKSUM error. You need to recover the database. How should you complete the statements? To answer, select the appropriate options…
You have the following Transact-SQL query. Which column returned by the query represents the free space in each file? A. ColumnA B. ColumnB C. ColumnC D. ColumnD
You have an Azure SQL database named DB3. You need to provide a user named DevUser with the ability to view the properties of DB3 from Microsoft SQL Server Management Studio (SSMS) as shown in the exhibit. (Click the Exhibit…
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 clause B. CREATE USER and the FROM CERTIFICATE…
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…