You have a Microsoft Purview account.The Lineage view of a CSV file is shown in the following exhibit.How is the data for the lineage populated?
You have an Azure subscription that is linked to a tenant in Microsoft Azure Active Directory (Azure AD), part of Microsoft Entra. The tenant that contains a security group named Group1. The subscription contains an Azure Data Lake Storage account named myaccount1. The myaccount1 account contains two containers named container1 and container2.You need to grant Group1 read access to container1. The solution must use the principle of least privilege.Which role should you assign to Group1?
You have an Azure subscription that contains the resources shown in the following table.You need to read the TSV files by using ad-hoc queries and the OPENROWSET function. The solution must assign a name and override the inferred data type of each column.What should you include in the OPENROWSET function?
You are designing a solution that will use tables in Delta Lake on Azure Databricks.You need to minimize how long it takes to perform the following:• Queries against non-partitioned tables• Joins on non-partitioned columnsWhich two options should you include in the solution? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
HOTSPOT -You are designing a monitoring solution for a fleet of 500 vehicles. Each vehicle has a GPS tracking device that sends data to an Azure event hub once per minute.You have a CSV file in an Azure Data Lake Storage Gen2 container. The file maintains the expected geographical area in which each vehicle should be.You need to ensure that when a GPS position is outside the expected area, a message is added to another event hub for processing within 30 seconds. The solution must minimize cost.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.Hot Area:
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?
