DP-203 Exam Questions and Answers (P6)

You have an Azure SQL database that has masked columns. You need to identify when a user attempts to infer data from the masked columns. What should you use?

In non-relational systems, the data structure is defined at design time.

Your company uses several Azure HDInsight clusters. The data engineering team reports several errors with some applications using these clusters. You need to recommend a solution to review the health of the clusters. What should you include in your recommendation?

You have an Azure Cosmos DB database that uses the SQL API. You need to delete stale data from the database automatically. What should you use?

What are the possible ways to optimize an Apache Spark Job?

Azure Cosmos DB analytical store is a fully isolated column store for enabling large-scale analytics against operational data in your Azure Cosmos DB, without any impact to your transactional workloads.

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?

You develop data engineering solutions for a company. A project requires the deployment of resources to Microsoft Azure for batch data processing on Azure HDInsight. Batch processing will run daily and must Scale to minimize costs and Be monitored for cluster performance You need to recommend a tool that will monitor clusters and provide information to suggest how to scale.

Azure Synapse Link for Azure Cosmos DB is a cloud-native HTAP capability that enables you to run near-real-time analytics over operational data stored in Azure Cosmos DB.

Your company uses Azure Stream Analytics to monitor devices. The company plans to double the number of devices that are monitored. You need to monitor a Stream Analytics job to ensure that there are enough processing resources to handle the additional load. Which metric should you monitor?

You are designing an application. You plan to use Azure SQL Database to support the application. The application will extract data from the Azure SQL Database and create text documents. The text documents will be placed into a cloud-based storage solution. The text storage solution must be accessible from an SMB network share. You need to recommend a data storage solution for the text documents. Which Azure data storage type should you recommend?

For SQL (Core) API accounts, when analytical store is enabled, the default schema representation in the analytical store is ...............

You have an Azure data solution that contains an enterprise data warehouse in Azure Synapse Analytics named DW1. Several users execute adhoc 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?

In relational database systems like Microsoft SQL Server, Azure SQL Database, and Azure SQL Data Warehouse, data structure is not defined at design time

You are designing a data store that will store organizational information for a company. The data will be used to identify the relationships between users. The data will be stored in an Azure Cosmos DB database and will contain several million objects. You need to recommend which API to use for the database. The API must minimize the complexity to query the user relationships. The solution must support fast traversals. Which API should you recommend?

You have an activity in an Azure Data Factory pipeline. The activity calls a stored procedure in a data warehouse in Azure Synapse Analytics and runs daily. You need to verify the duration of the activity when it ran last. What should you use?

HTAP Stands for

...................... creates a data structure and it's one of the core data structures in Apache Spark.

You can only enable analytical store at the time of creating Azure Cosmos DB container

Azure Synapse Analytics Spark pools support various languages. The primary languages available within the notebook environment are:

You need to recommend a storage solution for a sales system that will receive thousands of small files per minute. The files will be in JSON, text, and CSV formats. The files will be processed and transformed before they are loaded into a data warehouse in Azure Synapse Analytics. The files must be stored and secured in folders. Which storage solution should you recommend?

In non-relational systems, The data structure is defined only when the data is read.

.......... systems are optimized for dealing with discrete system or user requests immediately and responding as quickly as possible.

.............. creates a simple tabular representation of the schema-agnostic data in the transactional store as it copies it to the analytical store.

A company stores data in multiple types of cloud-based databases. You need to design a solution to consolidate data into a single relational database. Ingestion of data will occur at set times each day. What should you recommend?

You have an enterprise data warehouse in Azure Synapse Analytics named DW1 on a server named Server1. You need to verify whether the size of the transaction log file for each distribution of DW1 is smaller than 160 GB. What should you do?

You can only use one supported language in notebook

You are designing an Azure Cosmos DB database that will support vertices and edges. Which Cosmos DB API should you include in the design?

You are designing an application that will have an Azure virtual machine. The virtual machine will access an Azure SQL database. The database will not be accessible from the Internet. You need to recommend a solution to provide the required level of access to the database. What should you include in the recommendation?

You have an Azure Blob storage account. Developers report that an HTTP 403 (Forbidden) error is generated when a client application attempts to access the storage account. You cannot see the error messages in Azure Monitor. What is a possible cause of the error?

You have a MongoDB database that you plan to migrate to an Azure Cosmos DB account that uses the MongoDB API. During testing, you discover that the migration takes longer than expected. You need to recommend a solution that will reduce the amount of time it takes to migrate the data. What are two possible recommendations to achieve this goal?

What are Azure Synapse Studio notebooks based on?

Examples of non-structured data include ................

.......... systems are optimized for the analytical processing, ingesting, synthesizing, and managing large sets of historical data.

You are evaluating data storage solutions to support a new application. You need to recommend a data storage solution that represents data by using nodes and relationships in graph structures. Which data storage solution should you recommend?

In order to create an Apache Spark pool in Azure Synapse Analytics, what needs to be created first?

What can cause a slower performance on join or shuffle jobs?

.................. is a managed Apache Spark-as-a-Service propriety solution that provides an end-to-end data engineering/data science platform

.......................... is the web user interface known as the Spark UI, and is used to view completed and running Apache Spark applications

You have an Azure Blob storage account. The storage account has an alert that is configured to indicate when the Availability metric falls below 100 percent. You receive an alert for the Availability metric. The logs for the storage account show that requests are failing because of a ServerTimeoutError error. What does ServerTimeoutError indicate?

Which one is an element of an Apache Spark Pool in Azure Synapse Analytics?

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 for infrequently used queries. You need to monitor resource utilization to determine the source of the performance issues. Which metric should you monitor?

You can find the notebooks in the ................ hub of the Azure Data studio experience.

If you want to monitor your Apache Spark pool, the best place to go is the ............ tab in Azure Synapse Studio