Question 126

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?
  • Question 127

    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 both pipelines and all failure types. The metric has the following settings:
    * Operator: Greater than
    * Aggregation type: Total
    * Threshold value: 2
    * Aggregation granularity (Period): 5 minutes
    * Frequency of evaluation: Every 5 minutes
    Data Factory monitoring records the failures shown in the following table.

    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 128

    You have an Azure SQL database named db1 on a server named server1.
    You use Query Performance Insight to monitor db1.
    You need to modify the Query Store configuration to ensure that performance monitoring data is available as soon as possible.
    Which configuration setting should you modify and which value should you configure? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 129

    You need to apply 20 built-in Azure Policy definitions to all new and existing Azure SQL Database deployments in an Azure subscription. The solution must minimize administrative effort.
    Which three 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.

    Question 130

    You have two instances of SQL Server on Azure virtual Machines named VM1 and VM2. VM1 hosts a database named dbl.
    You plan to create a database availability group (DAG) for dbl. The solution must use certificate authentication between VM1 and VM2.
    You need to configure authentication for the outbound connections of VM1.
    Which three 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.