DP-200 exam

Load the data using the CREATE TABLE AS SELECT statement. Does the solution meet the goal?A . YesB . NoView AnswerAnswer: B Explanation: 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-lake-store

A company is designing a hybrid solution to synchronize data and on-premises Microsoft SQL Server database to Azure SQL Database. You must perform an assessment of databases to determine whether data will move without compatibility issues. You need to perform the assessment. Which tool should you use?A . Azure SQL...

Topic 1, Proseware Inc Background Proseware, Inc, develops and manages a product named Poll Taker. The product is used for delivering public opinion polling and analysis. Polling data comes from a variety of sources, including online surveys, house-to-house interviews, and booths at public events. Polling data Polling data is stored...

You need to set up Azure Data Factory pipelines to meet data movement requirements. Which integration runtime should you use?A . self-hosted integration runtimeB . Azure-SSIS Integration RuntimeC . .NET Common Language Runtime (CLR)D . Azure integration runtimeView AnswerAnswer: A Explanation: The following table describes the capabilities and network support...

You are developing a data engineering solution for a company. The solution will store a large set of key-value pair data by using Microsoft Azure Cosmos DB The solution has the following requirements: • Data must be partitioned into multiple containers. • Data containers must be configured separately. • Data...

HOTSPOT You need set up the Azure Data Factory JSON definition for Tier 10 data. What should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: Connection String To use storage account key authentication,...