SSIS SSRS SSAS 2008 Online Assessment Test

Topics covered

different services provided by SQL Server, Data warehousing, Multidimensional Analysis

  • MAQ (Multiple Answer Question)
  • MCQ (Multiple Choice Question)
  • Descriptive Question
  • White Board Simulator
  • Coding Simulator
  • Audio Question
  • Video Question
  • Case Study Question

SSIS SSRS SSAS Online Test has been designed and developed to help employers and recruiters evaluate the SQL Reporting, Analysis, Integration services skills of candidates of SQL Server 2008. Microsoft SQL Server BI developer can perform information processing such as data integration, reporting and analysis. The individual can operate different services provided by SQL Server 2008. Online SSAS SSIS SSRS Test is specially designed to check application, practical skills of Microsoft SQL Server BI developer – as per Industry Standards.

SSIS SSRS SSAS Skills Test contains meaningful questions on different services provided by SQL Server, Data warehousing, Multidimensional Analysis and much more.

SSRS SSAS SSIS Assessment Test is designed by our subject matter experts to evaluate the job skills of SQL Server BI developer and their knowledge about SSIS/SSRS/SSAS 2008. Using powerful reporting, you can have a detailed analysis of the test results to help you make a better hiring decision and predict the candidate’s performance.

The test contains MCQ's (Multiple Choice Questions), MAQ's (Multiple Answer Questions), Fill in the Blank, Descriptive, True or False.

This pre-employment test is useful for hiring:
  • SQL Server BI Developer
  • SSIS/SSAS/SSRS Developer
  • SSIS/SSAS/SSRS BI Consultant

Test details:

This SSIS SSRS SSAS Interview Test enables employers and recruiters to identify & SQL Server BI developer by evaluating working skills and job readiness. For this reason, the emphasis is laid upon evaluating the knowledge of applied skills gained through real work experience, rather than theoretical knowledge.

Duration: 15 minutes
Questions: 15

Microsoft SSIS SSRS SSAS Test

Question #1 of 3

You are working as an administrator of SQL Server Reporting Services instance. You have a requirement to backup SQL Server Reporting Services. Which all items should be backed up for reporting services to operate normally once it is restored to another server?

    • Report Server databases

    • SQL Server Reporting Services configuration

    • Encryption keys backup

    • All of the mentioned

Question #2 of 3

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're run.  How will you implement the desired functionality

    • 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 #3 of 3

You are developing a SQL Server Analysis Tabular model. This tabular model is sourced from SQL Server database. This source doesn't have a time dimension implemented. What can you do to implement time dimension?

    • Create a time dimension by using the Define time intelligence option in the Business Intelligence Wizard.

    • Use the SQL Server Data Tools Dimension Wizard and generate a time table in the data source.

    • Create a time dimension by using the Define dimension intelligence option in the Business Intelligence Wizard.

    • Add an existing SSAS database time dimension as a cube dimension.

Candidate Name
Assessment Name
Invited by
Assessment Date
IP Address

24.00 Out of 40.00
23 Minutes

Java EE




Oracle PL/SQL


Analytical Thinking


Note:If score<= 30% then its a Weakness. If score >=70% then its a Strength.


Java EE, Oracle PL/SQL, Analytical Thinking




It was a good test for me, the questions were on the latest technology of java on which I am currently working. It was a great experience. Thank you!

Take your first step to hire job fit candidate


How Interview Mocha works?

  • Add this test to your account

  • Invite candidates to take this test online

  • Candidates take the test

  • View and share actionable test reports

Trusted by leading brands worldwide

  • altran
  • credit suisse
  • sephora
  • nielsen
  • capgemini
  • akamai
Why hiring managers and recruiters across the globe love Interview Mocha
  • Largest number of ready pre-employment skill tests
  • Relevant test compositions and quality questions designed by Subject Matter Experts (IM SME)
  • Fastest custom test creation DNA
  • World’s most super easy skill assessment platform
  • High level of platform security implementation
  • Friendly and quick customer support
  • Ready to listen and implement your feedback, we are all ears
  • Affordable pricing

Take your first step to hire job fit candidate