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

GET A DEMO

"Our recruiters no longer rely only on the telephonic interviews. We shortlist candidates based on assessment reports. The detailed test reports provide skill wise analysis of each candidate. This has helped our clients reduce their time to hire by 60%."

Vipin Sharma, Mobile Programming,
General Manager HR & Recruitement
Question

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?

Answer
    • Report Server databases

    • SQL Server Reporting Services configuration

    • Encryption keys backup

    • All of the mentioned

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

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?

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

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 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...
GET A DEMO

Why hiring managers and recruiters across the globe love Interview Mocha

Take your first step to hire job fit candidates

GET A DEMO