DP-200

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...

Load the data using the INSERT…SELECT statement. Does the solution meet the goal?A . YesB . NoView AnswerAnswer: B Explanation: There is no need to convert the parquet files to CSV files. You load the data using the CREATE TABLE AS SELECT statement. References: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-load-from-azure-data-lakestore

HOTSPOT You are developing a solution using a Lambda architecture on Microsoft Azure. The data at rest layer must meet the following requirements: * Data storage: - Serve as a repository for high volumes of large files in various formats. - Implement optimized storage for big data analytics workloads. -...

DRAG DROP You need to provision the polling data storage account. How should you configure the storage account? To answer, drag the appropriate Configuration Value to the correct Setting. Each Configuration Value may be used once, more than once, or not at all. You may need to drag the split...

DRAG DROP Your company manages on-premises Microsoft SQL Server pipelines by using a custom solution. The data engineering team must implement a process to pull data from SQL Server and migrate it to Azure Blob storage. The process must orchestrate and manage the data lifecycle. You need to configure Azure...

The data engineering team manages Azure HDInsight clusters. The team spends a large amount of time creating and destroying clusters daily because most of the data pipeline process runs in minutes. You need to implement a solution that deploys multiple HDInsight clusters with minimal effort. What should you implement?A ....

HOTSPOT Which masking functions should you implement for each column to meet the data masking requirements? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: Default Default uses a zero value for numeric data types (bigint,...

Load the data using the INSERT…SELECT statement. Does the solution meet the goal?A . YesB . NoView AnswerAnswer: B Explanation: There is no need to convert the parquet files to CSV files. You load the data using the CREATE TABLE AS SELECT statement. References: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-load-from-azure-data-lakestore

You plan to create a dimension table in Azure Data Warehouse that will be less than 1 GB. You need to create the table to meet the following requirements: Provide the fastest query time. Minimize data movement. Which type of table should you use?A . hash distributedB . heapC ....

A company plans to use Azure Storage for file storage purposes. Compliance rules require: A single storage account to store all operations including reads, writes and deletes Retention of an on-premises copy of historical operations You need to configure the storage account. Which two actions should you perform? Each correct...