Welcome to DumpsDB
- Passing Exams, Dumps for Free
  1. Home
  2. Microsoft Certification
  3. DP-300 Exam
  4. Microsoft.DP-300.v2023-01-16.q233 Dumps
Download Now

Question 136

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?

Question 137

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?

Question 138

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 dat a. 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?

Question 139

You have an Azure SQL database named DB1. The automatic tuning options for DB1 are configured as shown in the following exhibit.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Question 140

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