Knowledge Checks Modules Actual Exam
Latest Update 2024 Module(S) Knowledge
Checks Exam Update 2024 | Questions and
Correct Answers Rated A+
Which SCD type would you use to keep history of changes in
dimension members by adding a new row to the table for each
change? -ANSWER-Type 2 SCD.
When a value changes, Type 2 SCD will add a new row for the entity
with a start date, end date, and unique key which will join back to any
transactions in the fact table within the effective data range.
Which SCD type would you use to update the dimension members
without keeping track of history? -ANSWER-Type 1 SCD.
When a value changes, Type 1 SCD will update the existing record
without keeping history.
What is a supported connector for built-in parameterization? -
ANSWER-Azure Synapse Analytics
Azure Synapse Analytics is a supported connector for built-in
parameterization for Linked Services in Azure Data Factory.
What is an example of a branching activity used in control flows? -
ANSWER-The If-condition
An example of a branching activity is The If-condition activity which is
similar to an if-statement provided in programming languages.
,In which version of SQL Server was SSIS Projects introduced? -
ANSWER-SQL Server 2012.
SSIS Projects was introduced in SQL Server 2012 and is the unit of
deployment for SSIS solutions.
Which tool is used to perform an assessment of migrating SSIS
packages to Azure SQL Database services? -ANSWER-Data
Migration Assistant.
The Data Migration Assistant is used to perform an assessment of
migrating SSIS packages to Azure SQL Database services.
Which tool is used to create and deploy SQL Server Integration
Packages on an Azure-SSIS integration runtime, or for on-premises
SQL Server? -ANSWER-SQL Server Data Tools.
SQL Server Data Tools is typically used to create and deploy SQL
Server Integration Services (SSIS) packages.
Which version control software does Azure Data Factory integrate
with? -ANSWER-Git repositories.
Azure Data Factory allows you to configure a Git repository with either
Azure Repos or GitHub, and is a version control system that allows for
easier change tracking and collaboration.
Which feature commits the changes of Azure Data Factory work in a
custom branch created with the main branch in a Git repository? -
ANSWER-Pull request.
,After a developer is satisfied with their changes, they create a pull
request from their feature branch to the master or collaboration branch
to get their changes reviewed by peers.
Which feature in alerts can be used to determine how an alert is fired?
-ANSWER-Add criteria.
The add criteria feature enables you to determine how an alert is fired
Which type of analytics answers the question "What is likely to happen
in the future based on previous trends and patterns?" -ANSWER-
Predictive.
Predictive analytics "What is likely to happen in the future based on
previous trends and patterns?".
You have a requirement to occasionally prepare data for ad hoc data
exploration and analysis. Which resource model in Azure Synapse
Analytics is the most effective to use to meet this requirement? -
ANSWER-Serverless.
The serverless resource model is the ideal resource model in this
scenario as it makes use of the resources when required.
Where can you develop TSQL scripts and notebooks in Azure
Synapse Analytics? -ANSWER-Azure Synapse Studio.
Azure Synapse Studio is where you can develop TSQL scripts and
notebooks.
Which Azure Service is Azure Synapse Pipelines based on? -
ANSWER-Azure Data Factory.
, Azure Synapse Pipelines is based in the Azure Data Factory service.
What component of Azure Synapse analytics allows the different
engines to share the databases and tables between Spark pools and
SQL on-demand engine? -ANSWER-Azure Synapse shared
metadata.
The shared metadata gives the workspace SQL engines access to
databases and tables created with Spark.
Which Azure Synapse Analytics component enables you to perform
Hybrid Transactional and Analytical Processing? -ANSWER-Azure
Synapse Link.
Azure Synapse Link is the component that enables Hybrid
Transactional and Analytical Processing.
Which Azure Synapse Studio hub would you go to create Notebooks?
-ANSWER-Develop.
The Develop hub is where you manage SQL scripts, Synapse
notebooks, data flows, and Power BI reports.
In Azure Synapse Studio, where would you view the contents of the
primary data lake store? -ANSWER-In the linked tab of the Data hub.
The linked tab of the data hub is where you can view the contents of
the primary data lake store.
Which hub is where you can grant access to Synapse workspace and
resources? -ANSWER-Manage hub.
Latest Update 2024 Module(S) Knowledge
Checks Exam Update 2024 | Questions and
Correct Answers Rated A+
Which SCD type would you use to keep history of changes in
dimension members by adding a new row to the table for each
change? -ANSWER-Type 2 SCD.
When a value changes, Type 2 SCD will add a new row for the entity
with a start date, end date, and unique key which will join back to any
transactions in the fact table within the effective data range.
Which SCD type would you use to update the dimension members
without keeping track of history? -ANSWER-Type 1 SCD.
When a value changes, Type 1 SCD will update the existing record
without keeping history.
What is a supported connector for built-in parameterization? -
ANSWER-Azure Synapse Analytics
Azure Synapse Analytics is a supported connector for built-in
parameterization for Linked Services in Azure Data Factory.
What is an example of a branching activity used in control flows? -
ANSWER-The If-condition
An example of a branching activity is The If-condition activity which is
similar to an if-statement provided in programming languages.
,In which version of SQL Server was SSIS Projects introduced? -
ANSWER-SQL Server 2012.
SSIS Projects was introduced in SQL Server 2012 and is the unit of
deployment for SSIS solutions.
Which tool is used to perform an assessment of migrating SSIS
packages to Azure SQL Database services? -ANSWER-Data
Migration Assistant.
The Data Migration Assistant is used to perform an assessment of
migrating SSIS packages to Azure SQL Database services.
Which tool is used to create and deploy SQL Server Integration
Packages on an Azure-SSIS integration runtime, or for on-premises
SQL Server? -ANSWER-SQL Server Data Tools.
SQL Server Data Tools is typically used to create and deploy SQL
Server Integration Services (SSIS) packages.
Which version control software does Azure Data Factory integrate
with? -ANSWER-Git repositories.
Azure Data Factory allows you to configure a Git repository with either
Azure Repos or GitHub, and is a version control system that allows for
easier change tracking and collaboration.
Which feature commits the changes of Azure Data Factory work in a
custom branch created with the main branch in a Git repository? -
ANSWER-Pull request.
,After a developer is satisfied with their changes, they create a pull
request from their feature branch to the master or collaboration branch
to get their changes reviewed by peers.
Which feature in alerts can be used to determine how an alert is fired?
-ANSWER-Add criteria.
The add criteria feature enables you to determine how an alert is fired
Which type of analytics answers the question "What is likely to happen
in the future based on previous trends and patterns?" -ANSWER-
Predictive.
Predictive analytics "What is likely to happen in the future based on
previous trends and patterns?".
You have a requirement to occasionally prepare data for ad hoc data
exploration and analysis. Which resource model in Azure Synapse
Analytics is the most effective to use to meet this requirement? -
ANSWER-Serverless.
The serverless resource model is the ideal resource model in this
scenario as it makes use of the resources when required.
Where can you develop TSQL scripts and notebooks in Azure
Synapse Analytics? -ANSWER-Azure Synapse Studio.
Azure Synapse Studio is where you can develop TSQL scripts and
notebooks.
Which Azure Service is Azure Synapse Pipelines based on? -
ANSWER-Azure Data Factory.
, Azure Synapse Pipelines is based in the Azure Data Factory service.
What component of Azure Synapse analytics allows the different
engines to share the databases and tables between Spark pools and
SQL on-demand engine? -ANSWER-Azure Synapse shared
metadata.
The shared metadata gives the workspace SQL engines access to
databases and tables created with Spark.
Which Azure Synapse Analytics component enables you to perform
Hybrid Transactional and Analytical Processing? -ANSWER-Azure
Synapse Link.
Azure Synapse Link is the component that enables Hybrid
Transactional and Analytical Processing.
Which Azure Synapse Studio hub would you go to create Notebooks?
-ANSWER-Develop.
The Develop hub is where you manage SQL scripts, Synapse
notebooks, data flows, and Power BI reports.
In Azure Synapse Studio, where would you view the contents of the
primary data lake store? -ANSWER-In the linked tab of the Data hub.
The linked tab of the data hub is where you can view the contents of
the primary data lake store.
Which hub is where you can grant access to Synapse workspace and
resources? -ANSWER-Manage hub.
