What should you do?

You have an Azure Factory instance named DF1 that contains a pipeline named PL 1. PL1 includes a tumbling window trigger. You create five clones of PL 1. You configure each clone pipeline to use a different data source. You need to ensure that the execution schedules of the clone...

September 15, 2024No CommentsREAD MORE +

Which Azure Storage functionality should you include in the solution?

You need to design a data retention solution for the Twitter teed data records. The solution must meet the customer sentiment analytics requirements. Which Azure Storage functionality should you include in the solution?A . time-based retentionB . change feedC . soft deleteD . Iifecycle managementView AnswerAnswer: D

September 14, 2024No CommentsREAD MORE +

What should you do first?

You have an Azure Databricks workspace named workspace1 in the Standard pricing tier. You need to configure workspace1 to support autoscaling all-purpose clusters. The solution must meet the following requirements: ✑ Automatically scale down workers when the cluster is underutilized for three minutes. ✑ Minimize the time it takes to...

September 14, 2024No CommentsREAD MORE +

Which type of slowly changing dimension (SCD) should use?

You are designing a dimension table for a data warehouse. The table will track the value of the dimension attributes over time and preserve the history of the data by adding new rows as the data changes. Which type of slowly changing dimension (SCD) should use?A . Type 0B ....

September 14, 2024No CommentsREAD MORE +

Which type of window should you use?

You are designing an Azure Stream Analytics job to process incoming events from sensors in retail environments. You need to process the events to produce a running average of shopper counts during the previous 15 minutes, calculated at five-minute intervals . Which type of window should you use?A . snapshotB...

September 14, 2024No CommentsREAD 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 13, 2024No CommentsREAD 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...

September 13, 2024No CommentsREAD MORE +

Which Azure Data Factory components should you recommend using together to import the daily inventory data from the SQL server to Azure Data Lake Storage?

HOTSPOT Which Azure Data Factory components should you recommend using together to import the daily inventory data from the SQL server to Azure Data Lake Storage? To answer, select the appropriate options in the answer area . NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1:...

September 13, 2024No CommentsREAD MORE +

For which error should you monitor?

You configure monitoring for a Microsoft Azure SQL Data Warehouse implementation. The implementation uses PolyBase to load data from comma-separated value (CSV) files stored in Azure Data Lake Gen 2 using an external table. Files with an invalid schema cause errors to occur. You need to monitor for an invalid...

September 13, 2024No CommentsREAD MORE +

Which type of replication should you use for the storage account?

You plan to implement an Azure Data Lake Gen2 storage account. You need to ensure that the data lake will remain available if a data center fails in the primary Azure region. The solution must minimize costs. Which type of replication should you use for the storage account?A . geo-redundant...

September 13, 2024No CommentsREAD MORE +