PrepAway - Latest Free Exam Questions & Answers

Category: 70-466 (v.1)

Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012 (update May 23th, 2014)

Which task should you add to the Developer role?

You are working with a SQL Server Reporting Services (SSRS) instance in native mode.
An item role named Developer is present on the server.
The Developer role cannot view and modify report caching parameters.
You need to ensure that the Developer role can viewand modify report caching parameters.
Which task should you add to the Developer role?

You need to modify the report so that users can sort products by the Price column

You are developing a SQL Server Reporting Services (SSRS) report that renders in HTML.
The report includes a dataset with fields named Description, Price, and Color.
The report layout includes a table that displays product details and also includes columns named Description,
Price, and Color.
You need to modify the report so that users can sort products by the Price column.
What should you do?

You need to implement a solution that meets the requirements

You are developing a SQL Server Analysis Services (SSAS) tabular project.
The model includes a table named Sales.
The Sales table includes a single date column.
The Sales table must meet the following requirements:
– Queries must be able to return all rows.
– Must be able to support four different processingschedules for different date ranges.
– Date ranges must not include any overlapping data.
You need to implement a solution that meets the requirements.
What should you do?

You need to modify the cube design to ensure that the Total Quantity On Hand measure is updated in real- time

You are modifying a SQL Server Analysis Service (SSAS) cube.
The cube consist of a single measure group that contains the following measures:
– Total Quantity On Hand
– Average Quantity On Hand
The measure group has a single partition that uses the MOLAP storage mode.
You need to modify the cube design to ensure that the Total Quantity On Hand measure is updated in real- time
and that Average Quantity On Hand measure is updated hourly.
What should you do?

Which project types should you use?

You are developing a BI Semantic Model (BISM) basedon a simple and small dataset sourced from SQL
Server.
The data size and complexity of the data relationships will not change.
The model will be used to produce reports in Power View.
You need to use an appropriate project type.
Which project types should you use? (Each answer presents a complete solution. Choose all that apply.)

You need to temporarily suspend the shared scheduleuntil the shared folder is brought back online

You manage an environment that has SharePoint Server 2010 and a SQL Server Reporting Services (SSRS)
instance in SharePoint integrated mode.
Several report subscriptions are configured to deliver reports through a shared folder by using a shared
schedule.
The shared folder will be going offline.
You need to temporarily suspend the shared scheduleuntil the shared folder is brought back online.
What should you do?

Which Data Analysis Expressions (DAX) expression should you use?

You are developing a SQL Server PowerPivot workbookthat sources data from a SQL Azure database.
The PowerPivot model includes a single table named FactSales that consists of four columns named Year,
Country, Product, and Revenue.
The model includes the following two measures :
.Sales:=SUM(FactSales[Revenue])
.Sales %:=[Sales] / CALCULATE([Sales], ALL(FactSales))
In Microsoft Excel 2010 you create the following PivotTable report.

Users report that the Sales % measure computes an incorrect ratio.
The measure should meet a requirement to compute a ratio over all visible sales values defined by the query
filters.
The Grand Total value for the Sales % measure should equal 100%.
You need to fix the Sales % measure to meet the requirement.
Which Data Analysis Expressions (DAX) expression should you use?

You need to configure the Employees roles so that users can query only sales orders for their respective sales

You are developing a SQL Server Analysis Services (SSAS) tabular project.
The model includes a table named DimEmployee.
The table contains employee details, including the sales territory for each employee.
The table also defines a column named EmployeeAliaswhich contains the Active Directory Domain Services
(AD DS) domain and logon name for each employee.
You create a role named Employees.
You need to configure the Employees roles so that users can query only sales orders for their respective sales
territory.
What should you do?

Which value should you select for the AggregationFunction property for the Average Rate measure?

You are developing a SQL Server Analysis Services (SSAS) cube for the accounts department.
You create a measure group named Exchange Rate thatconsists of measures pertaining to currency exchange
rates.
One of the measures in this group is named Average Rate and it will be used to report the average currency
exchange rate over time.
Currently the AggregationFunction property for the Average Rate measure is set to Sum.
You need to ensure that Average Rate measure reports the average of the currency exchange rate over time.
Which value should you select for the AggregationFunction property for the Average Rate measure?
To answer, select the appropriate setting in the answer area.

You need to temporarily suspend the shared scheduleuntil the email server is brought back online

You manage an environment that has SharePoint Server 2010 and a SQL Server Reporting Services (SSRS)
instance in SharePoint integrated mode.
Several report subscriptions are configured to deliver reports through email by using a shared schedule.
The email server will be going offline.
You need to temporarily suspend the shared scheduleuntil the email server is brought back online.
What should you do?


Page 1 of 912345...Last »