Exam (elaborations)
SSIS TEST QUESTIONS AND VERIFIED ANSWERS
- Course
- Institution
SSIS TEST QUESTIONS AND VERIFIED ANSWERS...
[Show more]
Content preview
SSIS TEST QUESTIONS AND VERIFIEDANSWERS
What is SSIS? - ANSWER SQL Server Integration Services is a
platform for building enterprise-level data integration and data
transformation solutions. Use Integration Services to solve complex
business problems by copying or downloading files, loading data
warehouses, cleansing and mining data, and managing SQL Server
objects and data.
What are the important components of the SSIS package? - ANSWER
Control Flow (Stores containers and Tasks)
Data Flow (Source, Destination, Transformations)
Event Handler (sending of messages and emails)
Package Explorer (Offers a single view for all in the package)
Parameters (User Interaction)
Explain Solution Explorer in SSIS - ANSWER The Solution Explorer
window is where you can find all your created SSIS packages, project
connection managers, project parameters, and any other miscellaneous
files needed for the project, such as installation documents. As
mentioned earlier, a solution is a container that holds a series of
projects.
What does it mean by data flow in SSIS? - ANSWER The Data Flow
task encapsulates the data flow engine that moves data between
sources and destinations, and lets the user transform, clean, and modify
data as it is moved. Addition of a Data Flow task to a package control
flow makes it possible for the package to extract, transform, and load
data.
Define what is "task" in SSIS? - ANSWER Tasks are control flow
elements that define units of work that are performed in a package
control flow. An SQL Server Integration Services package is made up of
one or more tasks. If the package contains more than one task, they are
connected and sequenced in the control flow by precedence constraints.
, What is an SSIS package? - ANSWER A SQL Server Integration
Services (SSIS) package includes the necessary components, such as
the connection manager, tasks, control flow, data flow, parameters,
event handlers, and variables, to execute a specific ETL task.
Name different types of connection or files that support SSIS? -
ANSWER SSIS also includes data types that support other database
systems such as Jet, DB2, and Oracle. Plus SSIS types support data
from Excel spreadsheets, comma-separated values (CSV) files, text
files, directory services, and other sources.
What is a container? How many types of containers are there in SSIS? -
ANSWER SQL Server containers are SQL Server instances based on
Microsoft's shared DLL architecture that has supported multiple SQL
Server instances on a host for the past decade. Containers provide
added process and user isolation, SQL Server configuration, and are
accessible via SQL Management Studio and other tools.
There are three types of containers in the Control Flow tab: Sequence,
For Loop, and Foreach Loop Containers.
What is Precedence Constraint in SSIS? - ANSWER The precedence
constraint uses a constraint value, an expression, both, or either to
determine whether the constrained executable runs. If the precedence
constraint uses an execution result, you can specify the execution result
to be success, failure, or completion.
What variables in SSIS and what are the types of variables in SSIS? -
ANSWER A variable is a named object that stores one or more values
and can be referenced by various SSIS components throughout the
package's execution. ... You can configure a variable so its value is
updated at run time, or you can assign a value to the variable when you
create it.
Integration Services supports two types of variables: user-defined
variables and system variables. User-defined variables are defined by
package developers, and system variables are defined by Integration
Services.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller luzlinkuz. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
79079 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now