What should you do first?

You have two Azure Data Factory instances named ADFdev and ADFprod. ADFdev connects to an Azure DevOps Git repository. You publish changes from the main branch of the Git repository to ADFdev. You need to deploy the artifacts from ADFdev to ADFprod. What should you do first?A . From ADFdev,...

March 30, 2025 No Comments READ MORE +

What should you recommend for each report?

HOTSPOT You are planning the deployment of Azure Data Lake Storage Gen2. You have the following two reports that will access the data lake: ✑ Report1: Reads three columns from a file that contains 50 columns. ✑ Report2: Queries a single record based on a timestamp. You need to recommend...

March 27, 2025 No Comments READ MORE +

Which Transact-SQL commands should you use?

HOTSPOT You have an Azure subscription that contains the following resources: An Azure Active Directory (Azure AD) tenant that contains a security group named Group1 An Azure Synapse Analytics SQL pool named Pool1 You need to control the access of Group1 to specific columns and rows in a table in...

March 27, 2025 No Comments READ MORE +

Which windowing function should you use for each requirement?

HOTSPOT You are implementing Azure Stream Analytics windowing functions. Which windowing function should you use for each requirement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer:

March 27, 2025 No Comments READ MORE +

Which three Transaction-SQL DDL commands should you run in sequence?

Topic 1, Contoso Case Study Transactional Date Contoso has three years of customer, transactional, operation, sourcing, and supplier data comprised of 10 billion records stored across multiple on-premises Microsoft SQL Server servers. The SQL server instances contain data from various operational systems. The data is loaded into the instances by...

March 26, 2025 No Comments READ MORE +

Which Azure Storage functionality should you include in the solution?

You need to design a data retention solution for the Twitter teed data records. The solution must meet the customer sentiment analytics requirements. Which Azure Storage functionality should you include in the solution?A . time-based retentionB . change feedC . soft deleteD . Iifecycle managementView AnswerAnswer: C

March 24, 2025 No Comments READ MORE +

Which three actions should you perform from Visual Studio on sequence?

DRAG DROP You have an Azure Stream Analytics job that is a Stream Analytics project solution in Microsoft Visual Studio. The job accepts data generated by IoT devices in the JSON format. You need to modify the job to accept data generated by the IoT devices in the Protobuf format....

March 22, 2025 No Comments READ MORE +

Does this meet the goal?

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...

March 21, 2025 No Comments READ MORE +

What should you include in the solution?

You are designing an Azure Synapse Analytics dedicated SQL pool. You need to ensure that you can audit access to Personally Identifiable information (PII). What should you include in the solution?A . dynamic data maskingB . row-level security (RLS)C . sensitivity classificationsD . column-level securityView AnswerAnswer: C Explanation: Data Discovery...

March 21, 2025 No Comments READ MORE +

Which storage tier should you use for each time frame?

HOTSPOT You are designing an application that will store petabytes of medical imaging data When the data is first created, the data will be accessed frequently during the first week. After one month, the data must be accessible within 30 seconds, but files will be accessed infrequently. After one year,...

March 20, 2025 No Comments READ MORE +