DP-203 Exam Questions And Answers (P4)

Welcome to your DP-203 Exam Questions and Answers (Part 4)

Please, provide your Full Name and Email to get started!

Please, enter your Full Name

Please, enter your Email

1. ........................... provides you with personalized messages that provide information on best practices to optimize the setup of your Azure services.

Azure Assistant

Azure Assessment

Azure Advisor

2. ............... tables are ideal for small star-schema dimension tables.

Hash-distributed

Round-robin

Replicated

3. The Stream Analytics windowing functions are used in .............. clause.

WHERE

ORDER BY

USING

Group By

4. Which Integration runtime in Azure Data Factory can be provisioned in either public network or private network.

Azure integration runtime

Azure-SSIS integration runtime

Self-hosted integration runtime

5. Which Index Type offers the highest level of data compression?

Heap

ColumnStore

Non-clustered index

Rowstore

6. ............. is an open-source platform that's used to compose data pipelines. It offers message queue functionality, which allows users to publish or subscribe to real-time data streams.

Kafka

HBase

Storm

7. What Transact-SQL function is used to perform a HyperLogLog function?

COUNT_DISTINCT_APPROX

APPROX_DISTINCT_COUNT

APPROX_COUNT_DISTINCT

DISTINCT_COUNT_APPROX

8. Azure HDInsight is a high-cost cloud solution that provides technologies to help you ingest, process, and analyze big data.

True

False

9. A company manages several on-premises Microsoft SQL Server databases. You need to migrate the databases to Microsoft Azure by using a backup process of Microsoft SQL Server. Which data technology should you use?

Azure SQL Database elastic pools

Azure SQL Database Hyperscale

Azure SQL Data Warehouse

Azure SQL Database Managed Instance

10. In what language can the Azure Synapse Apache Spark to Synapse SQL connector be used?

Scala

SQL

Python

11. ............. is a distributed real-time streaming analytics solution.

HBase

Storm

Kafka

12. Which ALTER DATABASE statement parameter allows a dedicated SQL pool to scale?

Alert

Change

Modify

Scale

13. In Azure Blob Storage, Data in the archive access tier is stored online.

False

True

14. .............................. provide a programmatic experience for monitoring the Azure Synapse Analytics SQL pool activity by using the Transact-SQL language

Dynamic SQL Views

Static Management Views

Dynamic Management Views

15. ............. is a NoSQL database built on Hadoop. It's commonly used for search engines, and offers automatic failover.

Kafka

HBase

Storm

16. In Azure Synapse Analytics SQL pools, All logins to your data warehouse are logged to

sys.dm_pdw_exec_sessions

sys.dm_pdw_dms_workers

sys.dm_pdw_exec_requests

17. To make a Hopping window the same as a Tumbling window, specify ...................

The hop size to be smaller than the window size.

The hop size to be not equal the window size.

The hop size to be the same as the window size.

The hop size to be greater than the window size.

18. Stream Analytics supports Azure Blob storage and Azure SQL Database as the storage layer for Reference Data

False

True

19. In Azure Blob Storage, the ...................... is optimized for storing data that is rarely accessed and stored for at least 180 days with flexible latency requirements, on the order of hours.

Hot Tier

Cool Tier

Archive Tier

20. You are the data engineer for your company. An application uses a NoSQL database to store data. The database uses the key-value and wide-column NoSQL database type. Developers need to access data in the database using an API. You need to determine which API to use for the database model and type?

Table API

MongoDB API

Gremlin API

Cassandra API

21. Which language can be used to define Spark job definitions?

T-SQL

Scala

Python

BySpark

22. ...................... is a cross-platform tool to connect and query on-premise and cloud data platforms on windows, macOS, and Linux.

SQL Management Studio

Azure Data Studio

DAX Studio

23. CETAS stands for

Create External Tables As Select

Create External Tables As Insert

Create External Tables As Sort

24. In Azure Blob Storage, the ...................... is optimized for storing data that is accessed frequently

