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)

 If you would like to support me in providing this content, I would be grateful! 

 

Azure Solutions Architect Expert

Yorum Bırakın

Bu site, istenmeyenleri azaltmak için Akismet kullanıyor. Yorum verilerinizin nasıl işlendiği hakkında daha fazla bilgi edinin.