Are you a candidate looking to sharpen your skills? Try our practice tests or view sample interview questions & Get hired by the best. Click Here×

SSIS SSRS SSAS 2008 Online Assessment Test

Topics Covered

  • Rendering
  •  Troubleshooting
  • Structure
  •  Security
  • Report Navigation
  • Configuration
  •  Error handling
  • Data source management
  • Component Selection
  •  Connection Scope
  • Data transformation
  •  Data Adapters

Useful for hiring

  • Business Intelligence Analyst
  • BI Developer (SSAS
  • SSIS)
  • SQL Server Developer (SSIS
  • SSRS
  • SSAS)

Start hiring job-fit candidates using this assessment


"We realized that to acquire quality talent, our recruitment process was in dire need of automation. Too many of our technicalteam were simply wasting hours conducting interviews that did not yield the desired results. For us the foremost criteria were to finda recruitment partner who could tick all the right boxes"

Rehana Nisar, Gartner,
Global Product & Services Recruitment Head

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


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?

    • 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


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 the 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 timetable 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.

Test details:

SSIS SSRS SSAS skills test will evaluate a candidate's practical knowledge and will identify whether the candidate is ready to be employed. SSIS SSRS SSAS test can be taken online by candidates from anywhere in the comfort of their time zone.
SSIS SSRS SSAS pre-employment test may contain MCQ's (Multiple Choice Questions), MAQ's (Multiple Answer Questions), Fill in the Blank, Descriptive, Whiteboard Questions, Audio / Video Questions, True or False.

Test Duration: 20 minutes

10 Application Questions

Test description:

SSAS (SQL Server Analytic Services) 2012 helps to provide online analytic processing (OLAP) of data from disparate data sources. It also allows users to analyze data with a host of tools including SSRS and Excel. SSRS (SQL Server Reporting Services) 2012 helps to empower your users to make effective, informed decisions based on trusted data and delivered in formats appropriate for the user.  SSIS (SQL Server Integration Services) 2012 helps to implement an appropriate information management foundation that can deliver integrated, accurate, and timely data across your organization.  

SSIS SSRS SSAS Online Test helps recruiters and hiring managers to assess candidate’s ability to work Business Intelligence expert. SSIS SSRS SSAS online test is created & validated by experienced subject matter experts (SMEs) to assess & hire SSIS SSRS SSAS developer as per the industry standards.

SSIS SSRS SSAS assessment test helps to screen the candidates who possess traits as follows:

1.  Experience in Business Intelligence, Technical Impact Analysis.
2.  Ability to handle SSIS jobs and Packages.
3.  Ability to handle SSRS jobs and Report.
4.  Ability to handle SSAS Services.Knowledge of SQL Server and database queries.  

Our powerful reporting will give you an instant result and an option to share this result with your recruiting team. You can analyze section wise performance of candidate to gauge his/her strengths and weaknesses. Features like window violation and webcam proctoring help to detect cheating during the test.

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 to create a custom test

Looking for a tailor-made test, to suit your assessment needs?

Get in touch

Global companies using Mocha assessments

  • altran
  • credit suisse
  • sephora
  • nielsen
  • capgemini
  • akamai

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...

Why hiring managers and recruiters across the globe love Interview Mocha

Take your first step to hire job fit candidates