- All Exams Instant Download
Which two configurations should you include in the design?
You are designing a solution that will copy Parquet files stored in an Azure Blob storage account to an Azure Data Lake Storage Gen2 account. The data will be loaded daily to the data lake and will use a folder structure of {Year}/{Month}/{Day}/. You need to design a daily Azure...
What should you include in the solution?
HOTSPOT You need to design a data storage structure for the product sales transactions. The solution must meet the sales transaction dataset requirements. What should you include in the solution? To answer, select the appropriate options in the answer area . NOTE: Each correct selection is worth one point. View...
How should you configure the Data Factory copy activity?
HOTSPOT You use Azure Data Factory to prepare data to be queried by Azure Synapse Analytics serverless SQL pools. Files are initially ingested into an Azure Data Lake Storage Gen2 account as 10 small JSON files. Each file contains the same data attributes and data from a subsidiary of your...
What should you do?
You have an enterprise data warehouse in Azure Synapse Analytics named DW1 on a server named Server 1. You need to verify whether the size of the transaction log file for each distribution of DW1 is smaller than 160 GB. What should you do?A . On the master database, execute...
How should you complete the query?
HOTSPOT You are building an Azure Analytics query that will receive input data from Azure IoT Hub and write the results to Azure Blob storage. You need to calculate the difference in readings per sensor per hour. How should you complete the query? To answer, select the appropriate options in...
What should you do?
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?A . Clone the cluster...
Which type of data redundancy should you use?
You have an Azure Data Lake Storage Gen2 container that contains 100 TB of data. You need to ensure that the data in the container is available for read workloads in a secondary region if an outage occurs in the primary region. The solution must minimize costs . Which type...
Which two Azure services should you use to debug the activities?
You have several Azure Data Factory pipelines that contain a mix of the following types of activities. * Wrangling data flow * Notebook * Copy * jar Which two Azure services should you use to debug the activities? Each correct answer presents part of the solution NOTE: Each correct selection...
You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Table 1.
You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Table 1. You have files that are ingested and loaded into an Azure Data Lake Storage Gen2 container named container 1. You plan to insert data from the files into Table1 and azure Data Lake Storage...
You are creating dimensions for a data warehouse in an Azure Synapse Analytics dedicated SQL pool
HOTSPOT You are creating dimensions for a data warehouse in an Azure Synapse Analytics dedicated SQL pool. You create a table by using the Transact-SQL statement shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in...
