Microsoft DP-300 Übungsprüfungen
Zuletzt aktualisiert am 05.06.2025- Prüfungscode: DP-300
- Prüfungsname: Administering Microsoft Azure SQL Solutions
- Zertifizierungsanbieter: Microsoft
- Zuletzt aktualisiert am: 05.06.2025
HOTSPOT
You have an Azure SQL database.
You are reviewing a slow performing query 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.
You need to provide an implementation plan to configure data retention for ResearchDB1. The solution must meet the security and compliance requirements.
What should you include in the plan?
- A . Configure the Deleted databases settings for ResearchSrvOL
- B . Deploy and configure an Azure Backup server.
- C . Configure the Advanced Data Security settings for ResearchDBL
- D . Configure the Manage Backups settings for ResearchSrvOL
You have an Azure Databricks resource.
You need to log actions that relate to changes in compute for the Databricks resource.
Which Databricks services should you log?
- A . clusters
- B . jobs
- C . DBFS
- D . SSH
- E . workspace
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 tab.)
Which Transact-SQL command should you run?
- A . GRANT SHOWPLAN TO DevUser
- B . GRANT VIEW DEFINITION TO DevUser
- C . GRANT VIEW DATABASE STATE TO DevUser
- D . GRANT SELECT TO DevUser