You plan to create a dimension table in Azure Synapse Analytics that will be less than 1 GB.You need to create the table to meet the following requirements:* Provide the fastest Query time.* Minimize data movement during queries.Which type of table should you use?
You have an Azure Stream Analytics query. The query returns a result set that contains 10,000 distinct values for a column named clusterID.You monitor the Stream Analytics job and discover high latency.You need to reduce the latency.Which two actions should you perform? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.
You have an Azure data factory that connects to a Microsoft Purview account. The data factory is registered in Microsoft Purview.You update a Data Factory pipeline.You need to ensure that the updated lineage is available in Microsoft Purview.What You have an Azure subscription that contains an Azure SQL database named DB1 and a storage account named storage1. The storage1 account contains a file named File1.txt. File1.txt contains the names of selected tables in DB1.You need to use an Azure Synapse pipeline to copy data from the selected tables in DB1 to the files in storage1. The solution must meet the following requirements:* The Copy activity in the pipeline must be parameterized to use the data in File1.txt to identify the source and destination of the copy.* Copy activities must occur in parallel as often as possible.Which two pipeline activities should you include in the pipeline? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
What should you recommend to prevent users outside the Litware on-premises network from accessing the analytical data store?
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 year or current month.Which folder structure should you recommend to support fast queries and simplified folder security?