DP-300 exam

HOTSPOT You have an Azure data factory that has two pipelines named PipelineA and PipelineB. PipelineA has four activities as shown in the following exhibit. PipelineB has two activities as shown in the following exhibit. You create an alert for the data factory that uses Failed pipeline runs metrics for...

You need to implement a solution to notify the administrators. The solution must meet the monitoring requirements. What should you do?A . Create an Azure Monitor alert rule that has a static threshold and assign the alert rule to an action group.B . Add a diagnostic setting that logs QueryStoreRuntimeStatistics...

You need to recommend a solution to ensure that the customers can create the database objects. The solution must meet the business goals. What should you include in the recommendation?A . For each customer, grant the customer ddl_admin to the existing schema.B . For each customer, create an additional schema...

You have the following Transact-SQL query. Which column returned by the query represents the free space in each file?A . ColumnAB . ColumnBC . ColumnCD . ColumnDView AnswerAnswer: C Explanation: Example: Free space for the file in the below query result set will be returned by the FreeSpaceMB column. SELECT...

Topic 4, Contoso Ltd Clothing Store You need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements. What should you create?A . a table that has a FOREIGN KEY constraintB . a table the has an IDENTITY propertyC . a...

DRAG DROP You need to implement statistics maintenance for SalesSQLDb1. The solution must meet the technical requirements. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. View AnswerAnswer: Explanation:...

DRAG DROP You need to implement statistics maintenance for SalesSQLDb1. The solution must meet the technical requirements. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. View AnswerAnswer: Explanation:...

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

DRAG DROP You have an Azure Active Directory (Azure AD) tenant named contoso.com that contains a user named [email protected] and an Azure SQL managed instance named SQLMI1. You need to ensure that [email protected] can create logins in SQLMI1 that map to Azure AD service principals. Which three actions should you...

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