DP-203 Exam Questions and Answers (P9)

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?

ETL stands for

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

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?

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

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?

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

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?

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?

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

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

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

Which Window type groups events by identical timestamp values?

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?

Scalability in cloud systems is complicated and time-consuming

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?

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 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.

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?

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

.................... 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.

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?

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

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

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?

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

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

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

Where you can view your Event Hub activity?

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

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

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

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

ELT stands for

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

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

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

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

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

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

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?

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

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?