MICROSOFT-DP203

Microsoft's DP-203 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 part of the solution.NOTE: Each correct selection is worth one point. E. Configure access control lists (ACL) for the Azure Data Lake Storage account.

Microsoft's DP-203 You have an Azure Data Factory version 2 (V2) resource named Df1. Df1 contains a linked service.You have an Azure Key vault named vault1 that contains an encryption key named key1.You need to encrypt Df1 by using key1.What should you do first?

Microsoft's DP-203 You are designing an Azure Synapse Analytics dedicated SQL pool.You need to ensure that you can audit access to Personally Identifiable Information (PII).What should you include in the solution?

Microsoft's DP-203 You have a data warehouse in Azure Synapse Analytics.You need to ensure that the data in the data warehouse is encrypted at rest.What should you enable?

Microsoft's DP-203 You are designing a streaming data solution that will ingest variable volumes of data.You need to ensure that you can change the partition count after creation.Which service should you use to ingest the data?

Microsoft's DP-203 You are designing a date dimension table in an Azure Synapse Analytics dedicated SQL pool. The date dimension table will be used by all the fact tables.Which distribution type should you recommend to minimize data movement during queries?

Microsoft's DP-203 You are designing a security model for an Azure Synapse Analytics dedicated SQL pool that will support multiple companies.You need to ensure that users from each company can view only the data of their respective company.Which two objects should you include in the solution? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point. E. asymmetric keys

Microsoft's DP-203 You have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The table contains a column name Email.You need to prevent nonadministrative users from seeing the full email addresses in the Email column. The users must see values in a format of [email protected] instead.What should you do?

Microsoft's DP-203 You have an Azure Data Lake Storage Gen2 account named adls2 that is protected by a virtual network.You are designing a SQL pool in Azure Synapse that will use adls2 as a source.What should you use to authenticate to adls2?

Microsoft's DP-203 You are designing an Azure Synapse solution that will provide a query interface for the data stored in an Azure Storage account. The storage account is only accessible from a virtual network.You need to recommend an authentication mechanism to ensure that the solution can access the source data.What should you recommend?

Microsoft's DP-203 You are developing an application that uses Azure Data Lake Storage Gen2.You need to recommend a solution to grant permissions to a specific application for a limited time period.What should you include in the recommendation?

Microsoft's DP-203 You are designing database for an Azure Synapse Analytics dedicated SQL pool to support workloads for detecting ecommerce transaction fraud.Data will be combined from multiple ecommerce sites and can include sensitive financial information such as credit card numbers.You need to recommend a solution that meets the following requirements:Users must be able to identify potentially fraudulent transactions.✑ Users must be able to use credit cards as a potential feature in models.✑ Users must NOT be able to access the actual credit card numbers.What should you include in the recommendation?

Microsoft's DP-203 You have an Azure subscription linked to an Azure Active Directory (Azure AD) tenant that contains a service principal named ServicePrincipal1. The subscription contains an Azure Data Lake Storage account named adls1. Adls1 contains a folder named Folder2 that has a URI of https://adls1.dfs.core.windows.net/ container1/Folder1/Folder2/.ServicePrincipal1 has the access control list (ACL) permissions shown in the following table.You need to ensure that ServicePrincipal1 can perform the following actions:✑ Traverse child items that are created in Folder2.✑ Read files that are created in Folder2.The solution must use the principle of least privilege.Which two permissions should you grant to ServicePrincipal1 for Folder2? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point. E. Default ג€" Write F. Default ג€" Execute

Microsoft's DP-203 You have an Azure Synapse Analytics dedicated SQL pool.You need to ensure that data in the pool is encrypted at rest. The solution must NOT require modifying applications that query the data.What should you do?

Microsoft's DP-203 You have an Azure Synapse Analytics dedicated SQL pool named Pool1 that contains a table named Sales.Sales has row-level security (RLS) applied. RLS uses the following predicate filter.A user named SalesUser1 is assigned the db_datareader role for Pool1.Which rows in the Sales table are returned when SalesUser1 queries the table?

Microsoft's DP-203 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?

Microsoft's DP-203 You have an Azure Synapse Analytics dedicated SQL pool that contains a table named dbo.Users.You need to prevent a group of users from reading user email addresses from dbo.Users.What should you use?

Microsoft's DP-203 You have an Azure subscription that contains a storage account named storage1 and an Azure Synapse Analytics dedicated SQL pool. The storage1 account contains a CSV file that requires an account key for access.You plan to read the contents of the CSV file by using an external table.You need to create an external data source for the external table.What should you create first?

Microsoft's DP-203 You have a tenant in Microsoft Azure Active Directory (Azure AD), part of Microsoft Entra. The tenant contains a group named Group1.You have an Azure subscription that contains the resources shown in the following table.You need to ensure that members of Group1 can read CSV files from storage1 by using the OPENROWSET function. The solution must meet the following requirements:• The members of Group1 must use credential1 to access storage1.• The principle of least privilege must be followed.Which permission should you grant to Group1?

Microsoft's DP-203 You have an Azure subscription that contains an Azure Data Lake Storage account named dl1 and an Azure Analytics Synapse workspace named workspace1.You need to query the data in dl1 by using an Apache Spark pool named Pool1 in workspace1. The solution must ensure that the data is accessible Pool1.Which two actions achieve the goal? Each correct answer presents a complete solution.NOTE: Each correct answer is worth one point.

Microsoft's DP-203 You have an Azure Synapse Analytics dedicated SQL pool named SQL1 and a user named User1.You need to ensure that User1 can view requests associated with SQL1 by querying the sys.dm_pdw_exec_requests dynamic management view. The solution must follow the principle of least privilege.Which permission should you grant to User1?

Microsoft's DP-203 You have a Microsoft Entra tenant.The tenant contains an Azure Data Lake Storage Gen2 account named storage1 that has two containers named fs1 and fs2.You have a Microsoft Entra group named DepartmentA.You need to meet the following requirements:• DepartmentA must be able to read, write, and list all the files in fs1.• DepartmentA must be prevented from accessing any files in fs2.• The solution must use the principle of least privilege.Which role should you assign to DepartmentA?

Microsoft's DP-203 You implement an enterprise data warehouse in Azure Synapse Analytics.You have a large fact table that is 10 terabytes (TB) in size.Incoming queries use the primary key SaleKey column to retrieve data as displayed in the following table:You need to distribute the large fact table across multiple nodes to optimize performance of the table.Which technology should you use? E. heap table with distribution replicate

Microsoft's DP-203 You have an Azure Synapse Analytics dedicated SQL pool that contains a large fact table. The table contains 50 columns and 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?

Microsoft's DP-203 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?

Microsoft's DP-203 You have an Azure data factory.You need to examine the pipeline failures from the last 60 days.What should you use?

Microsoft's DP-203 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?

Microsoft's DP-203 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?

Microsoft's DP-203 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 successfully when the adhoc queries run.What should you do?

Microsoft's DP-203 You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and a database named DB1. DB1 contains a fact table named Table1.You need to identify the extent of the data skew in Table1.What should you do in Synapse Studio?