SSAS 2008 Online Assessment Test to Assess & Hire SSAS Developer

Candidates Assessed

12780+

Organisations Served

105+

About SSAS 2008 Online Assessment Test

Microsoft SQL Server Analysis Services (SSAS) is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server. This tool is used to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files.

SSAS 2008 online assessment test helps recruiters and hiring managers to evaluate SSAS skills of the candidate. SSAS 2008 development test is designed and validated by Subject Matter Experts (SME) to assess and hire SSAS developer as per the industry standard.

Are you a jobseeker looking to sharpen your skills?

Test Duration: 20 minutes

No. of Questions: 10

Level of Expertise: Mid

Development

Our SSAS 2008 online assessment test helps recruiters to evaluate candidates SSAS development skills

Security

This SSAS test helps recruiters to assess candidates' ability to secure SSAS packages

Data Modeling

This test helps recruiters to evaluate candidates' proficiency with data modeling in SSAS server

Deployment

Our SSAS development test helps recruiters to evaluate candidates' ability to perform deployment in SSAS

Sample Questions

Choose from our 100,000+ question library or add your own questions to make powerful custom tests

Question types:

Multiple Option

Topic:

Difficulty:

Easy

Q 1. You create a SQL Server 2008 Analysis Services (SSAS) solution. The solution contains a time dimension named DimTime. You have a table named FactSales that contains the two columns named OrderDate and ShipDate. The two columns refer to the DimTime dimension. You need to ensure that the DimTime dimension can be used to browse through measures in the FactSales table for both OrderDate and ShipDate. What should you do?

Create a reference relationship between the DimTime dimension and the FactSales measure group.

Create a many-to-many relationship between the DimTime dimension and the FactSales measure group.

Create two regular relationships between the DimTime dimension and the FactSales measure group. Use identical measure group columns.

Create two regular relationships between the DimTime dimension and the FactSales measure group. Use different measure group columns.

Question types:

Multiple Option

Topic:

Difficulty:

Easy

Q 2. You create a SQL Server 2008 Analysis Services (SSAS) solution. You add a data source view (DSV) to the solution. The DSV has a table named Employee that includes the following columns:
- EmployeeKey
- ManagerKey

The ManagerKey column references the manager of the employees. You need to define the relationship between the employees and their manager in the DSV. What should you do?

Create a Named Calculation that uses EmployeeKey and ManagerKey

Create a relationship by using EmployeeKey as the source column and ManagerKey as the destination column.

Create a Named Query that uses a relationship with EmployeeKey as the source column and ManagerKey as the destination column.

Create a relationship by using ManagerKey as the source column and EmployeeKey as the destination column.

Question types:

Multiple Option

Topic:

Difficulty:

Easy

Q 3. You create a SQL Server 2008 Analysis Services (SSAS) solution by using SQL Server 2008. You create the dimensions as shown in the following table.

The CustKey attribute is used as a column in a table named FactSales. You need to create a referenced dimension that allows you to browse the measures of the FactSales table by using the DimGeography dimension. What should you do?

Set the reference dimension to DimGeography by using a referenced dimension attribute as GeoKey and an intermediate dimension attribute as CustKey.

Set the reference dimension to DimGeography by using a referenced dimension attribute as GeoKey and an intermediate dimension attribute as GeoKey.

Set the reference dimension to DimCustomer by using a referenced dimension attribute as CustKey and an intermediate dimension attribute as GeoKey.

Set the reference dimension to DimCustomer by using a referenced dimension attribute as GeoKey and an intermediate dimension attribute as GeoKey.

Sample Report

View Full Report . . .

Hire job-fit candidates using this test now

You can customize this test by

Setting difficulty level of test

Choose easy, medium or hard questions from our skill libraries to assess candidates of different experience levels.

Combining multiple skills into one test

Add multiple skills in a single test to create an effective assessment. Assess multiple skills together.

Adding your own questions to the test

Add, edit or bulk upload your own coding questions, MCQ, whiteboarding questions & more.

Requesting a tailor-made test

Get a tailored assessment created with the help of our subject matter experts to ensure effective screening.

Megan Akhras, Co-founder & director, JExcelle, Canada

“We are a tutoring agency, wherein the crux of our business lies in the quality of the tutors we hire. Hence it is imperative that our hiring is top notch. We were impressed by the caliber, depth, and breadth of the assessments provided by iMocha. With iMocha, we have found a great assessment tool for our hiring requirements.”

SSAS 2008 Online Assessment Test

12780+

105+

About SSAS 2008 Online Assessment Test

Test Summary

Useful for hiring

Topics Covered

Development

Security

Data Modeling

Deployment

Sample Questions

Sample Report

Hire job-fit candidates using this test now

You can customize this test by

Setting difficulty level of test

Combining multiple skills into one test

Adding your own questions to the test

Requesting a tailor-made test

Related Skills

Trusted By

Megan Akhras, Co-founder & director, J'Excelle, Canada

Start hiring job-fit candidates using this assessment