SSIS 2008 Online Assessment Test
Topics Covered
- SSIS Packages
- BI Development Studio
- Data Flow Task and Components
- Database Configuration
Useful for hiring
- SSIS Developer
- SQL Server BI Developer
- SSIS BI Consultant
Start hiring job-fit candidates using this assessment
GET A DEMO
"We are impressed by the caliber, depth, and breadth of the assessments provided by Interview Mocha. With Interview Mocha's online proctoring & powerful reports, we are able to hire quality candidates overcoming geographical barriers."
Co-founder & director
Question
You've designed a "parent" package that will execute several "child" packages. You would like to pass the database connection string from the parent to each of the child packages as they run. How will you implement the desired functionality?
Answer
-
Establish an inter-program named pipe between the packages at runtime
-
By referencing the parent package's variables from the child packages using a package configuration
-
This functionality is not supported by SSIS
-
Add the variables to be used by the child packages to the parent package's Shared Variable collection
Question
When a Lookup transform fails to find a matching row, an error condition is raised. What are the valid actions you can configure a Lookup transform to perform when this error is raised?
Answer
-
Ignore failure
-
Write to log file
-
Execute another package
-
Throw Exception
Question
You are a part of SSIS developer team and have been asked by your lead to process SSAS cube once the pull is completed. Using which of the following SSAS transformations you can process SSAS cubes?
Answer
-
SSAS Processing
-
AMO Command
-
Partition Processing
-
SSIS does not provide this functionality
Good News! You can customize this test as per your requirement
Choose and add questions from Interview Mocha question libraries
Add your own set of questions
Customize test settings like duration, number of questions, passing score, web proctoring and much more
Mail us at support@interviewmocha.com to create a custom test
Looking for a tailor-made test, to suit your assessment needs?
Get in touchGlobal companies using Mocha assessments
How Mocha assessments are brewed
Speed up your IT recruitment with Interview Mocha
- 500+ IT skill tests
- 20+ coding languages
- 50+ domain knowledge tests
- 100+ digital 2.0 skill tests
- Customer focus aptitude tests
- Enterprise ready features & more...
Related Tests
Why hiring managers and recruiters across the globe love Interview Mocha
1000+ Ready Skills
Largest number of ready pre-employment skill tests
Subject Matter Experts
Relevant test compositions and quality questions designed by Subject Matter Experts
Tailor-made tests
Fastest custom tests creation to suit the job description
Super Easy to Use
World’s most easy to use skill assessment platform
Secure & Robust
High level of platform security implementation
Powerful Reports
Intuitive reports & advanced analytics to make informed hiring decisions
Smart Question Types
Simulators & Innovative logic box to remove guess-work from hiring
Team collaboration
Easy sharing of reports amongst the hiring team & recruiters
Take your first step to hire job fit candidates
