Does the solution meet the goal?

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

August 3, 2019 No Comments READ MORE +

Which tool should you use?

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

August 2, 2019 No Comments READ MORE +

How should you configure authentication and authorization for deployments?

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

August 1, 2019 No Comments READ MORE +

Which integration runtime should you use?

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

July 30, 2019 No Comments READ MORE +

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

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

July 30, 2019 No Comments READ MORE +

What should you use?

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

July 30, 2019 No Comments READ MORE +