DP-203 Exam Questions and Answers (P5)

In dedicated SQL pool in Azure Synapse Analytics, INSERT..SELECT is a Minimal logged operation

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?

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?

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?

.................. is a parallel processing framework that supports in-memory processing to boost the performance of big-data analytics applications

............. is a cloud-integration service that orchestrates the movement of data between various data stores.

Which one is not a Dynamic Management View?

In Dedicated SQL pools, minimizing the size of data types shortens the row length leads to better query performance

Azure Synapse Analytics doesn't' support Dynamic Data Masking

In dedicated SQL pool in Azure Synapse Analytics, the DELETE is a Minimal logged operation

In Azure Synapse Workspace Firewall settings, Which ports you should allow for Synapse Studio?

Azure Synapse Analytics Workspace requires to access an Azure Data Lake Store using the benefits of the security provided by Azure Active Directory. What is the best authentication method to use?

To achieve improved query performance, which one would be the best data type for storing data that contains less than 50 characters?

In Azure Synapse Workspace Firewall settings, Which TCP port you should allow to connect using tools such as SSMS and Power BI?

In the Azure Synapse SQL pool, .................. provide a low maintenance method for complex analytical queries to quickly perform without any query change

Which Dynamic Management View exposes useful information such as number of rows in rowgroups and the reason for trimming, if there was trimming?

In Azure Synapse Studio, In order to create a private endpoint, you first must

When you design your Stream Analytics query, refer to the name of the output by using the .................

You have an enterprise-wide Azure Data Lake Storage Gen2 account. The data lake is accessible only through an Azure virtual network named VNET1. You are building a SQL pool in Azure Synapse that will use data from the data lake. Your company has a sales team. All the members of the sales team are in an Azure Active Directory group named Sales. POSIX controls are used to assign the Sales group access to the files in the data lake. You plan to load data to the SQL pool every hour. You need to ensure that the SQL pool can load the sales data from the data lake. Which three actions should you perform?

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 provide the fastest query time, and minimize data movement during queries. Which type of table should you use?

............. is a fully managed cloud service that used to discover, understand, and consume data sources

............. is a serverless platform that's optimized for Azure, provides one-click setup, streamlined workflows, and an interactive workspace for Spark-based applications.

A company plans to use Azure Storage for file storage purposes. Compliance rules require: A single storage account to store all operations including reads, writes and deletes and a Retention of an on-premises copy of historical operations You need to configure the storage account. Which two actions should you perform?

You use Azure Stream Analytics to receive Twitter data from Azure Event Hubs and to output the data to an Azure Blob storage account. You need to output the count of tweets during the last five minutes every five minutes. Each tweet must only be counted once. Which windowing function should you use?

You develop data engineering solutions for a company. You need to ingest and visualize real-time Twitter data by using Microsoft Azure. Which three technologies should you use?

A quick way to check for data skew is to use

You are developing a solution that will use Azure Stream Analytics. The solution will accept an Azure Blob storage file named Customers. The file will contain both in-store and online customer details. The online customers will provide a mailing address. You have a file in Blob storage named LocationIncomes that contains median incomes based on location. The file rarely changes. You need to use an address to look up a median income based on location. You must output the data to Azure SQL Database for immediate use and to Azure Data Lake Storage Gen2 for long-term retention. Solution: You implement a Stream Analytics job that has .......................

You are designing an enterprise data warehouse in Azure Synapse Analytics. You plan to load millions of rows of data into the data warehouse each day. You must ensure that staging tables are optimized for data loading. You need to design the staging tables. What type of tables should you recommend?

You develop data engineering solutions for a company. You must integrate the company on-premises Microsoft SQL Server data with Microsoft Azure SQL Database. Data must be transformed incrementally. You need to implement the data integration solution. Which tool should you use to configure a pipeline to copy data?

........................ returns the number of table rows that are stored in each of the 60 distributions.

Which data types that dedicated SQL pool doesn't support

You have an Azure subscription that contains an Azure Storage account. You plan to implement changes to a data storage solution to meet regulatory and compliance standards. Every day, Azure needs to identify and delete blobs that were NOT modified during the last 100 days. Which solution should you do?

Which Dynamic Management View enables the view the active connections against a dedicated SQL pool?

In dedicated SQL pool in Azure Synapse Analytics, Minimally logged operations keep track of every row change

You have an Azure virtual machine that has Microsoft SQL Server installed. The database on the virtual machine contains a table named Table1. You need to copy the data from Table1 to an Azure Data Lake Storage Gen2 account by using an Azure Data Factory V2 copy activity. Which type of integration runtime should you use?

A company runs Microsoft SQL Server in an on-premises virtual machine (VM). You must migrate the database to Azure SQL Database. You synchronize users from Active Directory to Azure Active Directory (Azure AD). You need to configure Azure SQL Database to use an Azure AD user as administrator. What should you configure?

You can use minimal logging to recover the database to the point of failure

You use Azure Stream Analytics to receive Twitter data from Azure Event Hubs and to output the data to an Azure Blob storage account. You need to output the count of tweets from the last five minutes every minute. Which windowing function should you use?

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 aXXX@XXXX.com instead. What should you do?

Data engineers provision and set up data platform technologies that are only in the cloud.

..................... enable you to define the type of traffic that is allowed or denied access to an Azure Synapse workspace using the originating IP address of the client that is trying to access the Azure Synapse Workspace

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

You need to implement complex stateful business logic within an Azure Stream Analytics service. Which type of function should you create in the Stream Analytics topology?

You have an Azure SQL database named DB1 that contains a table named Table1. Table1 has a field named Customer_ID that is varchar(22). You need to implement masking for the Customer_ID field to be The first two prefix characters must be exposed, The last four suffix characters must be exposed, and All other characters must be masked. Which solution should you use?