Question: What type of object in Azure Synapse Analytics pipelines is an executable task?
Select only one answer.
+Activity
Dataset
Linked Service
Integration Runtime
Question: You plan to implement an Azure-SQL Server Integration Services (SSIS) Integration Runtime (IR) in Azure Synapse Analytics. SSIS packages will be deployed to an SSIS catalog in a Project Deployment model.
Which Azure service should you provision to host the SSIS catalog?
Select only one answer.
Azure Cosmos DB
Azure Database for MySQL
+Azure SQL Database
Azure Synapse Analytics
Question: What type of object in an Azure Synapse Analytics pipeline is used to read data from an external Azure SQL database?
Select only one answer.
Dataset
External Data Source
+External Table
Linked Service
Question: When using the Data Flow Debug feature in Azure Synapse Analytics pipelines, each debug session that is started from the user interface is considered a new session with its own Spark cluster.
Select Yes if the statement is true. Otherwise, select No
Select only one answer.
Yes
+No
Question: User In Azure Synapse Studio, the same language must be used in all cells of an Apache Spark notebook.
Select Yes if the statement is true. Otherwise, select No.
Select only one answer.
Yes
+No
Question: An Azure Synapse Studio notebook can load data from an Azure Synapse Analytics dedicated SQL pool.
Select Yes if the statement is true. Otherwise, select No.
Select only one answer.
+Yes
No
Question: Cells in an Azure Synapse Studio notebook can be collapsed and expanded.
Select Yes if the statement is true. Otherwise, select No.
Select only one answer.
+Yes
No
Question: In an Azure Synapse Studio notebook, cells must be executed individually.
Select Yes if the statement is true. Otherwise, select No.
Select only one answer.
Yes
+No
Question: If you select an Apache Spark pool instance, you can see the status in a notebook from Azure Synapse Studio.
Select Yes if the statement is true. Otherwise, select No.
Select only one answer.
+Yes
No
Question:You are writing a T-SQL query to retrieve the results from a dataset that contains the following three columns:
Population
City
Country
You need to rank each city by population in descending order.
What should you use in the query?
Select only one answer.
a group by clause
+a windowing function
an aggregation
an inner join
Question: You plan to query an Azure Cosmos DB for NoSQL container from an Azure Synapse Analytics serverless SQL pool by using T-SQL. The query uses the WITH clause to specify the path to property values that use the full fidelity schema.
What should you include in the WITH clause?
Select only one answer.
a column name and a data type
an array
+an explicit type conversion
Question:User In T-SQL, the results of an OPENJSON call can be used as the input for another OPENJSON call.
Select Yes if the statement is true. Otherwise, select No.
Select only one answer.
+Yes
No
Question: To query an Azure Cosmos DB database from an Azure Synapse Analytics serverless SQL pool, you must use the Azure Cosmos DB for NoSQL API.
Select Yes if the statement is true. Otherwise, select No.
Select only one answer.
Yes
+No
Question: When using the OPENJSON function in T-SQL, the WITH clause can be used to specify a column alias.
Select Yes if the statement is true. Otherwise, select No.
Select only one answer.
Yes
+No
Question: You plan to execute the CREATE TABLE AS statement in Azure Synapse Analytics T-SQL.
You notice an existing table that has the same name.
What occurs when you execute the statement?
Select only one answer.
An empty table that uses the new table schema replaces the existing table.
The existing table definition is overwritten by the new definition. All columns with matching data types and names are preserved.
The statement fails.
Select only one answer.
Degenerate Dimensions
Dimensions
+Facts
Junk Dimensions
Question: You have a table that is processed as a slowly changing dimension. The columns use either type 0, type 1, or type 2 processing.
What is the result of a change in a column that uses type 2 processing?
Select only one answer.
+A new row that has a new surrogate key and reuses the business key is created.
A new row that reuses the surrogate key and that has a new business key is created.
An error is raised.
The existing row is updated.
Question: You rebuild all indexes on a data warehouse table.
What is the impact of the rebuild on the statistics associated to the table?
Select only one answer.
all statistics are rebuilt
multi-column statistics only are rebuilt
+statistics associated to the indexes are rebuilt
statistics remain unchanged
Question: In Azure Synapse Analytics, processing resources are allocated to units of compute scale called elastic pools.
Select Yes if the statement is true. Otherwise, select No.
Select only one answer.
Yes
+No
Question: Apache Spark pools in Azure Synapse Analytics can be configured to pause automatically after a predefined idle time.
Select Yes if the statement is true. Otherwise, select No.
Select only one answer.
Yes
+No
Question:Which setting should you configure to enable auto-pause settings for an Apache Spark pool?
Select only one answer.
+Number of minutes idle
Number of seconds idle
The node draining behavior
The number of nodes to pause
Question: Dynamic data masking policies can be applied to users that have administrative privileges for an Azure Synapse Analytics dedicated SQL pool.
Select Yes if the statement is true. Otherwise, select No.
Select only one answer.
Yes
+No
Question: Azure Synapse pipelines can use a managed identity to connect to an Azure Storage account.
Select Yes if the statement is true. Otherwise, select No.
Select only one answer.
+Yes
No
Question: In dynamic data masking in Azure Synapse Analytics, the masking function defines the designated fields to be masked.
Select Yes if the statement is true. Otherwise, select No.
Select only one answer.
Yes
+No
Question: You need to protect Azure Synapse Analytics against threats of malicious offline activity.
What should you enable?
Select only one answer.
a managed identity
Azure Key Vault
column-level security
+Transparent Data Encryption (TDE)
