- All Exams Instant Download
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...
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...
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...
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...
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...
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 ....
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...
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...
Which technologies should you use?
HOTSPOT You are developing a solution using a Lambda architecture on Microsoft Azure. The data at test layer must meet the following requirements: Data storage: • Serve as a repository (or high volumes of large files in various formats. • Implement optimized storage for big data analytics workloads. • Ensure...
How should you complete the query?
HOTSPOT You are building an Azure Analytics query that will receive input data from Azure IoT Hub and write the results to Azure Blob storage. You need to calculate the difference in readings per sensor per hour. How should you complete the query? To answer, select the appropriate options in...
