DP-203 Exam Prep Quiz

You are implementing an Azure Data Lake Gen2 storage account. You need to ensure that data will be accessible for write and read operations both even if an entire data center (zonal or non-zonal) becomes unavailable. Which kind of replication would you use for the storage account?

(Choose the solution with minimum cost)

• Locally redundant storage (LRS)

• Zone-redundant storage (ZRS)

• Geo-redundant storage (GRS)

• Geo-zone-redundant storage (GZRS)

While working on one of your company's projects, your teammate wants to check the options for input to an Azure Stream Analytics task that needs high throughput and low latencies. He is confused about the input that he should use in this case. He approaches you and asks you to help him. Which of the following Azure product would you suggest to him?

• Azure Table Storage

• Azure Blob Storage

• Azure Queue Storage

• Azure Event Hubs

You have created a DataFrame. But before issuing SQL Queries, you decide to save your DataFrame as a temporary view. Which of the following DataFrame method will help you in creating the temporary view?

• createTempView

• createOrReplaceTempView

• ReplaceTempView

• createTempViewForDataFrame

• CreateorReplaceDFTempView

An Azure Data Factory pipeline needs to be executed in such a way that when there is a deletion of a file in the Azure Data Lake Storage Gen2 container. Which kind of trigger would you prefer?

• Schedule Trigger

• On-demand Trigger

• Event Trigger

• Tumbling Window

You are working as Data Administrator in the TDC company. You need to retrieve data from a data explorer database. In which of the following languages these log queries are written?

• PL/SQL

• SQL

• Kusto Query Language (KQL)

• Transact – SQL

When a customer changes their phone number, the change should be made in the existing row for that customer in the dimension table. What type of slowly changing dimension is this?

• Type 0

• Type 1

• Type 2

You create a dimension table for product data, assigning a unique numeric key for each row in a column named ProductKey. The ProductKey is only defined in the data warehouse. What kind of key is ProductKey?

• A surrogate key

• An alternate key

• A business key

You want to scan data assets in a dedicated SQL pool in your Azure Synapse Analytics workspace. What kind of source should you register in Microsoft Purview?

• Azure Synapse Analytics

• Azure Data Lake Storage Gen2

• Azure SQL Database

You plan to create an Azure Databricks workspace and use the SQL persona view in the Azure Databricks portal. Which of the following pricing tiers can you select?

• Standard

• Premium

• Enterprise

You have an Azure Synapse Analytics workspace. On a daily basis, you need to load 1 million CSV files from ADLS Gen 2 to the staging table.

Which type of distribution will minimize the time of loading.

• Hash

• Round robin

• Replicated