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

Full form of SSIS is…

Answer :
  • SQL Server Integration Services

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

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

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

Answer :
  • Process Bytes

What are the components of Data Warehousing Solution?

Answer :
  • All of the above

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