Microsoft DP-300 Übungsprüfungen
Zuletzt aktualisiert am 26.04.2025- Prüfungscode: DP-300
- Prüfungsname: Administering Microsoft Azure SQL Solutions
- Zertifizierungsanbieter: Microsoft
- Zuletzt aktualisiert am: 26.04.2025
You are designing a star schema for a dataset that contains records of online orders. Each record includes an order date, an order due date, and an order ship date.
You need to ensure that the design provides the fastest query times of the records when querying for arbitrary date ranges and aggregating by fiscal calendar attributes.
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A . Create a date dimension table that has a DateTime key.
- B . Create a date dimension table that has an integer key in the format of YYYYMMDD.
- C . Use built-in SQL functions to extract date attributes.
- D . Use integer columns for the date fields.
- E . Use DateTime columns for the date fields.
You have an Always On availability group deployed to Azure virtual machines. The availability group contains a database named DB1 and has two nodes named SQL1 and SQL2. SQL1 is the primary replica.
You need to initiate a full backup of DB1 on SQL2.
Which statement should you run?
- A . BACKUP DATABASE DB1 TO URL=’https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak‘ with (Differential, STATS=5, COMPRESSION);
- B . BACKUP DATABASE DB1 TO URL=’https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak‘ with (COPY_ONLY, STATS=5, COMPRESSION);
- C . BACKUP DATABASE DB1 TO URL=’https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak‘ with (File_Snapshot, STATS=5, COMPRESSION);
- D . BACKUP DATABASE DB1 TO URL=’https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak‘ with (NoInit, STATS=5, COMPRESSION);
You have an Azure subscription that contains two Azure SQL managed instances named SQLMI1 and SQLMI2. SQLM2 contains a database named DB1 and a user named User1.
User1 drops DB1.
You need to perform a point-in-time restore of DB1 to SQLMI2.
- A . Azure CLI
- B . Transact-SQL
- C . The Azure portal
- D . Azure PowerShell
HOTSPOT
You have an instance of SQL Server on Azure Virtual Machines named VM1.
You need to use an Azure Automation runbook to initiate a SQL Server database backup on VM1.
How should you complete the command? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
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 . Double the value of Data Flush Interval.
DRAG DROP
You have an instance of SQL Server on Azure Virtual Machines named SQL1. SQL1 contains a database named DB1.
You need to enable Transparent Data Encryption (TDE) for DB1.
Which three objects should you create in sequence? To answer, move the appropriate objects from the list of objects to the answer area and arrange them in the correct order.
You have 40 Azure SQL databases, each for a different customer. All the databases reside on the same Azure SQL Database server.
You need to ensure that each customer can only connect to and access their respective database.
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A . Implement row-level security (RLS).
- B . Create users in each database.
- C . Configure the database firewall.
- D . Configure the server firewall.
- E . Create logins in the master database.
- F . Implement Always Encrypted.
You have an Azure SQL database named DBI that contains a nonclustered index named index1.
End users report slow queries when they use index1.
You need to identify the operations that are being performed on the index.
Which dynamic management view should you use?
- A . Option A
- B . Option B
- C . Option C
- D . Option D
HOTSPOT
You have an Azure SQL database named DB1 in the General Purpose service tier.
You need to monitor D81 by using SQL insights.
What should you include in the solution? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
HOTSPOT
You are provisioning an Azure SQL database in the Azure portal as shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.
