How should you complete the Data Factory data flow script?

DRAG DROP You need to create an Azure Data Factory pipeline to process data for the following three departments at your company: Ecommerce, retail, and wholesale. The solution must ensure that data can also be processed for the entire company. How should you complete the Data Factory data flow script?...

January 30, 2025 No Comments READ MORE +

Which three actions should you perform?

You develop data engineering solutions for a company. A project requires the deployment of data to Azure Data Lake Storage. You need to implement role-based access control (RBAC) so that project members can manage the Azure Data Lake Storage resources. Which three actions should you perform? Each correct answer presents...

January 30, 2025 No Comments READ MORE +

Which Azure Storage functionality should you include in the solution?

You need to design a data retention solution for the Twitter feed data records. The solution must meet the customer sentiment analytics requirements. Which Azure Storage functionality should you include in the solution?A . change feedB . soft deleteC . time-based retentionD . lifecycle managementView AnswerAnswer: B Explanation: Scenario: Purge...

January 30, 2025 No Comments READ MORE +

Which input type should you use for the reference data?

You are developing a solution that will stream to Azure Stream Analytics. The solution will have both streaming data and reference data. Which input type should you use for the reference data?A . Azure Cosmos DBB . Azure Blob storageC . Azure IoT HubD . Azure Event HubsView AnswerAnswer: B...

January 29, 2025 No Comments READ MORE +

What should you do?

You are designing an Azure Databricks interactive cluster. The cluster will be used infrequently and will be configured for auto-termination. You need to ensure that the cluster configuration is retained indefinitely after the cluster is terminated. The solution must minimize costs. What should you do?A . Clone the cluster after...

January 29, 2025 No Comments READ MORE +

You have an Azure Synapse Analytics dedicated SQL pool that contains the users shown in the following table

HOTSPOT You have an Azure Synapse Analytics dedicated SQL pool that contains the users shown in the following table. User1 executes a query on the database, and the query returns the results shown in the following exhibit. User1 is the only user who has access to the unmasked data. Use...

January 28, 2025 No Comments READ MORE +

What should you create?

You need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements. What should you create?A . a table that has an IDENTITY propertyB . a system-versioned temporal tableC . a user-defined SEQUENCE objectD . a table that has a FOREIGN...

January 28, 2025 No Comments READ MORE +

On which column should you partition the table?

You are designing an inventory updates table in an Azure Synapse Analytics dedicated SQL pool. The table will have a clustered column store index and will include the following columns: You identify the following usage patterns: ✑ Analysts will most commonly analyze transactions for a warehouse. ✑ Queries will summarize...

January 28, 2025 No Comments READ 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 ....

January 27, 2025 No Comments READ MORE +

What should you do?

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

January 27, 2025 No Comments READ MORE +