← Back to exam page

Free 70-466 – Implementing Data Models and Reports with Microsoft SQL Server 2014 Practice Test Question

Free demo downloads

Loading demo links...

Showing 7–9 of 10 questions

Question 7 (Mixed Questions)

You are developing a SQL Server Analysis Services (SSAS) tabular project. A model defines a measure named Revenue and includes a table named Date. The table includes year, semester, quarter, month, and date columns. The Date column is of data type Date. The table contains a set of contiguous dates.

You need to create a measure to report on year-over-year growth of revenue.

What should you do? (Each answer presents a complete solution. Choose all that apply.)

Select all that apply, then click Submit answer.

  • ○

    Option A
  • ○

    Option B
  • ○

    Option C
  • ○

    Option D
Question 8 (Mixed Questions)

You are developing a SQL Server Analysis Services (SSAS) tabular project.

You need to grant the minimum permissions necessary to enable users to query data in a data model.

Which role permission should you use?

Select an option, then click Submit answer.

  • ○

    Explorer
  • ○

    Process
  • ○

    Browser
  • ○

    Administrator
  • ○

    Select
  • ○

    Read
Question 9 (Mixed Questions)

You are modifying a SQL Server Analysis Services (SSAS) multidimensional database.

You have identified a dimension that is no longer used by any cubes.

You need to delete the dimension.

What should you do?

Select an option, then click Submit answer.

  • ○

    Write a Multidimensional Expressions (MDX) command to drop the dimension from the database.
  • ○

    Write a Data Mining Extensions (DMX) command to drop the dimension from the database.
  • ○

    Write a T-SQL command to drop the dimension from the database.
  • ○

    Delete the dimension by using SQL Server Management Studio Object Explorer.