DP-300 practice test

1. Question 1 · 1

   You have 20 Azure SQL databases provisioned by using the vCore purchasing model. You plan to create an Azure SQL Database elastic pool and add the 20 databases. Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

   Choose all answers that apply.

   • total size of all the databases
   • geo-replication support
   • number of concurrently peaking databases * peak CPU utilization per database
   • maximum number of concurrent sessions for all the databases
   • total number of databases * average CPU utilization per database

2. Question 2 · 1

   You are designing a streaming data solution that will ingest variable volumes of data. You need to ensure that you can change the partition count after creation. Which service should you use to ingest the data?

   Choose one answer.

   • Azure Event Hubs Standard
   • Azure Stream Analytics
   • Azure Data Factory
   • Azure Event Hubs Dedicated

3. Question 3 · 1

   You have an Azure Synapse Analytics workspace named WS1 that contains an Apache Spark pool named Pool1. You plan to create a database named DB1 in Pool1. You need to ensure that when tables are created in DB1, the tables are available automatically as external tables to the built-in serverless SQL pool. Which format should you use for the tables in DB1?

   Choose one answer.

   • JSON
   • CSV
   • Parquet
   • ORC

4. Question 4 · 1

   You plan to build a structured streaming solution in Azure Databricks. The solution will count new events in five-minute intervals and report only events that arrive during the interval. The output will be sent to a Delta Lake table. Which output mode should you use?

   Choose one answer.

   • complete
   • append
   • update

5. Question 5 · 1

   You have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The table contains a column name Email. You need to prevent nonadministrative users from seeing the full email addresses in the Email column. The users must see values in a format of aXXX@XXXX.com instead. What should you do?

   Choose one answer.

   • From the Azure portal, set a mask on the Email column.
   • From the Azure portal, set a sensitivity classification of Confidential for the Email column.
   • From Microsoft SQL Server Management Studio, set an email mask on the Email column.
   • From Microsoft SQL Server Management Studio, grant the SELECT permission to the users for all the columns in the dbo.Customers table except Email.

6. Question 6 · 1

   Note: 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 an Azure Synapse Analytics dedicated SQL pool that contains a table named Table1. You have files that are ingested and loaded into an Azure Data Lake Storage Gen2 container named container1. You plan to insert data from the files into Table1 and transform the data. Each row of data in the files will produce one row in the serving layer of Table1. You need to ensure that when the source data files are loaded to container1, the DateTime is stored as an additional column in Table1. Solution: In an Azure Synapse Analytics pipeline, you use a Get Metadata activity that retrieves the DateTime of the files. Does this meet the goal?

   Choose one answer.

   • Yes
   • No

7. Question 7 · 1

   Note: 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 an Azure Synapse Analytics dedicated SQL pool that contains a table named Table1. You have files that are ingested and loaded into an Azure Data Lake Storage Gen2 container named container1. You plan to insert data from the files into Table1 and transform the data. Each row of data in the files will produce one row in the serving layer of Table1. You need to ensure that when the source data files are loaded to container1, the DateTime is stored as an additional column in Table1. Solution: You use an Azure Synapse Analytics serverless SQL pool to create an external table that has an additional DateTime column. Does this meet the goal?

   Choose one answer.

   • Yes
   • No

8. Question 8 · 1

   You plan to deploy an app that includes an Azure SQL database and an Azure web app. The app has the following requirements: ✑ The web app must be hosted on an Azure virtual network. ✑ The Azure SQL database must be assigned a private IP address. ✑ The Azure SQL database must allow connections only from a specific virtual network. You need to recommend a solution that meets the requirements. What should you include in the recommendation?

   Choose one answer.

   • Azure Private Link
   • a network security group (NSG)
   • a database-level firewall
   • a server-level firewall

9. Question 9 · 1

   You have an Azure SQL database that contains a table named factSales. FactSales contains the columns shown in the following table. FactSales has 6 billion rows and is loaded nightly by using a batch process. You must provide the greatest reduction in space for the database and maximize performance. Which type of compression provides the greatest space reduction for the database?

   Choose one answer.

   

   • page compression
   • row compression
   • columnstore compression
   • columnstore archival compression

10. Question 10 · 1

    You are planning a solution that will use Azure SQL Database. Usage of the solution will peak from October 1 to January 1 each year. During peak usage, the database will require the following: ✑ 24 cores ✑ 500 GB of storage ✑ 124 GB of memory ✑ More than 50,000 IOPS During periods of off-peak usage, the service tier of Azure SQL Database will be set to Standard. Which service tier should you use during peak usage?

    Choose one answer.

    • Business Critical
    • Premium
    • Hyperscale

11. Question 11 · 1

    You have an on-premises Microsoft SQL Server 2019 server that hosts a database named DB1. You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1 and a virtual network named VNET1. SQLMI1 resides on VNET1. The on-premises network connects to VNET1 by using an ExpressRoute connection. You plan to migrate DB1 to SQLMI1 by using Azure Database Migration Service. You need to configure VNET1 to support the migration. What should you do?

    Choose one answer.

    • Configure service endpoints.
    • Configure virtual network peering.
    • Deploy an Azure firewall.
    • Configure network security groups (NSGs).

12. Question 12 · 1

    You have an on-premises Microsoft SQL server that uses the FileTables and Filestream features. You plan to migrate to Azure SQL. Which service should you use?

    Choose one answer.

    • Azure SQL Database
    • SQL Server on an Azure Virtual Machine
    • Azure SQL Managed Instance
    • Azure Database for MySQL

13. Question 13 · 1

    You need to migrate an on-premises Microsoft SQL Server database to Azure SQL Database. The solution must minimize downtime. What should you do?

    Choose one answer.

    • Configure Transaction Log Shipping.
    • Implement Always On availability groups.
    • Configure transactional replication.
    • Import a BACPAC.

14. Question 14 · 1

    You have an Azure SQL database named DB1. You have a table name Table1 that has 20 columns of type CHAR(400). Row compression for Table1 is enabled. During a database audit, you discover that none of the fields contain more than 150 characters. You need to ensure that you can apply page compression to Table1. What should you do?

    Choose one answer.

    • Configure the columns as sparse.
    • Change the column type to NVARCHAR(MAX).
    • Change the column type to VARCHAR(MAX).
    • Change the column type to VARCHAR(200).

15. Question 15 · 1

    You have an on-premises Microsoft SQL Server named SQL1 that hosts five databases. You need to migrate the databases to an Azure SQL managed instance. The solution must minimize downtime and prevent data loss. What should you use?

    Choose one answer.

    • Always On availability groups
    • Backup and Restore
    • log shipping
    • Database Migration Assistant

Paid access to all 228 questions

Each purchase applies to this certification. Prices are one-time payments, not monthly subscriptions.