Correct Answer: C

Azure Stream Analytics on IoT Edge empowers developers to deploy near-real-time analytical intelligence closer to IoT devices so that they can unlock the full value of device- generated data. UDF are available in C# for IoT Edge jobs Azure Stream Analytics on IoT Edge runs within the Azure IoT Edge framework. Once the job is created in Stream Analytics, you can deploy and manage it using IoT Hub.

References: https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-edge

Correct Answer: BE

Synapse workspaces encryption uses existing keys or new keys generated in Azure Key Vault. A single key is used to encrypt all the data in a workspace. Synapse workspaces support RSA 2048 and 3072 byte-sized keys, and RSA-HSM keys.

The Key Vault itself needs to have purge protection enabled.

Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/security/workspaces-encryption

Correct Answer: A

Reference: https://knowledge.informatica.com/s/article/Microsoft-Azure-Data-Lake-Store-Gen2-target-file- names-not-generating-as-expected-using-create-at-runtime-option

Correct Answer: A

Call Synapse pipeline with a notebook activity. Use a Web activity to call Synapse pipeline.

Reference: https://learn.microsoft.com/en-us/azure/data-factory/solution-template-synapse-notebook

Correct Answer: A

External table type: Native. Storage authentication: Shared Access Signature(SAS), Azure Active Directory passthrough, Managed identity, Custom application Azure AD identity.

Example for CREATE EXTERNAL DATA SOURCE

The following example creates a Hadoop external data source in dedicated SQL pool for Azure Data Lake Gen2 pointing to the New York data set:

CREATE DATABASE SCOPED CREDENTIAL [ADLS_credential]

WITH IDENTITY='SHARED ACCESS SIGNATURE',

SECRET = 'sv=2018-03-28andss=bfandsrt=scoandsp=rlandst=2019-10-14T12%3A10%3A25Zandse=2061-12-31T12%3A10%3A00Zandsig=KlSU2ullCscyTS0An0nozEpo4tO5JAgGBvw%2FJX2lguw%3D'

GO

CREATE EXTERNAL DATA SOURCE AzureDataLakeStore

WITH -- Please note the abfss endpoint when your account has secure transfer enabled ( LOCATION = 'abfss://[email protected]' ,

CREDENTIAL = ADLS_credential ,

TYPE = HADOOP

) ;

Incorrect:

Not C, not D: Hadoop external tables are available in dedicated SQL pools, but they aren't available in serverless SQL pools.

Note: Depending on the type of the external data source, you can use two types of external tables:

*

Hadoop external tables that you can use to read and export data in various data formats such as CSV, Parquet, and ORC. Hadoop external tables are available in dedicated SQL pools, but they aren't available in serverless SQL pools.

*

Native external tables that you can use to read and export data in various data formats such as CSV and Parquet. Native external tables are available in serverless SQL pools, and they are in public preview in dedicated SQL pools. Writing/ exporting data using CETAS and the native external tables is available only in the serverless SQL pool, but not in the dedicated SQL pools.

Reference: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables