DP-203 Exam Questions and Answers (P9)

You are designing the security for an Azure SQL database. You have an Azure Active Directory (Azure AD) group named Group1. You need to recommend a solution to provide Group1 with read access to the database only. What should you include in the recommendation?

An entity that reads data from the Event Hubs is called a ..................

Which Window type model scheduled overlapping windows, jumping forward in time by a fixed period?

If you don't specify a pricing tier for Azure Event Hubs, the default will be ........................

Which Window type generate events for points in time when the content of the window actually changed?

A company is developing a solution to manage inventory data for a group of automotive repair shops. The solution will use Azure Synapse Analytics as the data store. Shops will upload data every 10 days. Data corruption checks must run each time data is uploaded. If corruption is detected, the corrupted data must be removed. You need to ensure that upload processes and data corruption checks do not impact reporting and analytics processes that use the data warehouse. Which solution should you do?

A disadvantage of the ETL approach is that .................

Non-Structured data is straightforward in that it's easy to enter, query, and analyze

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

Which Window type cluster together events that arrive at similar times, filtering out periods of time where there is no data?

........................... is a big data streaming platform and event ingestion service, which you can use to feed events from event producers into Azure Stream Analytics.

ELT stands for

Where you can view your Event Hub activity?

A company has many applications. Each application is supported by separate on-premises databases. You must migrate the databases to Azure SQL Database. You have to organize databases into groups based on database usage, and Define the maximum resource limit available for each group of databases. You need to recommend technologies to scale the databases to support expected increases in demand. What should you recommend?

An entity that sends data to the Event Hubs is called a ..................

Below is a list of key benefits of using Azure Stream Analytics to process streaming data. Which of the following statements is incorrect?

Which Window type groups events by identical timestamp values?

A company is designing a solution that uses Azure Databricks. The solution must be resilient to regional Azure datacenter outages. You need to recommend the redundancy type for the solution. What should you recommend?

You have an on-premises MySQL database that is 800 GB in size. You need to migrate a MySQL database to Azure Database for MySQL. You must minimize service interruption to live sites or applications that use the database. What should you recommend?

You plan to implement an Azure Data Lake Gen2 storage account. You need to ensure that the data lake will remain available if a data center fails in the primary Azure region. The solution must minimize costs. Which type of replication should you use for the storage account?

You have a line-of-business (LOB) app that reads files from and writes files to Azure Blob storage in an Azure Storage account. You need to recommend changes to the storage account to meet the following requirements: Provide the highest possible availability. Minimize potential data loss. Which three changes should you recommend?

A company is evaluating data storage solutions. You need to recommend a data storage solution that meets Minimize costs for storing blob objects, Optimize access for data that is infrequently accessed, Data must be stored for at least 30 days, and Data availability must be at least 99 percent. What should you recommend?

Which of the following services is a valid input for an Azure Stream Analytics job?

What is the maximum size for a single publication (individual or batch) that is allowed by Azure Event Hub?

Scalability in cloud systems is complicated and time-consuming

To deploy Azure Event Hubs, you must configure an Event Hubs namespace, and then configure the Event Hub itself

A company is developing a mission-critical line of business app that uses Azure SQL Database Managed Instance. You must design a disaster recovery strategy for the solution/ You need to ensure that the database automatically recovers when full or partial loss of the Azure SQL Database service occurs in the primary region. What should you recommend?

You have an Azure Data Lake Storage account that has a virtual network service endpoint configured. You plan to use Azure Data Factory to extract data from the Data Lake Storage account. The data will then be loaded to a data warehouse in Azure Synapse Analytics by using PolyBase. Which authentication method should you use to access Data Lake Storage?

Which of the following technologies typically provide an ingestion point for data streaming in an event processing solution that uses streaming data as a source?

ETL stands for

..................... is data that adheres to a strict schema, so all of the data has the same fields or properties.

........................... provides an ingestion point for data streaming in an event processing solution that uses static data as a source.

You are designing an Azure Databricks cluster that runs user-defined local processes. You need to recommend a cluster configuration that Minimize query latency, Reduce overall costs without compromising other requirements, and Maximize the number of users that can run queries on the cluster at the same time. Which cluster type should you recommend?

.................... is flexible and can express complex data easily. However, it tends to be more verbose making it larger to store, process, or pass over a network.

Which Window type segment a data stream into a contiguous series of fixed-size, non-overlapping time segments and operate against them?

Semi-structured data is also referred to as non-relational or NoSQL data.

Which tool provides a platform for visualizing and analyzing aggregated data in a near-real-time analytics pipeline?

Which role works with Azure Cognitive Services, Cognitive Search, and the Bot Framework?

................. is a platform-as-a-service (PaaS) event processing engine.

By default, how many partitions will a new Event Hub have?

..................... is less organized than structured data, and is not stored in a relational format, as the fields do not neatly fit into tables, rows, and columns.

Which Azure data platform is commonly used to process data in an ELT framework?

Which of the following services is a valid output for an Azure Stream Analytics job?

You are developing a solution that performs real-time analysis of IoT data in the cloud. The solution must remain available during Azure service updates. You need to recommend a solution. Which two actions should you recommend?