Implementing a SQL 2016 Data Warehouse (SSIS) Quiz Questions and Answers

What is the BreakPoint in SSIS?

Answer :
  • BreakPoint is stopping point in code

What is BCP?

Answer :
  • Bulk Copy Program

How many components are present in SSIS Toolbox?

Answer :
  • 7

The key counters for Integration Services and SQL Server are...

Answer :
  • Process Bytes

Which of the following are the types of components available in the data flow task?

Answer :
  • All of the above

Dimension and cube processing can be scheduled using SSIS.

Answer :
  • True

Which of the following properties is associated with the column-based index?

Answer :
  • It is best to use in Data Warehouse

Which of the following properties is associated with the row-based index?

Answer :
  • It is best to use in OLTP database

In the dimension table, the business key is retained as...

Answer :
  • Alternate Key

Hash distribution is a part of...

Answer :
  • Data Distribution