DP-200 Exam Question 86

You have an Azure subscription that contains an Azure Data Factory version 2 (V2) data factory named df1. Df1 contains a linked service.
You have an Azure Key vault named vault1 that contains an encryption key named key1.
You need to encrypt df1 by using key1.
What should you do first?
  • DP-200 Exam Question 87

    You are responsible for providing access to an Azure Data Lake Storage Gen2 account.
    Your user account has contributor access to the storage account, and you have the application ID access key.
    You plan to use PolyBase to load data into Azure SQL data warehouse.
    You need to configure PolyBase to connect the data warehouse to the storage account.
    Which three components should you create in sequence? To answer, move the appropriate components from the list of components to the answer are and arrange them in the correct order.

    DP-200 Exam Question 88

    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 a container named Sales in an Azure Cosmos DB database. Sales has 120 GB of data. Each entry in Sales has the following structure.

    The partition key is set to the OrderIdattribute.
    Users report that when they perform queries that retrieve data by ProductName, the queries take longer than expected to complete.
    You need to reduce the amount of time it takes to execute the problematic queries.
    Solution: You increase the Request Units (RUs) for the database.
    Does this meet the goal?
  • DP-200 Exam Question 89

    You have an Azure subscription that contains an Azure Databricks environment and an Azure Storage account.
    You need to implement secure communication between Databricks and the storage account.
    You create an Azure key vault.
    Which four actions should you perform in sequence? To answer, move the actions from the list of actions to the answer area and arrange them in the correct order.

    DP-200 Exam Question 90

    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 answer selection is worth one point.