What will be returned by the query?

You have an Azure Synapse workspace named MyWorkspace that contains an Apache Spark database named mytestdb. You run the following command in an Azure Synapse Analytics Spark pool in MyWorkspace. CREATE TABLE mytestdb.myParquetTable( EmployeeID int, EmployeeName string, EmployeeStartDate date) USING Parquet You then use Spark to insert a row into...

September 6, 2021 No Comments READ MORE +

What should you do?

You are monitoring an Azure Stream Analytics job. You discover that the Backlogged Input Events metric is increasing slowly and is consistently non-zero. You need to ensure that the job can handle all the events. What should you do?A . Change the compatibility level of the Stream Analytics job.B ....

September 6, 2021 No Comments READ MORE +

Which file format should you use for each type of output?

HOTSPOT You need to output files from Azure Data Factory. Which file format should you use for each type of output? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: Parquet Parquet stores data in columns,...

September 6, 2021 No Comments READ MORE +

Does this meet the goal?

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

September 6, 2021 No Comments READ MORE +

What should you include in the Stream Analytics job?

HOTSPOT You plan to create a real-time monitoring app that alerts users when a device travels more than 200 meters away from a designated location. You need to design an Azure Stream Analytics job to process the data for the planned app. The solution must minimize the amount of code...

September 6, 2021 No Comments READ MORE +

How should you configure the table?

Topic 3, Mix Questions HOTSPOT You have a SQL pool in Azure Synapse. You plan to load data from Azure Blob storage to a staging table. Approximately 1 million rows of data will be loaded daily. The table will be truncated before each daily load. You need to create the...

September 5, 2021 No Comments READ MORE +

Which folder structure should you recommend to support fast queries and simplified folder security?

You are designing the folder structure for an Azure Data Lake Storage Gen2 container. Users will query data by using a variety of services including Azure Databricks and Azure Synapse Analytics serverless SQL pools. The data will be secured by subject area. Most queries will include data from the current...

September 5, 2021 No Comments READ MORE +

What should you include in the solution?

Topic 1, Contoso Case StudyTransactional Date Contoso has three years of customer, transactional, operation, sourcing, and supplier data comprised of 10 billion records stored across multiple on-premises Microsoft SQL Server servers. The SQL server instances contain data from various operational systems. The data is loaded into the instances by using...

September 5, 2021 No Comments READ MORE +

You store files in an Azure Data Lake Storage Gen2 container

HOTSPOT You store files in an Azure Data Lake Storage Gen2 container. The container has the storage policy 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 the graphic. NOTE: Each correct selection Is worth...

September 5, 2021 No Comments READ MORE +

The following code segment is used to create an Azure Databricks cluster

HOTSPOT The following code segment is used to create an Azure Databricks cluster. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Graphical user interface, text, application Description automatically generated Box 1:...

September 4, 2021 No Comments READ MORE +