DON'T WANT TO MISS A THING?

Certification Exam Passing Tips

Latest exam news and discount info

Curated and up-to-date by our experts

Yes, send me the newsletter

Best Microsoft DP-300 Practice Exams and Exam Preparation Materials, Microsoft Azure Database Administrator | SPOTO

Embark on your journey to becoming an Azure SQL database specialist with our top-tier collection of DP-300 practice exams and exam preparation materials. Our platform offers a comprehensive range of resources, including practice tests, free test access, online exam questions, sample questions, exam dumps, and mock exams. Utilize our latest practice tests to enhance your exam readiness and ensure success in passing the certification exam. These courses and hands-on labs are designed to provide you with the foundational knowledge needed to excel in your role as an Azure SQL database specialist. The DP-300 exam, a crucial component of Microsoft's new role-based certification program, is essential for attaining the Azure Database Administrator Associate certification. Trust in our exam materials to guide you on your path to certification success.
Take other online exams
Question #1
You plan to move two 100-GB databases to Azure. You need to dynamically scale resources consumption based on workloads. The solution must minimize downtime during scaling operations. What should you use?
A. An Azure SQL Database elastic pool
B. SQL Server on Azure virtual machines
C. an Azure SQL Database managed instance
D. Azure SQL databases
View answer
Correct Answer: BC
Question #2
This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have two Azure SQL Database servers named Server1 and Server2. Each server cont
A. Yes
B. No
View answer
Correct Answer: A
Question #3
You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and an Azure Data Lake Storage Gen2 account named Account1. You plan to access the files in Account1 by using an external table. You need to create a data source in Pool1 that you can reference when you create the external table. How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area. Each correct selection is worth one point.
A. Mastered
B. Not Mastered
View answer
Correct Answer: A
Question #4
You have an Azure SQL Database instance named DatabaseA on a server named Server1. You plan to add a new user named App1 to DatabaseA and grant App1 db_datacenter permissions. App1 will use SQL Server Authentication. You need to create App1. The solution must ensure that App1 can be given access to other databases by using the same credentials. 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 corre
A. Mastered
B. Not Mastered
View answer
Correct Answer: ACD
Question #5
You are designing a dimension table in an Azure Synapse Analytics dedicated SQL pool. You need to create a surrogate key for the table. The solution must provide the fastest query performance. What should you use for the surrogate key?
A. an IDENTITY column
B. a GUID column
C. a sequence object
View answer
Correct Answer: B
Question #6
What should you implement to meet the disaster recovery requirements for the PaaS solution?
A. Availability Zones
B. failover groups
C. Always On availability groups
D. geo-replication
View answer
Correct Answer: A
Question #7
You have an Azure subscription that uses a domain named contoso.com. You have two Azure VMs named DBServer1 and DBServer2. Each of them hosts a default SQL Server instance. DBServer1 is in the East US Azure region and contains a database named DatabaseA. DBServer2 is in the West US Azure region. DBServer1 has a high volume of data changes and low latency requirements for data writes. You need to configure a new availability group for DatabaseA. The secondary replica will reside on DBServer2. What should you
A. Configure the primary endpoint as TCP://DBServer1
B. Configure the primary endpoint as TCP://DBServer1
C. Configure the primary endpoint as TCP://DBServer1
D. Configure the primary endpoint as TCP://DBServer1
View answer
Correct Answer: A
Question #8
You have an Azure subscription that contains an Azure SQL database named SQL1. SQL1 is in an Azure region that does not support availability zones. You need to ensure that you have a secondary replica of SQLI in the same region. What should you use?
A. log shipping
B. auto-failover groups
C. active geo-replication
D. Microsoft SQL Server failover clusters
View answer
Correct Answer: AC
Question #9
You need to use an Azure Resource Manager ARM) template to deploy an Azure virtual machine that will host a Microsoft SQL Server instance. The solution must maximize disk I/O performance for the SQL Server database and log files How should you complete the template? To answer, select the appropriate options in the answer area. Each correct selection is worth one point.
A. Mastered
B. Not Mastered
View answer
Correct Answer: A
Question #10
You need to identify the cause of the performance issues on SalesSQLDb1. Which two dynamic management views should you use? Each correct answer presents part of the solution. Each correct selection is worth one point.
A. sys
B. sys
C. sys
D. sys
E. sys
F. sys
View answer
Correct Answer: A
Question #11
You have an Azure SQL database named db1 on a server named server1. You need to modify the MAXDOP settings for db1. What should you do?
A. Connect to db1 and run the sp_configure command
B. Connect to the master database of server1 and run the sp_configure command
C. Configure the extended properties of db1
D. Modify the database scoped configuration of db1
View answer
Correct Answer: A
Question #12
You have a new Azure subscription. You create an Azure SQL Database instance named DB1 on an Azure SQL Database server named Server1. You need to ensure that users can connect to DB1 in the event of an Azure regional outage. In the event of an outage, applications that connect to DB1 must be able to connect without having to update the connection strings. Which two actions should you perform? Each correct answer presents part of the solution. Each correct selection is worth one point.
A. From the properties of DB1
B. From the properties of Server1 add a failover group
C. Create a new Azure SQL Database server named Server2
D. From the properties of Server1 configure retention for DB1
E. Create a new Azure SQL Database instance named DB2
View answer
Correct Answer: D
Question #13
You have SQL Server 2019 on an Azure virtual machine that runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory. You scale up the virtual machine to 8 vCPUSs and 64 GB of memory. You need to provide the lowest latency for tempdb. What is the total number of data files that tempdb should contain?
A. 2
B. 4
C. 8
D. 64
View answer
Correct Answer: A
Question #14
You have a 50-TB Microsoft SQL Server database named DB1. You need to reduce the time it takes to perform database consistency checks of DB1. Which Transact-SQL command should you run? To answer, select the appropriate options in the answer area. Each correct selection is worth one point.
A. Mastered
B. Not Mastered
View answer
Correct Answer: A
Question #15
You have an Azure SQL Database server named sqlsrv1 that hosts 10 Azure SQL databases. The databases perform slower than expected. You need to identify whether the performance issue relates to the use of tempdb on sqlsrv1. What should you do?
A. Run Query Store-based queries
B. Review information provided by SQL Server Profiler-based traces
C. Review information provided by Query Performance Insight
D. Run dynamic management view-based queries
View answer
Correct Answer: D
Question #16
You have an Azure SQL database named DB1 that contains a table named Orders. The Orders table contains a row for each sales order. Each sales order includes the name of the user who placed the order. You need to implement row-level security (RLS). The solution must ensure that the users can view only their respective sales orders. What should you include in the solution? To answer, select the appropriate options in the answer area. Each correct selection is worth one point.
A. Mastered
B. Not Mastered
View answer
Correct Answer: A
Question #17
You have an Azure SQL database. The database contains a table that uses a columnstore index and is accessed infrequently. You enable columnstore archival compression. What are two possible results of the configuration? Each correct answer presents a complete solution. Each correct selection is worth one point.
A. Queries that use the index will consume more disk I/O
B. Queries that use the index will retrieve fewer data pages
C. The index will consume more disk space
D. The index will consume more memory
E. Queries that use the index will consume more CPU resources
View answer
Correct Answer: A
Question #18
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
View answer
Correct Answer: C
Question #19
You create five Azure SQL Database instances on the same logical server. In each database, you create a user for an Azure Active Directory (Azure AD) user named User1. User1 attempts to connect to the logical server by using Azure Data Studio and receives a login error. You need to ensure that when User1 connects to the logical server by using Azure Data Studio, User1 can see all the databases. What should you do?
A. Create User1 in the master database
B. Assign User1 the db_datareader role for the master database
C. Assign User1 the db_datareader role for the databases that Userl creates
D. Grant select on sys
View answer
Correct Answer: BE
Question #20
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
View answer
Correct Answer: A
Question #21
This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have two Azure SQL Database servers named Server1 and Server2. Each server cont
A. Yes
B. No
View answer
Correct Answer: A
Question #22
You have an Azure SQL database named DB1. You need to display the estimated execution plan of a query by using the query editor in the Azure portal. What should you do first?
A. Run the set showplan_all Transact-SQL statement
B. For DB1, set QUERY_CAPTURE_MODE of Query Store to All
C. Run the set forceplan Transact-SQL statement
D. Enable Query Store for DB1
View answer
Correct Answer: C

View Answers after Submission

Please submit your email and WhatsApp to get the answers of questions.

Note: Please make sure your email ID and Whatsapp are valid so that you can get the correct exam results.

Email:
Whatsapp/phone number:


Copyright © 2024. Designer by SPOTO Official Website. All Rights Reserved.