DP 203 Questions

Question 1

All Azure SQL Databases have a default rention period of how many days?

Answer 1

7 days

You can change the backup retention period to as long as 35 days. If you need to keep the backups for longer than the maximum retention period, you can modify the backup properties to add one or more long-term retention (LTR) periods to your database.

Question 2

This database allows existing SQL Server customers to lift and shift their on-premises applications to the cloud with minimal application and database changes.

Answer 2

Azure Sql Database

Question 3

What does TLS mean and what does it do?

Answer 3

Transport Layer Security (TLS) is an encryption protocol that keeps data secure when being transferred over a network.

Azure Backup uses transport layer security to protect the privacy of backup data being transferred.

Question 4

This Azure service uses server-level IP firewall rules but it does not support database-level IP Firewall rules.

Answer 4

Azure Synapse Analytics

Question 5

What feature can store full backups in Azure Blob storage with read-access geo-redundant storage for up to 10 years

Answer 5

With the long term retention (LTR)

Question 6

What distribution startegy is best?

– The table size on disk is more than 2 GB.
– The table has a frequent insert, update, and delete operations.

Answer 6

Hash Distribution table in Synapse SQL Pools

Question 7

Data factory offers what three types of Integration Runtime(IR)?

Answer 7

Azure, Self Hosted and Azure-SSIS

Question 8

Does Azure SQL database perform the automated backup?

Answer 8

Yes

Question 9

How does the Dynamic Data Masking (DDM) limit the exposure of sensitive data?

Answer 9

Masking it to non-privileged users

Question 10

Indexing is helpful for reading tables quickly. For tables up to 100 million rows, what is the best indexing type ?

Answer 10

clustered index

Question 11

Members of the db……………… fixed database role can add or remove access to the database for Windows logins, Windows groups, and SQL Server logins.

Answer 11

db_accessadmin

Question 12

Members of the db…………… fixed database role can back up the database.

Answer 12

db_backupoperator

Question 13

Members of the db …………… fixed database role can perform all configuration and maintenance activities on the database, and can also drop the database in SQL Server

Answer 13

db_owner

db_owner is one of the fixed roles which exists in all databases. This role can perform all configuration and maintenance activities on the database, and can also drop the database in SQL Server.

Question 14

You are building a pipeline for processing big data on Microsoft Azure. The pipeline must meet the following requirements: – Use streaming capabilities – Provide the ability to code in SQL, Python, Scala and R – Workspace integration with Git repository – Use in-memory data processing engine to speed up ETL and machine learning operations. What should you use?

A. Azure Stream Analytics
B. Azure Synapse
C. HDInsight Hadoop Cluster
D.HDInsight Spark Cluster
E. HDInsight Storm Cluster

Answer 14

D.HDInsight Spark Cluster

Question 15

You are considering to deploy an Azure Databricks interactive cluster. You need to ensure that the cluster configuration is kept, even if the cluster is inactive for more than 30 days.
How would you achieve this goal?

A. Terminate the cluster manually
B. Clone the cluster after termination
C. Pin the cluster
D. Start the cluster manually

Answer 15

C. Pin the cluster

Question 16

You are designing a big data analytics solution that will use azure stream analytics to analyse real-time twitter data with hashtag #cloud. Which windowing function would you recommend to be used in your query, if you need to give every 5 seconds the count of tweets over the last 10 seconds?

A. Session window
B. Sliding window
C. Tumbling window
D. Hopping window

Answer 16

D. Hopping window

Hopping window functions hop forward in time by a fixed period. It may be easy to think of them as Tumbling windows that can overlap, so events can belong to more than one Hopping window result set.

Question 17

You are designing a big data engineering solution on Microsoft Azure. Some of the key requirements that your solution needs to meet are the following:
– support of streaming data processing
– capability to assign fine-grained user permissions for notebooks, clusters, jobs, and data using RBAC
– integration with Power BI
– fully managed Spark clusters in the cloud
Which Azure service would you recommend?

A. Azure Data Lake Storage Gen2
B. Azure Function
C. Azure Databricks
D. Azure Stream Analytics

Answer 17

C. Azure Databricks

Question 18

You are designing a big data solution for leading healthcare provider that will use Azure Synapse. A health care provider allows only doctors and nurses to have access to sensitive medical records while not allowing members of the billing department to view this data.
What would you recommend?

A. Row-level security
B. Dynamic Data Masking
C. Column-level security
D. TLS

Answer 18

C. Column-level security

Column-Level Security allows customers to control access to table columns based on the user’s execution context or group membership.
Incorrect answers: Row-Level Security enables you to use group membership or execution context to control access to rows in a database table. Dynamic data masking limits sensitive data exposure by masking it to non-privileged users but doesn’t limit the access to the date. Transport Layer Security (TLS) is used for encryption of data in transit.

Question 19

You are designing a big data solution that will use Azure SQL Data Warehouse. You expect to load millions of rows of data into the data warehouse each day. You must ensure that staging tables are optimized for data loading. You need to design the staging tables.
What type of distributed tables should you recommend?

A. Hash-distributed
B. Round-Robin
C. None
D. Replicated table

Answer 19

B. Round-Robin
For data loading, the preferable option is to use a Round-robin distributed table.

Question 20

You are designing a data engineering solution for data stream processing. You need to recommend a solution for data ingestion, in order to meet the following requirements:
– Ingest millions of events per second
– Easily scale from streaming megabytes of data to terabytes while keeping control over when and how much to scale
– Integrate with Azure Functions
– Natively connect with Stream Analytics to build an end-to-end serverless streaming solution.

What would you recommend?

A. Azure Cosmos DB
B. Apache Spark
C. Azure Synapse Analytics
D. Azure Event Hubs

Answer 20

D. Azure Event Hubs
Azure Event Hubs is a data ingestion service on Azure that fits the best into the requirements.

Question 21

This Azure Service is an enterprise analytics service that accelerates time to insight across data warehouses and big data systems. It brings together the best of SQL technologies used in enterprise data warehousing, Spark technologies used for big data, Data Explorer for log and time series analytics, Pipelines for data integration and ETL/ELT, and deep integration with other Azure services such as Power BI, CosmosDB, and AzureML.

A. Azure Synapse
B. Azure DataBricks
C. Azure SQL DB
D.Azure Data Explorer

Answer 21

A. Azure Synapse