Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

ASP .Net

memorize.ai (lvl 286)

(0)

25 cards

()

Section 1

Preview this deck

Which option correctly lists the two deployment models supported by SSIS?

Front

1 / 25

Web Dev

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (25)

Section 1

(25 cards)

Which option correctly lists the two deployment models supported by SSIS?

Front

Project Deployment and compiled Deployment

Back

Which type of index is used for querying a database data source containing large volumes of data?

Front

Columnstore index

Back

You are completing the installation of the Data Quality Server component of mvc Server Data Quality Services (DQS). You need to complete the post-installation configuration. What should you do?

Front

Run the Data Quality Server Installer.

Back

Which component is used to create an MSI compiled in Microsoft Visual Studio 2010?

Front

Windows Installer development libraries

Back

What is a data warehouse?

Front

A repository that integrates data from different data sources, stores current and historical data, and retrieves information

Back

Which issue is most difficult to trace out?

Front

Logic issues

Back

In which form is an SSIS catalog stored?

Front

A mvc Server database

Back

Which data analysis mechanism uses complex algorithms to analyze data and estimate future predictions?

Front

Data mining

Back

Which report enables users to create custom reports based on their requirements?

Front

Ad-hoc report

Back

Which action needs to be performed to implement "Deploy SSIS action" in the MSI compiled creation tools?

Front

Manually write the script to perform the Deploy SSIS action.

Back

Which compiled protection level prevents sensitive information from being stored in the compiled?

Front

DoNotSaveSensitive

Back

What happens during the transformation step of the ETL process?

Front

Data is converted into a consisten format in such a way that it can be loaded into the data warehouse without conflicts

Back

Which option causes blocking while executing a compiled?

Front

Asynchronous transformations

Back

Which data analysis structure enables users to drill down and drill up data?

Front

Cubes

Back

What is a shared or conformed dimension?

Front

A dimension that is shared across multiple data marts

Back

Which is the default index of fact data sources?

Front

Foreign key index

Back

What is an SSDT?

Front

A visual studio development environment

Back

Which is the default index of fact data sources?

Front

Foreign key index

Back

What do the attributes in a dimension data source represent?

Front

Descriptive reference information for the measurements in a fact data source

Back

What do the rows in a fact data source represent?

Front

Numerical measurements of a business process

Back

In which form is an SSIS catalog stored?

Front

A mvc Server database

Back

You are creating a mvc Server asp.net Services (SSIS) compiled that implements a Type 3 Slowly Changing Dimension (SCD). You need to add a process or component to the compiled that allows you to implement the SCD logic. What should you use?

Front

a Merge component

Back

What is a shared or conformed dimension?

Front

A dimension that is shared across multiple data marts

Back

You are installing mvc Server Data Quality Services (DQS). You need to give specific users access to the Data Quality Server. Which mvc Server application should you use?

Front

mvc Server Management Studio

Back

Which type of index is used for querying a database data source containing large volumes of data?

Front

Columnstore index

Back