DP-300 무료 덤프문제 온라인 액세스
| 시험코드: | DP-300 |
| 시험이름: | Administering Relational Databases on Microsoft Azure |
| 인증사: | Microsoft |
| 무료 덤프 문항수: | 503 |
| 업로드 날짜: | 2026-08-28 |
You are developing an application that uses Azure Data Lake Storage Gen 2.
You need to recommend a solution to grant permissions to a specific application for a limited time period.
What should you include in the recommendation?
You have an instance of SQL Server on Azure Virtual Machines named VM1.
You plan to schedule a SQL Server Agent job that will rebuild indexes of the databases hosted on VM1.
You need to configure the account that will be used by the agent. The solution must use the principle of least privilege.
Which operating system user right should you assign to the account?
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?
SIMULATION
You need to rebuild the index for PK_Address_AddressID in the SalesLT.Address table in db1.
The solution must meet the following requirements:
- Ensure that 30 percent of the index page is reserved for future updates and inserts.
- Minimize page splits.
To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
Hotspot Question
You have an app that distributes users geographically by using sharding.
You need to identify which users where active during the last 50 days. The solution must include users across all the shards.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
