The storage account container view is shown in the Refdata exhibit. (Click the Refdata tab.) You need to configure the Stream Analytics job to pick up the new reference dat a. What should you configure? To answer, select the appropriate options in the answer area NOTE: Each correct selection is worth one point.

Correct Answer:

Answer as below

Comment: *

Name: *

Email: *

Verification: *

You have files and folders in Azure Data Lake Storage Gen2 for an Azure Synapse workspace as shown in the following exhibit.

You create an external table named ExtTable that has LOCATION='/topfolder/'.
When you query ExtTable by using an Azure Synapse Analytics serverless SQL pool, which files are returned?

• A.File2.csv and File3.csv only
• B.File1.csv and File4.csv only
• C.File1.csv, File2.csv, File3.csv, and File4.csv
• D.File1.csv only

Comment: *

Name: *

Email: *

Verification: *

You need to integrate the on-premises data sources and Azure Synapse Analytics. The solution must meet the data integration requirements.
Which type of integration runtime should you use?

• A.Azure integration runtime
• B.Azure-SSIS integration runtime
• C.self-hosted integration runtime

Comment: *

Name: *

Email: *

Verification: *

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

• A.data labels
• B.column-level security
• C.row-level security
• D.Transparent Data Encryption (TDE)

Comment: *

Name: *

Email: *

Verification: *

You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and a database named DB1. DB1 contains a fact table named Table1.
You need to identify the extent of the data skew in Table1.
What should you do in Synapse Studio?

• A.Connect to the built-in pool and query sysdm_pdw_sys_info.
• B.Connect to Pool1 and run DBCC CHECKALLOC.
• C.Connect to the built-in pool and run DBCC CHECKALLOC.
• D.Connect to Pool! and query sys.dm_pdw_nodes_db_partition_stats.

Comment: *

Name: *

Email: *

Verification: *