You have an Azure Synapse Analytics Apache Spark pool named Pool1.You plan to load JSON files from an Azure Data Lake Storage Gen2 container into the tables in Pool1. The structure and data types vary by file. You need to load the files into the tables. The solution must maintain the source data types.What should you do?

Load the data by using the OPENROWSET Transact-SQL command in an Azure Synapse Analytics serverless SQL pool.

Load the data by using PySpark.

Load the data by using the OPENROWSET Transact-SQL command in an Azure Synapse Analytics serverless SQL pool.

Use a Get Metadata activity in Azure Data Factory.

Use a Conditional Split transformation in an Azure Synapse data flow.

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?

From the Azure portal, set a sensitivity classification of Confidential for the Email column.

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.

You have an Azure Databricks workspace named workspace1 in the Standard pricing tier. Workspace1 contains an all-purpose cluster named cluster1. You need to reduce the time it takes for cluster1 to start and scale up. The solution must minimize costs. What should you do first?

Upgrade workspace1 to the Premium pricing tier.

Configure a global init script for workspace1.

Create a cluster policy in workspace1.

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?

Configure virtual network peering.

Configure network security groups (NSGs).

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?

SQL Server on an Azure Virtual Machine

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

Configure transactional replication.

Configure Transaction Log Shipping.

Implement Always On availability groups.

Configure transactional replication.

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?

Change the column type to VARCHAR(200).

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).

You have an Azure SQL database named db1 on a server named server1.The Intelligent Insights diagnostics log identifies queries that cause performance issues due to tempDB contention. You need to resolve the performance issues.What should you do?

Implement memory-optimized tables.

Run the DBCC FLUSHPROCINDB command.

Replace the sequential index keys with nonsequential keys.

Run the DBCC DBREINDEX command.

You have an Azure SQL managed instance.You need to enable SQL Agent Job email notifications.What should you do?

Run the sp_set_agent_properties command.

You have four Azure subscriptions. Each subscription contains multiple Azure SQL databases.You need to update the column and index statistics for the databases.What should you use?

automatic tuning in Azure SQL Database

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.NOTE: Each correct selection is worth one point.

From the properties of Server1, add a failover group.

Create a new Azure SQL Database server named Server2.

From the properties of DB1, configure geo-replication.

From the properties of Server1, add a failover group.

Create a new Azure SQL Database server named Server2.

From the properties of Server1, configure retention for DB1.

Create a new Azure SQL Database instance named DB2.

Microsoft DP-300 Practice Test 5 - Free Online Exam Prep & Questions

HOTSPOT

You have an on-premises Microsoft SQL Server 2016 server named Server1 that contains a database named DB1.

You need to perform an online migration of DB1 to an Azure SQL Database managed instance by using Azure Database Migration Service.

How should you configure the backup of DB1? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Become a Premium Member for full access

Unlock Premium Member

Microsoft DP-300 Practice Test 5

Question

Microsoft DP-300 Practice Tests

Practice Tests