Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?
A . consistency
B. durability
C. isolation
D. atomicity
Answer: B
Which three requirements must be met to query the table from the internet?
You need to query a table named Products in an Azure SQL database.
Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. (Choose three.)
A . You must be assigned the Reader role for the resource group that contains the database.
B. You must have SELECT access to the Products table.
C. You must have a user in the database.
D. You must be assigned the Contributor role for the resource group that contains the database.
E. Your IP address must be allowed to connect to the database.
Answer: B,C,E
Explanation:
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/getting-started-with-database-engine-permissions?view=sql-server-ver15
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.
Answer: 
Explanation:
Box 1: No
A pipeline is a logical grouping of activities that together perform a task.
Box 2: Yes
You can construct pipeline hierarchies with data factory.
Box 3: Yes
A pipeline is a logical grouping of activities that together perform a task.
CORRECT TEXT
CORRECT TEXT
Select the answer the correctly completes the sentence.
Answer: Answer below as:
What should you use?
You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database.
You need to embed documents and query results into a SQL notebook.
What should you use?
A . Microsoft SQL Server Management Studio (SSMS)
B. Azure Data Studio
C. Azure CLI
D. Azure PowerShell
Answer: B
Explanation:
Reference: https://www.mssqltips.com/sqlservertip/5997/create-sql-server-notebooks-in-azure-data-studio/
Which Azure Data Factory component provides the compute environment for activities?
Which Azure Data Factory component provides the compute environment for activities?
A . a linked service
B. an integration runtime
C. a control flow
D. a pipeline
Answer: B
Explanation:
The Integration Runtime (IR) is the compute infrastructure used by Azure Data Factory to provide the following data integration capabilities across different network environments:
✑ Data Flow
✑ Data movement
✑ Activity dispatch
✑ SSIS package execution
Reference: https://docs.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime
Which statement is an example of Data Definition Language (DDL)?
Which statement is an example of Data Definition Language (DDL)?
A . SELECT
B. JOIN
C. MERGE
D. CREATE
Answer: D
Explanation:
Reference: https://www.geeksforgeeks.org/difference-between-ddl-and-dml-in-dbms/
Match the Azure services to appropriate requirements
DRAG DROP
Match the Azure services to appropriate requirements.
To answer, drag the appropriate services from the column on the left to its requirement on the right. Each service may be used once. more than once, or not at all. NOTE: Each correct match is worth one point.
Answer: 
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.
Answer: 
Explanation:
Box 1: Yes
Azure Databricks can consume data from SQL Databases using JDBC and from SQL Databases using the Apache Spark connector.
The Apache Spark connector for Azure SQL Database and SQL Server enables these databases to act as input data sources and output data sinks for Apache Spark jobs.
Box 2: Yes
You can stream data into Azure Databricks using Event Hubs.
Box 3: Yes
You can run Spark jobs with data stored in Azure Cosmos DB using the Cosmos DB Spark connector. Cosmos can be used for batch and stream processing, and as a serving layer for low latency access.
You can use the connector with Azure Databricks or Azure HDInsight, which provide managed Spark clusters on Azure.
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.
Answer: 
Explanation:
Text, table
Description automatically generated
Generally speaking, data analytics comes in four types:
✑ Descriptive, to answer the question: What’s happening?
✑ Diagnostic, to answer the question: Why’s happening?
✑ Predictive, to answer the question: What will happen?
✑ Prescriptive, to answer the question: What actions should we take?
Company name
Description automatically generated