Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You are designing an Azure Stream Analytics solution that will analyze Twitter data.You need to count the tweets in each 10-second window. The solution must ensure that each tweet is counted only once. Solution: You use a session window that uses a timeout size of 10 seconds. Does this meet the goal?
Answer(s): B
Instead use a tumbling window. Tumbling windows are a series of fixed-sized, non-overlapping and contiguous time intervals.
https://docs.microsoft.com/en-us/stream-analytics-query/tumbling-window-azure-stream-analytics
You use Azure Stream Analytics to receive data from Azure Event Hubs and to output the data to an Azure Blob Storage account.You need to output the count of records received from the last five minutes every minute. Which windowing function should you use?
Answer(s): D
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.
https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-window-functions
HOTSPOT (Drag and Drop is not supported)You configure version control for an Azure Data Factory instance as shown in the following exhibit.Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.NOTE: Each correct selection is worth one point. Hot Area:
Answer(s): A
Box 1: adf_publishThe Publish branch is the branch in your repository where publishing related ARM templates are stored and updated. By default, it's adf_publish.Box 2: / dwh_batchetl/adf_publish/contososalesNote: RepositoryName (here dwh_batchetl): Your Azure Repos code repository name. Azure Repos projects contain Git repositories to manage your source code as your project grows. You can create a new repository or use an existing repository that's already in your project.
https://docs.microsoft.com/en-us/azure/data-factory/source-control
HOTSPOT (Drag and Drop is not supported)You are designing an Azure Stream Analytics solution that receives instant messaging data from an Azure Event Hub.You need to ensure that the output from the Stream Analytics job counts the number of messages per time zone every 15 seconds.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. Hot Area:
Box 1: timestamp byBox 2: TUMBLINGWINDOWTumbling window functions are used to segment a data stream into distinct time segments and perform a function against them, such as the example below. The key differentiators of a Tumbling window are that they repeat, do not overlap, and an event cannot belong to more than one tumbling window.
HOTSPOT (Drag and Drop is not supported)You have an Azure Data Factory instance named ADF1 and two Azure Synapse Analytics workspaces named WS1 and WS2.ADF1 contains the following pipelines:-P1: Uses a copy activity to copy data from a nonpartitioned table in a dedicated SQL pool of WS1 to an Azure Data Lake Storage Gen2 account-P2: Uses a copy activity to copy data from text-delimited files in an Azure Data Lake Storage Gen2 account to a nonpartitioned table in a dedicated SQL pool of WS2You need to configure P1 and P2 to maximize parallelism and performance.Which dataset settings should you configure for the copy activity if each pipeline? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Hot Area:
Box 1: Set the Copy method to PolyBaseWhile SQL pool supports many loading methods including non-Polybase options such as BCP and SQL BulkCopy API, the fastest and most scalable way to load data is through PolyBase. PolyBase is a technology that accesses external data stored in Azure Blob storage or Azure Data Lake Store via the T-SQL language. Box 2: Set the Copy method to Bulk insertPolybase not possible for text files. Have to use Bulk insert.
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/load-data-overview
Post your Comments and Discuss Microsoft DP-203 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the DP-203 content, but please register or login to continue.