Hot Tier

Archive Tier

Cool Tier

25. Dynamic Management Views (DMV) only contains ............ rows of data.

5,000

10,000

20,000

15,000

26. Only CLUSTERED COLUMNSTORE INDEX is supported by materialized view.

True

False

27. In this example, if LOCATION='/webdata/', a serverless SQL pool query, will return rows from
Recursive data for external tables

mydata.txt, mydata2.txt and mydata3.txt

mydata.txt

mydata.txt and mydata2.txt

mydata.txt and _hidden.txt

28. ..................... is a finite data set that is static or slowly changing in nature, used to perform a lookup or to augment your data streams.

Reference data

Analytics data

Stream data

29. In Azure Blob Storage, the ...................... is optimized for storing data that is infrequently accessed and stored for at least 30 days.

Archive Tier

Cool Tier

Hot Tier

30. In Azure Synapse Analytics SQL pools, All queries executed on SQL pool are logged to

sys.dm_pdw_exec_requests

sys.dm_pdw_exec_sessions

sys.dm_pwd_exec_connections

31. Azure Advisor recommendations are not free

True

False

32. White space in column name is supported for Parquet files

True

False

33. Which Dynamic Management View allows you to monitor data movement in the dedicated SQL pool

sys.dm_pdw_exec_requests

DBCC PDW_SHOWEXECUTIONPLAN

sys.dm_pdw_dms_workers

34. How do column statistics improve query performance?

By keeping track of which columns are being queried.

By keeping track of how much data exists between ranges in columns.

By caching column values for queries.

35. Azure Advisor recommendations are checked every ............. hours

36. APPROX_COUNT_DISTINCT returns a result with a ........... accuracy of true cardinality on average.

10%

37. Which workload management feature influences the order in which a request gets access to resources?

Workload importance

Workload isolation

Workload classification

38. You need to output files from Azure Data Factory. Which file format should you use for columnar format

TXT

GIZP

Parquet

Avro

39. What Transact-SQL function extract a scalar value from a JSON string?

JSON_EXTRACT

ISJSON

JSON_VALUE

JSON_QUERY

40. Azure Data Factory supports the following file formats:

Parquet

GIZP

Avro

TXT

Binary

41. Integration runtimes can be created in the Azure Data Factory UX via the ........................

Management hub

Monitor hub

Develop hub

42. You have an Azure Storage account and a data warehouse in Azure Synapse Analytics in the UK South region. You need to copy blob data from the storage account to the data warehouse by using Azure Data Factory. The solution must ensure that the data remains in the UK South region at all times, and minimize administrative effort. Which type of integration runtime should you use?

Self-hosted integration runtime

Azure-SSIS integration runtime

Azure integration runtime

43. You have an Azure Stream Analytics job that receives clickstream data from an Azure event hub. You need to define a query in the Stream Analytics job. The query must count the number of clicks within each 10-second window based on the country of a visitor, and ensure that each click is NOT counted more than once. How should you define the Query?

SELECT Country, Count(*) AS Count FROM ClickStream TIMESTAMP BY CreatedAt GROUP BY Country, TumblingWindow(second, 10)

SELECT Country, Avg(*) AS Average FROM ClickStream TIMESTAMP BY CreatedAt GROUP BY Country, SlidingWindow(second, 10)

SELECT Country, Avg(*) AS Average FROM ClickStream TIMESTAMP BY CreatedAt GROUP BY Country, HoppingWindow(second, 10, 2)

SELECT Country, Count(*) AS Count FROM ClickStream TIMESTAMP BY CreatedAt GROUP BY Country, SessionWindow(second, 5, 10)

44. Which Integration runtime in Azure Data Factory is capable of Running copy activity between a cloud data stores and a data store in private network.

Self-hosted integration runtime

Azure-SSIS integration runtime

Azure integration runtime

12 out of 11

Are you sure, you would like to submit your responses on DP-203 Exam Questions and Answers (Part 4) and view your results?