You manage an enterprise data warehouse in Azure Synapse Analytics.Users report slow performance when they run commonly used queries. Users do not report performance changes forinfrequently used queries.You need to monitor resource utilization to determine the source of the performance issues.Which metric 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 schema error. For which error should you monitor?

You have an Azure subscription that contains an Azure Synapse Analytics workspace named ws1 and an Azure Cosmos D6 database account named Cosmos1 Costmos1 contains a container named container 1 and ws1 contains a serverless1 SQL pool. you need to ensure that you can Query the data in container by using the serverless1 SQL pool. Which three actions should you perform? Each correct answer presents part of the solution NOTE: Each correct selection is worth one point.

You have a Microsoft SQL Server database that uses a third normal form schema. You plan to migrate the data in the database to a star schema in an A?\ire Synapse Analytics dedicated SQI pool. You need to design the dimension tables. The solution must optimize read operations. What should you include in the solution? to answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

You have an Azure subscription that contains an Azure Data Factory data pipeline named Pipeline1, a Log Analytics workspace named LA1, and a storage account named account1. You need to retain pipeline-run data for 90 days. The solution must meet the following requirements: * The pipeline-run data must be removed automatically after 90 days. * Ongoing costs must be minimized. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one

You have an Azure Synapse Analytics dedicated SQL pod. You need to create a pipeline that will execute a stored procedure in the dedicated SQL pool and use the returned result set as the input (or a downstream activity. The solution must minimize development effort. Which Type of activity should you use in the pipeline?

You have an Azure Data Factory pipeline named pipeline1 that is invoked by a tumbling window trigger named Trigger1. Trigger1 has a recurrence of 60 minutes. You need to ensure that pipeline1 will execute only if the previous execution completes successfully. How should you configure the self-dependency for Trigger1? Tumbling window self-dependency properties In scenarios where the trigger shouldn't proceed to the next window until the preceding window is successfully completed, build a self-dependency. A s

You have a SQL pool in Azure Synapse.A user reports that queries against the pool take longer than expected to complete. You determine that the issue relates toqueried columnstore segments.You need to add monitoring to the underlying storage to help diagnose the issue.Which two metrics should you monitor? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

You have a data model that you plan to implement in a data warehouse in Azure Synapse Analytics as shown in the following exhibit. All the dimension tables will be less than 2 GB after compression, and the fact table will be approximately 6 TB. Which type of table should you use for each table? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

You create an Azure Databricks cluster and specify an additional library to install.When you attempt to load the library to a notebook, the library in not found.You need to identify the cause of the issue.What should you review?

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 company purchases IoT devices to monitor manufacturing machinery. The company uses an Azure IoT Hub tocommunicate with the IoT devices.The company must be able to monitor the devices in real-time.You need to design the solution.What should you recommend?

You have an Azure Synapse Analytics dedicated SQL pool that contains a large fact table. The table contains 50 columnsand 5 billion rows and is a heap.Most queries against the table aggregate values from approximately 100 million rows and return only two columns.You discover that the queries against the fact table are very slow.Which type of index should you add to provide the fastest query times?

You have an Azure data solution that contains an enterprise data warehouse in Azure Synapse Analytics named DW1.Several users execute ad hoc queries to DW1 concurrently.You regularly perform automated data loads to DW1.You need to ensure that the automated data loads have enough memory available to complete quickly and successfullywhen the adhoc queries run.What should you do?

You have an Azure data factory.You need to examine the pipeline failures from the last 60 days.What should you use?

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?

You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and a database named DB1. DB1 contains a facttable named Table1.You need to identify the extent of the data skew in Table1.What should you do in Synapse Studio?

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?

You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Table1. You have files that are ingested and loaded into an Azure Data Lake Storage Gen2 container named container1. You plan to insert data from the files into Table1 and azure Data Lake Storage Gen2 container named container1. You plan to insert data from the files into Table1 and transform the data. Each row of data in the files will produce one row in the serving layer of Table1. You need to ensure that when the source da

You are monitoring an Azure Stream Analytics job.The Backlogged Input Events count has been 20 for the last hour.You need to reduce the Backlogged Input Events count.What should you do?

You have a SQL pool in Azure Synapse.You discover that some queries fail or take a long time to complete.You need to monitor for transactions that have rolled back.Which dynamic management view should you query?

You plan to create an Azure Synapse Analytics dedicated SQL pool. You need to minimize the time it takes to identify queries that return confidential information as defined by the company's data privacy regulations and the users who executed the queues. Which two components should you include in the solution? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

You have an Azure Active Directory (Azure AD) tenant that contains a security group named Group1. You have an Azure Synapse Analytics dedicated SQL pool named dw1 that contains a schema named schema1. You need to grant Group1 read-only permissions to all the tables and views in schema1. The solution must use the principle of least privilege. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct

You are designing an Azure Databricks interactive cluster. The cluster will be used infrequently and will be configured forauto-termination.You need to use that the cluster configuration is retained indefinitely after the cluster is terminated. The solution mustminimize costs.What should you do?

You are designing an inventory updates table in an Azure Synapse Analytics dedicated SQL pool. The table will have aclustered columnstore 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 by product category type, date, and/or inventory event type.You need to recommend a partition strategy for the table to minimize query times.On which column should you partition the table?

You are designing a star schema for a dataset that contains records of online orders. Each record includes an order date, anorder due date, and an order ship date.You need to ensure that the design provides the fastest query times of the records when querying for arbitrary date rangesand aggregating by fiscal calendar attributes.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

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 answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an Azure Storage account that contains 100 GB of files. The files co

You have an Azure SQL database named DB1 and an Azure Data Factory data pipeline named pipeline. From Data Factory, you configure a linked service to DB1. In DB1, you create a stored procedure named SP1. SP1 returns a single row of data that has four columns. You need to add an activity to pipeline to execute SP1. The solution must ensure that the values in the columns are stored as pipeline variables. Which two types of activities can you use to execute SP1? (Refer to Data Engineering on Microsoft Azure d

You need to design an Azure Synapse Analytics dedicated SQL pool that meets the following requirements: Can return an employee record from a given point in time. Maintains the latest employee information. Minimizes query complexity. How should you model the employee data?