Exam (elaborations)
SSIS QA TEST QUESTIONS AND ANSWERS
- Course
- Institution
SSIS QA TEST QUESTIONS AND ANSWERS...
[Show more]
Content preview
SSIS QA TEST QUESTIONS ANDANSWERS
What is dataflow in SSIS? - ANSWER Data flow is nothing but the flow
of data from the corresponding sources to the referred destinations. In
this process, the data transformations make changes to the data to
make it ready for the data warehouse.
What is a breakpoint in SSIS? How is it set up? How do you disable it? -
ANSWER A breakpoint is a stopping point in the code. The breakpoint
can give the Developer\DBA an
opportunity to review the status of the data, variables and the overall
status of the SSIS package.
10 unique conditions exist for each breakpoint.
Breakpoints are set up in BIDS. In BIDS, navigate to the control flow
interface. Right-click on the
object where you want to set the breakpoint and select the 'Edit
Breakpoints...' option.
Can you name 5 or more of the native SSIS connection managers? -
ANSWER 1) OLEDB connection - Used to connect to any data source
requiring an OLEDB connection (i.e.,
SQL Server 2000)
2) Flat file connection - Used to make a connection to a single file in the
File System. Required for reading information from a File System flat file
3) ADO.Net connection - Uses the .Net Provider to make a connection to
SQL Server 2005 or other
connection exposed through managed code (like C#) in a custom task
4) Analysis Services connection - Used to make a connection to an
Analysis Services database or project. Required for the Analysis
Services DDL Task and Analysis Services Processing Task
5) File connection - Used to reference a file or folder. The options are to
either use or create a file or folder
6) Excel
, What is the use of Bulk Insert Task in SSIS? - ANSWER Bulk Insert
Task is used to upload large amount of data from flat files into Sql
Server. It supports only OLE DB connections for destination database.
What is Conditional Split transformation in SSIS? - ANSWER This is
just like IF condition which checks for the given condition and based on
the condition evaluation, the output will be sent to the appropriate
OUTPUT path. It has ONE input and MANY outputs. Conditional Split
transformation is used to send paths to different outputs based on some
conditions. For example, we can organize the transform for the students
in a class who have marks greater than 40 to one path and the students
who score less than 40 to another path.
How do you eliminate quotes from being uploaded from a flat file to SQL
Server? - ANSWER This can be done using TEXT QUALIFIER
property. In the SSIS package on the Flat File Connection Manager
Editor, enter quotes into the Text qualifier field then preview the data to
ensure the quotes are not included.
Can you explain how to setup a checkpoint file in SSIS? - ANSWER
The following items need to be configured on the properties tab for SSIS
package:
CheckpointFileName - Specify the full path to the Checkpoint file that the
package uses to save the value of package variables and log completed
tasks. Rather than using a hard-coded path as shown above, it's a good
idea to use an expression that concatenates a path defined in a package
variable and the package name.
CheckpointUsage - Determines if/how checkpoints are used. Choose
from these options: Never(default), IfExists, or Always. Never indicates
that you are not using Checkpoints. IfExists is the typical setting and
implements the restart at the point of failure behavior. If a Checkpoint file
is found it is used to restore package variable values and restart at the
point of failure. If a Checkpoint file is not found the package starts
execution with the first task. The Always choice raises an error if the
Checkpoint file does not exist.
SaveCheckpoints - Choose from these options: True or False (default).
You must select True to implement the Checkpoint behavior.
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 $11.89. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
78252 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now