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

September 1, 2024No CommentsREAD MORE +

What should you include in the solution?

HOTSPOT You need to design a data ingestion and storage solution for the Twitter feeds. The solution must meet the customer sentiment analytics requirements. What should you include in the solution? To answer, select the appropriate options in the answer area. NOTE: Each correct selection b worth one point. View...

September 1, 2024No CommentsREAD 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....

September 1, 2024No CommentsREAD MORE +

Which type of trigger should you use?

You need to schedule an Azure Data Factory pipeline to execute when a new file arrives in an Azure Data Lake Storage Gen2 container. Which type of trigger should you use?A . on-demandB . tumbling windowC . scheduleD . storage eventView AnswerAnswer: D Explanation: Event-driven architecture (EDA) is a common...

August 31, 2024No CommentsREAD MORE +

What should you include in the solution?

You have an Azure Synapse Analystics dedicated SQL pool that contains a table named Contacts. Contacts contains a column named Phone. You need to ensure that users in a specific role only see the last four digits of a phone number when querying the Phone column. What should you include...

August 31, 2024No CommentsREAD MORE +

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

What should you do to improve high availability of the real-time data processing solution?A . Deploy identical Azure Stream Analytics jobs to paired regions in Azure.B . Deploy a High Concurrency Databricks cluster.C . Deploy an Azure Stream Analytics job and use an Azure Automation runbook to check the status...

August 31, 2024No CommentsREAD MORE +

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

What should you recommend to prevent users outside the Litware on-premises network from accessing the analytical data store?A . a server-level virtual network ruleB . a database-level virtual network ruleC . a database-level firewall IP ruleD . a server-level firewall IP ruleView AnswerAnswer: A Explanation: Virtual network rules are one...

August 31, 2024No CommentsREAD MORE +

How should you configure the new cluster?

HOTSPOT You need to implement an Azure Databricks cluster that automatically connects to Azure Data Lake Storage Gen2 by using Azure Active Directory (Azure AD) integration. How should you configure the new cluster? To answer, select the appropriate options in the answer area . NOTE: Each correct selection is worth...

August 30, 2024No CommentsREAD MORE +

Which column should you add to the table?

You have a table in an Azure Synapse Analytics dedicated SQL pool. The table was created by using the following Transact-SQL statement. You need to alter the table to meet the following requirements: ✑ Ensure that users can identify the current manager of employees. ✑ Support creating an employee reporting...

August 30, 2024No CommentsREAD MORE +

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

What should you recommend using to secure sensitive customer contact information?A . data labelsB . column-level securityC . row-level securityD . Transparent Data Encryption (TDE)View AnswerAnswer: B Explanation: Scenario: All cloud data must be encrypted at rest and in transit. Always Encrypted is a feature designed to protect sensitive data...

August 30, 2024No CommentsREAD MORE +