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 have an Azure event hub named retailhub that has 16 partitions. Transactions are posted to retailhub. Each transaction includes the transaction ID, the individual line items, and the payment details. The transaction ID is used as the partition key.
You are designing an Azure Stream Analytics job to identify potentially fraudulent transactions at a retail store. The job will use retailhub as the input. The job will output the transaction ID, the individual line items, the payment details, a fraud score, and a fraud indicator.
You plan to send the output to an Azure event hub named fraudhub.
You need to ensure that the fraud detection solution is highly scalable and processes transactions as quickly as possible.
How should you structure the output of the Stream Analytics job? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/azure/event-hubs/event-hubs-features#partitions

Comment: *

Name: *

Email: *

Verification: *

You have an enterprise data warehouse in Azure Synapse Analytics named DW1 on a server named Server1.
You need to determine the size of the transaction log file for each distribution of DW1.
What should you do?

• A.On DW1, execute a query against the sys.database_files dynamic management view.
• B.From Azure Monitor in the Azure portal, execute a query against the logs of DW1.
• C.Execute a query against the logs of DW1 by using the Get-AzOperationalInsightsSearchResult PowerShell cmdlet.
• D.On the master database, execute a query against the sys.dm_pdw_nodes_os_performance_counters dynamic management view.

Comment: *

Name: *

Email: *

Verification: *

You have an Azure Storage account and a data warehouse in Azure Synapse Analytics in the UK South region.
You need to copy blob data from the storage account to the data warehouse by using Azure Data Factory. The solution must meet the following requirements:
* Ensure that the data remains in the UK South region at all times.
* Minimize administrative effort.
Which type of integration runtime should you use?

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

Correct Answer: A

Explanation

Reference:
https://docs.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime

Comment: *

Name: *

Email: *

Verification: *

You have two fact tables named Flight and Weather. Queries targeting the tables will be based on the join between the following columns.

You need to recommend a solution that maximum query performance.
What should you include in the recommendation?

• A.In each table, create a column as a composite of the other two columns in the table.
• B.In the tables, use a hash distribution of ArriveAirPortID and AirportID.
• C.In each table, create an IDENTITY column.
• D.In the tables, use a hash distribution of ArriveDateTime and ReportDateTime.

Comment: *

Name: *

Email: *

Verification: *