- All Exams Instant Download
Which component of Azure Data Factory enables you to define a sequence of activities including for each iterators?
Which component of Azure Data Factory enables you to define a sequence of activities including for each iterators?A . control flowB . linked servicesC . datasetsD . the integration runtimeView AnswerAnswer: A
Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy
DRAG DROP Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy. To answer, drag the appropriate term from the column on the left to its level on the right. Each term may be used once, more than once, or not at all. NOTE: Each correct...
What is the primary purpose of a data warehouse?
What is the primary purpose of a data warehouse?A . to provide answers to complex queries that rely on data from multiple sourcesB . to provide transformation services between source and target data storesC . to provide read-only storage of relational and non-relational historical dataD . to provide storage for...
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point
HOTSPOT For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. View AnswerAnswer:
When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?
When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?A . multi-master replicationB . Availability ZonesC . automatic failoverD . the strong consistency levelView AnswerAnswer: B Explanation: With Availability Zone (AZ) support, Azure Cosmos DB will ensure replicas are placed across multiple zones within a...
match the Azure data factory components to the appropriate descriptions
DRAG DROP match the Azure data factory components to the appropriate descriptions. To answer, drag the appropriate component from the column on the left to its description on the right. Each component may be used once, more than once, or not at all. NOTE: Each correct match is worth one...
To complete the sentence, select the appropriate option in the answer area
HOTSPOT To complete the sentence, select the appropriate option in the answer area. View AnswerAnswer: Explanation: Text Description automatically generated with medium confidence With ELT, the data store used to perform the transformation is the same data store where the data is ultimately consumed.
Which statement is an example of Data Manipulation Language (DML)?
Which statement is an example of Data Manipulation Language (DML)?A . INSERTB . DISABLEC . ALTERD . DROPView AnswerAnswer: A Explanation: Data Manipulation Language (DML) statements: ✑ DELETE ✑ INSERT ✑ UPDATE Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-tsql-statements
Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?
You have an inventory management database that contains the following table. Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?A . INSERTB . MERGEC . UPDATED . CREATEView AnswerAnswer: C Explanation: Reference: https://docs.microsoft.com/en-us/sql/t-sql/queries/update-transact-sql?view=sql-server-ver15
To complete the sentence, select the appropriate option in the answer area
HOTSPOT To complete the sentence, select the appropriate option in the answer area. View AnswerAnswer:
