- All Exams Instant Download
Which type of library and workspace should you implement?
HOTSPOT You need to collect application metrics, streaming query events, and application log messages for an Azure Databrick cluster. Which type of library and workspace should you implement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: You...
How should you configure the copy activity?
HOTSPOT You have two Azure Storage accounts named Storage1 and Storage2. Each account holds one container and has the hierarchical namespace enabled. The system has files that contain data stored in the Apache Parquet format. You need to copy folders and files from Storage1 to Storage2 by using a Data...
What should you do?
Topic 3, Mix Questions 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...
Which type of file should you use?
You have an Azure subscription that contains an Azure Blob Storage account named storage1 and an Azure Synapse Analytics dedicated SQL pool named Pool1. You need to store data in storage1. The data will be read by Pool1. The solution must meet the following requirements: ✑ Enable Pool1 to skip...
What do the query results include?
You are performing exploratory analysis of the bus fare data in an Azure Data Lake Storage Gen2 account by using an Azure Synapse Analytics serverless SQL pool. You execute the Transact-SQL query shown in the following exhibit. What do the query results include?A . Only CSV files in the tripdata_2020...
What should you use?
You have an Azure Synapse Analytics dedicated SQL pool mat contains a table named dbo.Users. You need to prevent a group of users from reading user email addresses from dbo.Users. What should you use?A . row-level security B. column-level security C. Dynamic data masking D. Transparent Data Encryption (TDDView AnswerAnswer:...
Which technologies should you use?
HOTSPOT A company plans to use Platform-as-a-Service (PaaS) to create the new data pipeline process. The process must meet the following requirements: Ingest: ✑ Access multiple data sources. ✑ Provide the ability to orchestrate workflow. ✑ Provide the capability to run SQL Server Integration Services packages. Store: ✑ Optimize storage...
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:
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 rule B. a database-level virtual network rule C. a database-level firewall IP rule D. a server-level firewall IP ruleView AnswerAnswer: A Explanation: Virtual network rules are one...
How should you configure the Data Factory copy activity?
HOTSPOT You use Azure Data Factory to prepare data to be queried by Azure Synapse Analytics serverless SQL pools. Files are initially ingested into an Azure Data Lake Storage Gen2 account as 10 small JSON files. Each file contains the same data attributes and data from a subsidiary of your...
