You have an Azure Data Factory pipeline that performs an incremental load of source data to an Azure Data Lake Storage Gen2 account.Data to be loaded is identified by a column named LastUpdatedDate in the source table.You plan to execute the pipeline every four hours.You need to ensure that the pipeline execution meets the following requirements:Automatically retries the execution when the pipeline run fails due to concurrency or throttling limits.Supports backfilling existing data in the table.Which type of trigger should you use?
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?
You are designing a date dimension table in an Azure Synapse Analytics dedicated SQL pool. The datedimension table will be used by all the fact tables.Which distribution type should you recommend to minimize data movement?
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?
You have an Azure SQL managed instance.You need to gather the last execution of a query plan and its runtime statistics. The solution must minimize the impact on currently running queries.What should you do?