What should you do to improve high availability of the real-time data processing solution?

Deploy identical Azure Stream Analytics jobs to paired regions in Azure.

Deploy a High Concurrency Databricks cluster.

Deploy an Azure Stream Analytics job and use an Azure Automation runbook to check the status of the job and to start the job if it stops.

Set Data Lake Storage to use geo-redundant storage (GRS).

Deploy identical Azure Stream Analytics jobs to paired regions in Azure.

What should you recommend to prevent users outside the Litware on-premises network from accessing the analytical data store?

a server-level virtual network rule

a database-level virtual network rule

a server-level firewall IP rule

a database-level firewall IP rule

What should you recommend using to secure sensitive customer contact information?

Transparent Data Encryption (TDE)

You need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements. What should you create?

a table that has an IDENTITY property

a system-versioned temporal table

a table that has a FOREIGN KEY constraint

You have an Azure subscription that contains a Microsoft Purview account named MP1, an Azure data factory named DF1, and a storage account named storage. MP1 is configured 10 scan storage1. DF1 is connected to MP1 and contains 3 dataset named DS1. DS1 references 2 file in storage.In DF1, you plan to create a pipeline that will process data from DS1.You need to review the schema and lineage information in MP1 for the data referenced by DS1.Which two features can you use to locate the information? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point.

the search bar in Azure Data Factory Studio

the search bar in the Microsoft Purview governance portal

the Storage browser of storage1 in the Azure portal

the search bar in the Azure portal

the search bar in Azure Data Factory Studio

the search bar in the Microsoft Purview governance portal

You have an Azure Synapse Analytics Apache Spark pool named Pool1. You plan to load JSON files from an Azure Data Lake Storage Gen2 container into the tables in Pool1. The structure and data types vary by file. You need to load the files into the tables. The solution must maintain the source data types. What should you do?

Use a Get Metadata activity in Azure Data Factory.

Use a Conditional Split transformation in an Azure Synapse data flow.

Use a Get Metadata activity in Azure Data Factory.

Load the data by using the OPENROWSET Transact-SQL command in an Azure Synapse Analytics serverless SQL pool.

Load the data by using PySpark.

You have an Azure Databricks workspace named workspace1 in the Standard pricing tier. Workspace1 contains an allpurpose cluster named cluster1. You need to reduce the time it takes for cluster1 to start and scale up. The solution must minimize costs. What should you do first?

Configure a global init script for workspace1.

Create a cluster policy in workspace1.

Upgrade workspace1 to the Premium pricing tier.

You use Azure Stream Analytics to receive Twitter data from Azure Event Hubs and to output the data to an Azure Blob storage account. You need to output the count of tweets during the last five minutes every five minutes. Each tweet must only be counted once. Which windowing function should you use?

a five-minute Hopping window that has a one-minute hop

You have an enterprise data warehouse in Azure Synapse Analytics named DW1 on a server named Server1. You need to determine the size of the transaction log file for each distribution of DW1. What should you do?

On DW1, execute a query against the sys.database_files dynamic management view.

From Azure Monitor in the Azure portal, execute a query against the logs of DW1.

Execute a query against the logs of DW1 by using theGet-AzOperationalInsightsSearchResult PowerShell cmdlet.

On the master database, execute a query against the sys.dm_pdw_nodes_os_performance_counters dynamic management view.

You have an activity in an Azure Data Factory pipeline. The activity calls a stored procedure in a data warehouse in Azure Synapse Analytics and runs daily.You need to verify the duration of the activity when it ran last. What should you use?

Activity log in Azure Synapse Analytics

the sys.dm_pdw_wait_stats data management view in Azure Synapse Analytics

an Azure Resource Manager template

Microsoft DP-203 Practice Test 5 - Free Online Exam Prep & Questions

Question 1 / 40

HOTSPOT

You are building an Azure Stream Analytics job to retrieve game data.

You need to ensure that the job returns the highest scoring record for each five-minute time interval of each game.

How should you complete the Stream Analytics query? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Microsoft DP-203 image Question 1 5009289 10022024015849000

Correct answer:

Microsoft DP-203 image answer Question 1 5009289 10022024015849000

Comment (0)

Explanation:

Box 1: TopOne OVER(PARTITION BY Game ORDER BY Score Desc)

TopOne returns the top-rank record, where rank defines the ranking position of the event in the window according to the specified ordering. Ordering/ranking is based on event columns and can be specified in ORDER BY clause.

Box 2: Hopping(minute,5)

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 and be emitted more often than the window size. Events can belong to more than one Hopping window result set. To make a Hopping window the same as a Tumbling window, specify the hop size to be the same as the window size.

Microsoft DP-203 image Question 61 explanation 89582 10022024015849000000