Microsoft DP-300 Real Exam Questions
The questions for DP-300 were last updated at Sep 05,2024.
- Exam Code: DP-300
- Exam Name: Administering Microsoft Azure SQL Solutions
- Certification Provider: Microsoft
- Latest update: Sep 05,2024
You have a new Azure SQL database. The database contains a column that stores confidential information.
You need to track each time values from the column are returned in a query. The tracking information must be stored for 365 days from the date the query was executed.
Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A . Turn on auditing and write audit logs to an Azure Storage account.
- B . Add extended properties to the column.
- C . Turn on Advanced Data Security for the Azure SQL server.
- D . Apply sensitivity labels named Highly Confidential to the column.
- E . Turn on Azure Advanced Threat Protection (ATP).
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.
You have an Azure SQL database.
You identify a long running query.
You need to identify which operation in the query is causing the performance issue.
What should you use to display the query execution plan in Microsoft SQL Server Management Studio (SSMS)?
- A . Live Query Statistics
- B . an estimated execution plan
- C . an actual execution plan
- D . Client Statistics
You have an Azure SQL database named sqldb1.
You need to minimize the amount of space by the data and log files of sqldb1.
What should you run?
- A . DBCC SHRINKDATABASE
- B . sp_clean_db_free_space
- C . sp_clean_db_file_free_space
- D . DBCC SHRINKFILE
You have an Azure SQL database named sqldb1.
You need to minimize the amount of space by the data and log files of sqldb1.
What should you run?
- A . DBCC SHRINKDATABASE
- B . sp_clean_db_free_space
- C . sp_clean_db_file_free_space
- D . DBCC SHRINKFILE
You have an Azure SQL database named DB1.
You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails.
The solution must minimize costs.
Which deployment option and pricing tier should you configure?
- A . Azure SQL Database Hyperscale
- B . Azure SQL Database managed instance General Purpose
- C . Azure SQL Database Premium
- D . Azure SQL Database Basic
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 order.
You need to implement the surrogate key for the retail store table. The solution must meet the sales
transaction dataset requirements.
What should you create?
- A . a table that has a FOREIGN KEY constraint
- B . a table the has an IDENTITY property
- C . a user-defined SEQUENCE object
- D . a system-versioned temporal table
You have an Azure SQL Database managed instance named SQLMI1. A Microsoft SQL Server Agent job runs on SQLMI1.
You need to ensure that an automatic email notification is sent once the job completes.
What should you include in the solution?
- A . From SQL Server Configuration Manager (SSMS), enable SQL Server Agent
- B . From SQL Server Management Studio (SSMS), run sp_set_sqlagent_properties
- C . From SQL Server Management Studio (SSMS), create a Database Mail profile
- D . From the Azure portal, create an Azure Monitor action group that has an Email/SMS/Push/Voice action
HOTSPOT
You need to implement the monitoring of SalesSQLDb1. The solution must meet the technical requirements.
How should you collect and stream metrics? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.