Free Administering Relational Databases on Microsoft Azure Exam DP-300 Exam Practice Test

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?

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

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 two Azure SQL Database servers named Server1 and Server2. Each server contains an Azure SQL database named Database1.You need to restore Database1 from Server1 to Server2. The solution must replace the existing Database1 on Server2.Solution: You restore Database1 from Server1 to the Server2 by using the RESTORE Transact-SQL command and the REPLACE option.Does this meet the goal?

• Yes
• No

You have an Azure virtual machine named VM1 that runs Windows Server 2022 and hosts a Microsoft SQL Server 2019 instance named SQL1.You need to configure SQL1 to use mixed mode authentication.Which procedure should you run?

• sp_eddremotelogin
• xp_grant_login
• sp_change_users_login
• xp_instance_regwrite

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?

• JSON
• CSV
• Parquet
• ORC

You have several Azure SQL databases on the same Azure SQL Database server in a resource group named ResourceGroup1.You must be alerted when CPU usage exceeds 80 percent for any database. The solution must apply to any additional databases that are created on the Azure SQL server.Which resource type should you use to create the alert?

• Resource Groups
• SQL Servers
• SQL Databases
• SQL Virtual Machines

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?

• Run the set showplan_all Transact-SQL statement.
• For DB1, set QUERY_CAPTURE_MODE of Query Store to All.
• Run the set forceplan Transact-SQL statement.
• Enable Query Store for DB1.

You have two on-premises Microsoft SQL Server 2019 instances named SQL1 and SQL2.You need to migrate the databases hosted on SQL 1 to Azure. The solution must meet the following requirements:The service that hosts the migrated databases must be able to communicate with SQL2 by using linked server connections.Administrative effort must be minimized.What should you use to host the databases?

• a single Azure SQL database
• an Azure SQL Database elastic pool
• SQL Server on Azure Virtual Machines
• Azure SQL Managed Instance

Based on the PaaS prototype, which Azure SQL Database compute tier should you use?

• Business Critical 4-vCore
• Hyperscale
• General Purpose v-vCore
• Serverless

You manage an enterprise data warehouse in Azure Synapse Analytics.Users report slow performance when they run commonly used queries. Users do not report performance changes for infrequently used queries.You need to monitor resource utilization to determine the source of the performance issues.Which metric should you monitor?

• Local tempdb percentage
• DWU percentage
• Data Warehouse Units (DWU) used
• Cache hit percentage

You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and a database named DB1. DB1 contains a fact table named Table.You need to identify the extent of the data skew in Table1.What should you do in Synapse Studio?

• Connect to Pool1 and query sys.dm_pdw_nodes_db_partition_stats.
• Connect to the built-in pool and run DBCC CHECKALLOC.
• Connect to Pool1 and run DBCC CHECKALLOC.
• Connect to the built-in pool and query sys.dm_pdw_nodes_db_partition_stats.