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 Questions 161-200

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.

Become a Premium Member for full access

Unlock Premium Member

Microsoft DP-203 Practice Test 5

Question

Microsoft DP-203 Practice Tests

Practice Tests