DP-203 Exam Questions and Answers (P7)

Within Azure Synapse Link for Azure Cosmos DB, which Column-oriented store optimized for queries?

A company has an application that uses Azure SQL Database as the data store. The application experiences a large increase in activity during the last month of each year. You need to manually scale the Azure SQL Database instance to account for the increase in data write operations. Which scaling method should you recommend?

You are designing an Azure Data Factory pipeline for processing data. The pipeline will process data that is stored in general-purpose standard Azure storage. You need to ensure that the compute environment is created on-demand and removed when the process is completed. Which type of activity should you recommend?

You are planning a solution that combines log data from multiple systems. The log data will be downloaded from an API and stored in a data store. You plan to keep a copy of the raw data as well as some transformed versions of the data. You expect that there will be at least 2 TB of log files. The data will be used by data scientists and applications. You need to recommend a solution to store the data in Azure. The solution must minimize costs. What storage solution should you recommend?

How can you manage the lifecycle of data and define how long it will be retained for in an analytical store?

You can completely disable analytical store without deleting the container.

........................ is the first step to perform to use Azure Synapse Analytics serverless SQL pools to query the Azure Cosmos DB data.

A company purchases IoT devices to monitor manufacturing machinery. The company uses an IoT appliance to communicate with the IoT devices. The company must be able to monitor the devices in real-time. You need to design the solution. What should you recommend?

You are designing a serving layer for data. The design must authenticate users by using Azure Active Directory (Azure AD), serve as a hot path for data, support query scale out, and support SQL queries. What should you include in the design?

You have streaming data that is received by Azure Event Hubs and stored in Azure Blob storage. The data contains social media posts that relate to a keyword of Contoso. You need to count how many times the Contoso keyword and a keyword of Litware appear in the same post every 30 seconds. The data must be available to Microsoft Power BI in near real-time. Which solution should you do?

All data within an Azure Cosmos DB container is partitioned based on ........................

You are designing an audit strategy for an Azure SQL Database environment. You need to recommend a solution to provide real-time notifications for potential security breaches. The solution must minimize development effort. Which destination should you include in the recommendation?

A company purchases IoT devices to monitor manufacturing machinery. The company uses an IoT appliance to communicate with the IoT devices. The company must be able to monitor the devices in real-time. You need to design the solution. What should you recommend?

What SparkSQL method reads data from the analytical store?

Enabling analytical store is only available at the time of creating a container

How do you disable Azure Synapse Link for Azure Cosmos DB?

What is the name of the application architecture that enables near real-time querying to provide insights?

You need to design a solution to support the storage of datasets. The solution must send email alerts when new datasets are added, and control access to collections of datasets by using Azure Active Directory groups. Support the storage of Microsoft Excel, Comma Separated Values (CSV), and zip files. What should you include in the solution?

The ..................... enables you to specify the path to property values in a JSON document.

The .............. function allows you to access files in Azure Storage.

Nonrelational systems support ................

A company installs IoT devices to monitor its fleet of delivery vehicles. Data from devices is collected from Azure Event Hub. The data must be transmitted to Power BI for real-time data visualizations. You need to recommend a solution. What should you recommend?

.................... which separates the elements of array into multiple rows with positions and uses the column name pos for position, col for elements of the array.

You need to design a telemetry data solution that supports the analysis of log files in real time. Which two Azure services should you include in the solution?

Which Azure Storage option is a messaging store for reliable messaging between application components?

You plan to store delimited text files in an Azure Data Lake Storage account that will be organized into department folders. You need to configure data access so that users see only the files in their respective department folder. Which solution should meet your goal?

You are designing a solution for the ad hoc analysis of data in Azure Databricks notebooks. The data will be stored in Azure Blob storage. You need to ensure that Blob storage will support the recovery of the data if the data is overwritten accidentally. What should you recommend?

Where do you enable Azure Synapse Link for Azure Cosmos DB?

When you want to switch to SparkSQL in a notebook, what is the first command to type?

The .............. function provides a rowset view over a JSON document.

You are designing a storage solution for streaming data that is processed by Azure Databricks. The solution must meet the following requirements: The data schema must be fluid, the source data must have a high throughput, and the data must be available in multiple Azure regions as quickly as possible. What should you include in the solution to meet the requirements?

You are designing an anomaly detection solution for streaming data from an Azure IoT hub. The solution must send the output to Azure Synapse, identify spikes and dips in time series data, and minimize development and configuration effort Which should you include in the solution?

OLAP stands for .............

You plan to deploy a reporting database to Azure. The database will contain 30 GB of data. The amount of data will increase by 300 MB each year. Rarely will the database be accessed during the second and third weeks of each month. During the first and fourth week of each month, new data will be loaded each night. You need to recommend a solution for the planned database. The solution must minimize costs, and minimize administrative effort. What should you recommend?

You are designing an Azure Cosmos DB database that will contain news articles. The articles will have the following properties: Category, Created Datetime, Publish Datetime, Author, Headline, Body Text, and Publish Status. Multiple articles will be published in each category daily, but no two stories in a category will be published simultaneously. Headlines may be updated over time. Publish Status will have the following values: draft, published, updated, and removed. Most articles will remain in the published or updated status. Publish Datetime will be populated only when Publish Status is set to published. You will serve the latest articles to websites for users to consume. You need to recommend a partition key for the database container. The solution must ensure that the articles are served to the websites as quickly as possible. Which partition key should you recommend?

Which Azure Storage option is a scalable object store for text and binary data?

Before you can create an Azure Cosmos DB container with an analytical store, you must first .............

You plan to ingest streaming social media data by using Azure Stream Analytics. The data will be stored in files in Azure Data Lake Storage, and then consumed by using Azure Databricks and PolyBase in Azure Synapse Analytics. You need to recommend a Stream Analytics data output format to ensure that the queries from Databricks and PolyBase against the files encounter the fewest possible errors. The solution must ensure that the files can be queried quickly and that the data type information is retained. What should you recommend?

OLTP stands for ....................

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

You are designing a product catalog for a customer. The product data will be stored in Azure Cosmos DB. The product properties will be different for each product and additional properties will be added to products as needed. Which Cosmos DB API should you use to provision the database?

In order to query the data within your Cosmos DB analytical store from Azure Synapse using Spark, you need to configure ................

You are designing a big data storage solution. The solution must provide unlimited account sizes, support a hierarchical file system, and be optimized for parallel analytics workloads. Which storage solution should you use?

Which Azure Storage option is a managed file shares for cloud or on-premises deployments?