Question 91

You are designing an Azure Databricks interactive cluster. The cluster will be used infrequently and will be configured for auto-termination.
You need to ensure that the cluster configuration is retained indefinitely after the cluster is terminated. The solution must minimize costs.
What should you do?
  • Question 92

    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 scenario, 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 Storage account that contains 100 GB of files. The files contain text and numerical values.
    75% of the rows contain description data that has an average length of 1.1 MB.
    You plan to copy the data from the storage account to an Azure SQL data warehouse.
    You need to prepare the files to ensure that the data copies quickly.
    Solution: You modify the files to ensure that each row is less than 1 MB.
    Does this meet the goal?
  • Question 93

    You need to implement an Azure Databricks cluster that automatically connects to Azure Data Lake Storage Gen2 by using Azure Active Directory (Azure AD) integration.
    How should you configure the new cluster? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 94

    You have an Azure subscription that contains a logical Microsoft SQL server named Server1. Server1 hosts an Azure Synapse Analytics SQL dedicated pool named Pool1.
    You need to recommend a Transparent Data Encryption (TDE) solution for Server1. The solution must meet the following requirements:
    Track the usage of encryption keys.
    Maintain the access of client apps to Pool1 in the event of an Azure datacenter outage that affects the availability of the encryption keys.
    What should you include in the recommendation? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 95

    You are building an Azure Stream Analytics job to identify how much time a user spends interacting with a feature on a webpage.
    The job receives events based on user actions on the webpage. Each row of data represents an event. Each event has a type of either 'start' or 'end'.
    You need to calculate the duration between start and end events.
    How should you complete the query? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.