DP-300 exam

Your on-premises network contains a server that hosts a 60-TB database named DB 1. The network has a 10-Mbps internet connection. You need to migrate DB 1 to Azure. The solution must minimize how long it takes to migrate the database. What should you use?A . Azure Migrate B. Data...

Which windowing function should you use to perform the streaming aggregation of the sales data?A . Sliding B. Hopping C. Session D. TumblingView AnswerAnswer: D Explanation: Scenario: The sales data, including the documents in JSON format, must be gathered as it arrives and analyzed online by using Azure Stream Analytics....

DRAG DROP You have a new Azure SQL database named DB1 on an Azure SQL server named AzSQL1. The only user who was created is the server administrator. You need to create a contained database user in DB1 who will use Azure Active Directory (Azure AD) for authentication. Which three...

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. NOTE: Each correct selection is worth one point.A . sys.dm_pdw_nodes_tran_locks B. sys.dm_exec_compute_node_errors C. sys.dm_exec_requests D. sys.dm_cdc_errors E. sys.dm_pdw_nodes_os_wait_stats F. sys.dm_tran_locksView AnswerAnswer: A,E...

You have an Azure SQL database named DB1. You run a query while connected to DB1. You review the actual execution plan for the query, and you add an index to a table referenced by the query. You need to compare the previous actual execution plan for the query to...

HOTSPOT You have an Azure SQL database named DB 1 in the General Purpose service tier. You need to monitor DB 1 by using SQL Insights. What should you include in the solution? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one...

You have an Azure SQL managed instance that hosts multiple databases. You need to configure alerts for each database based on the diagnostics telemetry of the database. What should you use?A . Azure SQL Analytics alerts based on metrics B. SQL Health Check alerts based on diagnostics logs C. SQL...

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

You have a 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?A . log shipping B. Always On availability groups C. Database Migration Assistant...

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?A . role assignments B. account keys C. shared access signatures (SAS) D....