Microsoft Microsoft Business Intelligence

Microsoft 70-466 Exam Demo,Sale Best Microsoft 70-466 Study Guide Book Is What You Need To Take

[The Newest Dumps] Real Microsoft 70-466 exam dumps revised by experts, they were updated with the change of the Microsoft 70-466,covering all the whole aspects of Microsoft 70-466 exam. Just have a training of Flydumps Microsoft 70-466 exam questions to guarantee your 100% pass

Testlet 1
Scenario 1
General Background
You are the data architect for a company that uses SQL Server 2012 Enterprise Edition. You design data modeling and reporting solutions that are based on a sales data warehouse.

Background
The solutions will be deployed on the following servers:
ServerA runs SQL Server Database Engine. ServerA is the data warehouse server.

ServerB runs SQL Server Database Engine, SQL Server Analysis Services (SSAS) in
multidimensional mode, and SQL Server Integration Services (SSIS).
ServerC runs SSAS in tabular mode, SQL Server Reporting Services (SSRS) running in
SharePoint mode, and Microsoft SharePoint 2010 Enterprise Edition with SP1. The data warehouse schema currently contains the tables shown in the exhibit. (Click the Exhibit button.)
Business Requirements
The reporting solution must address the requirements of the sales team, as follows:
Team members must be able to view standard reports from SharePoint.

Team members must be able to perform ad-hoc analysis by using Microsoft Power View and Excel.

Team members can have standard reports delivered to them on a schedule of their
choosing.
The standard reports:

Will use a sales territory hierarchy for organizing data by region.

Will be accessible from SharePoint. The Excel ad-hoc reports:

Will use the same data store as the standard reports.

Will provide direct access to the data store for the sales team and a simplified view for
the executive team.
Technical Requirements
The standard reports must be based on an SSAS cube. The schema of the data warehouse on ServerA must be able to support the ability to slice the fact data by the following dates:
Order date (OrderDateKey)

Due date DueDateKey
Ship date (ShipDateKey)
Additions and modifications to the data warehouse schema must adhere to star schema design
principles to minimize maintenance and complexity.
The multidimensional and tabular models will be based on the data warehouse. The tabular and
multidimensional models will be created by using SQL Server Data Tools (SSDT). The tabular
project is named AdhocReports and the multidimensional project is named StandardReports.
The cube design in the StandardReports project must define two measures for the unique count
of sales territories (SalesTerritoryKey) and products (ProductKey).
A deployment script that can be executed from a command-line utility must be created to deploy
the StandardReports project to ServerB.
The tabular model in the AdhocReports project must meet the following requirements:
A hierarchy must be created that consists of the SalesTerritoryCountry and
SalesTerritoryRegion columns from the DimSalesTerritory table and the EmployeeName
column from the DimEmployee table.
A key performance indicator (KPI) must be created that compares the total quantity sold
(OrderQuantity) to a threshold value of 1,000.
A measure must be created to calculate day-over-day (DOD) sales by region based on
order date. SSRS on ServerC must be configured to meet the following requirements:

It must use a single data source for the standard reports.

It must allow users to create their own standard report subscriptions.

The sales team members must be limited to only viewing and subscribing to reports in the
Sales Reports library. A week after the reporting solution was deployed to production, Marc, a salesperson, indicated that he has never received reports for which he created an SSRS subscription. In addition, Marc reports that he receives timeout errors when running some reports on demand.
QUESTION 1
You need to deploy the StandardReports project.
What should you do? (Each correct answer presents a complete solution. Choose all that apply.)
A. Deploy the project from SQL Server Data Tools (SSDT).
B. Use the Analysis Services Deployment utility to create an XMLA deployment script.
C. Use the Analysis Services Deployment wizard to create an MDX deployment script.
D. Use the Analysis Services Deployment wizard to create an XMLA deployment script.
Correct Answer: AD Section: [none] Explanation
Explanation/Reference:
There are several methods you can use to deploy a tabular model project. Most of the deployment methods that can be used for other Analysis Services projects, such as multidimensional, can also be used to deploy tabular model projects.
A: Deploy command in SQL Server Data Tools
The Deploy command provides a simple and intuitive method to deploy a tabular model project from the SQL Server Data Tools authoring environment.
Caution:
This method should not be used to deploy to production servers. Using this method can overwrite certain properties in an existing model.

D: The Analysis Services Deployment Wizard uses the XML output files generated from a Microsoft SQL Server Analysis Services project as input files. These
input files are easily modifiable to customize the deployment of an Analysis Services project. The generated deployment script can then either be immediately run
or saved for later deployment.

Incorrect:
not B: The Microsoft.AnalysisServices.Deployment utility lets you start the Microsoft SQL Server Analysis Services deployment engine from the command prompt.
As input file, the utility uses the XML output files generated by building an Analysis Services project in SQL Server Data Tools (SSDT).

QUESTION 2

You need to create the hierarchy in the AdhocReports project in time for the next production release cycle.

What should you do?

A. Multi-select all of the columns, right-click the columns, and then click the Create Hierarchy command. Check in the changes before the next release cycle.
B. Use the RELATED() function to consolidate the columns in the DimSalesTerritory table, multi-select the columns, right-click the columns, and then click the Create Hierarchy command. Check in the changes before the next release cycle.
C. Use the RELATEDTABLEQ function to consolidate the tables, multi-select the columns in the hierarchy, right-click the columns, and then click the Create Hierarchy command. Check in the changes before the next release cycle.
D. Use the RELATED() function to consolidate the columns in the DimEmployee table, multi- select the columns, right-click the columns, and then click the Create Hierarchy command. Check in the changes before the next release cycle.
Correct Answer: D Section: [none] Explanation
Explanation/Reference:
QUESTION 3
You need to identify the reports that produce the errors that Marc is receiving.
What should you do?
A. Write a query by using the Subscriptions table in the report server database.
B. Use the Windows Event Viewer to search the Application log for errors.
C. Write a query by using the ExecutionLog3 view in the report server database.
D. Search the ReportServerService_<timestamp>.log file for errors.
Correct Answer: C Section: [none] Explanation
Explanation/Reference:
QUESTION 4
You need to create the KPI in the AdhocReports project in time for the next production release cycle.
What should you do?
A. Create a measure by using the SUM([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value. Check in the changes before the next release cycle.
B. Create a KPI based on the OrderQuantity column and then set the target value. Check in the changes before the next release cycle.
C. Create a measure by using the SUM([OrderQuantity]) expression. Then use the CREATE KPI CURRENTCUBE statement to define the KPI and target value. Check in the changes before the next release cycle.
D. Create a measure by using the COUNT([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value. Check in the changes before the next release cycle.
Correct Answer: C Section: [none] Explanation
Explanation/Reference:
QUESTION 5
You need to ascertain why Marc did not receive his reports.
What should you do?
A. Search the ReportServerService_<timestamp>.log file for errors.
B. Search the registry for errors.
C. Use the Windows Event Viewer to search the Application log for errors.
D. Use SQL Server Management Studio to search the SQL Server logs for errors.
Correct Answer: B Section: [none] Explanation
Explanation/Reference:
QUESTION 6
You need create the data source view for the StandardReports project.
What should you do?
A. Generate a relational schema from the dimensions and cubes by using the Schema Generation wizard.
B. Create a data source, connect it to the data warehouse, and then use the Data Source View wizard.
C. Execute the Import from Table wizard and then use the Data Source View wizard.
D. Create a new data source view and then use the Import from Table wizard.
Correct Answer: B Section: [none] Explanation
Explanation/Reference:
QUESTION 7
You need to create the sales territory and product measures. Which aggregate function should you use for both measures?
A. COUNT (DISTINCT column_name)
B. Distinct Count
C. Distinct
D. Count
Correct Answer: B Section: [none] Explanation
Explanation/Reference:
QUESTION 8
You need to configure the SSRS data source. What should you do?
A. Store the credentials.
B. In the data source configuration window, select the Prompt for credentials option.
C. Create a .NET form to enable users to enter their credentials.
D. Configure Kerberos authentication.
Correct Answer: A Section: [none] Explanation
Explanation/Reference:
QUESTION 9
You need to create a measure for DOD sales.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
A. Specify a date table by using a Mark as Date table.
B. Use the Data Analysis Expressions (DAX) PARALLELPERIOD() function.
C. Use the Business Intelligence Wizard to define time intelligence.
D. Use the Multidimensional Expressions (MDX) LAG() function.
Correct Answer: AC Section: [none] Explanation
Explanation/Reference:
* From scenario:
A measure must be created to calculate day-over-day (DOD) sales by region based on order date.

A: Specify Mark as Date Table for use with Time Intelligence (SSAS Tabular) In order to use time intelligence functions in DAX formulas, you must specify a date
table and a unique identifier (datetime) column of the Date data type. Once a column in the date table is specified as a unique identifier, you can create
relationships between columns in the date table and any fact tables.

C: The time intelligence enhancement is a cube enhancement that adds time calculations (or time views) to a selected hierarchy. This enhancement supports the
following categories of calculations:
Period to date.
Period over period growth.
Moving averages.
Parallel period comparisons.

QUESTION 10
You need to complete the design of the data warehouse.
Which design should you use? (To answer, drag the appropriate tables and relationships to the correct location in the answer area. Use only the tables and relationships that apply.)
Select and Place:

Correct Answer:

Section: [none] Explanation
Explanation/Reference: Testlet 1 Background
You are the business intelligence (BI) solutions architect for Contoso Ltd, a multinational sales company with offices in London, Madrid, Paris, Brisbane, Tokyo, and New York. Contoso sells office consumable products such as pens, printer ink, and paper.
You produce solutions by using SQL Server 2012 Business Intelligence Edition and Microsoft SharePoint Server 2010 Enterprise Edition with SP1.
Technical Background
Contoso’s products are categorized by using four levels while some use only two or three levels. Products are categorized as shown in the following table.

Contoso sells products through mobile sales staff, direct marketing, and its website. Sales personnel are located in various regions around the world, and each region has a sales manager who is paid a quarterly bonus based on the total sales in the region during the quarter. Regions are categorized as shown in the following table.

SQL Server Analysis Services (SSAS) is used to host a multidimensional database. The database contains a single cube named Sales and three database dimensions named Products, Regions, and Date. A single measure named Sales Total has been defined in the cube. The data source for the database is a SQL Server data warehouse.
The Products dimension contains a single user-defined hierarchy named Products. To prevent the display of empty members when users browse the Products dimension, the Extract, Transform, and Load (ETL) process populates all missing values as shown in the following diagram.

The structure of the Products hierarchy is shown in the following diagram.

The Regions dimension contains a single user-defined hierarchy named Sales Regions. The dimension is based on a single dimension table in the data warehouse
and the attribute relationships have not been modified since the dimension was created by using the Dimension wizard. The structure of the Sales Regions hierarchy is shown in the following diagram.

The Date dimension contains a single user-defined hierarchy named Calendar. The structure of the Calendar hierarchy is shown in the following diagram.

A role named UserRegions has been created in the SSAS database that will be used to filter members in the Regions dimension based on the authenticated user.
Administrative staff from around the world will produce sales reports with Microsoft Excel 2010 based on the Sales cube.
Developers will produce reports with SQL Server Reporting Services (SSRS) based on the Sales cube and the reports will be delivered to users through report
subscriptions and a web browser. All users log on to an Active Directory Domain Services (AD DS) domain named contoso.com. All client computers and servers
are joined to the contoso.com domain.

Business Requirements

The BI system must meet the following reporting requirements:
· Display all sales figures in euro currency, regardless of the client’s reporting location
· Include a new measure named AD Sales that calculates average daily sales for a selected month
· Support near real-time reporting while maintaining good performance for multidimensional queries
· Support reports that show currency exchange rates
· Deliver executive reports that are parameterized and rendered from report snapshots

In addition, cube objects must use terms familiar to users from around the world. For example, in the Sales Regions hierarchy, users from Great Britain must see
the State level presented as County when browsing the Sales cube.
The Sales cube must support a new measure group named Sales Planning. The measure group must consist of a single measure named Sales Plan that enables
the management team to use Excel 2010 to enter sales plans for future monitoring.

Technical Requirements

The BI system must meet the following technical requirements:
· Architecture requirements
o The system must use separate servers for each of the following components:

SQL Server Database Engine

SQL Server Integration Services

SQL Server Analysis Services in multidimensional mode SharePoint Server with the Reporting Services Add-in o All servers must be installed using U.S. regional settings.

o The system must source currency exchange rate data from a database hosted in Windows Azure SQL Databases.

· Security requirements

o When possible, the system must use Windows authentication for all database connections.

o The system must prevent users from querying data from outside of their region.

o The system must allow certain users to query data from multiple regions.

· Development requirements

o When browsing the Products hierarchy, repeating values for different levels of a given drill-path must be avoided. For example, Papers -> Copy Paper -> Copy Paper -> Copy Paper should appear simply as Papers -> Copy Paper.

o The system must support report snapshots. The default maximum number of retained snapshots must not exceed five.
QUESTION 1
You need to configure per-user security authentication for reporting against the Sales cube.
What should you do? (Each correct answer presents part of the complete solution. Choose all that apply.)
A. Install PowerPivot.
B. Create Service Principal Names (SPNs).
C. Configure account delegation.
D. Set up the Unattended Service Account.
Correct Answer: AB Section: [none] Explanation
Explanation/Reference:
* From scenario:
/ Administrative staff from around the world will produce sales reports with Microsoft Excel 2010 based on the Sales cube.
/ Security requirements

When possible, the system must use Windows authentication for all database connections.
The system must prevent users from querying data from outside of their region. The system must allow certain users to query data from multiple regions.
B: To use Kerberos authentication with SQL Server requires both the following conditions to be true:
The client and server computers must be part of the same Windows domain, or in trusted domains.
A Service Principal Name (SPN) must be registered with Active Directory, which assumes the role of the Key Distribution Center in a Windows domain. The SPN,
after it is registered, maps to the Windows account that started the SQL Server instance service. If the SPN registration has not been performed or fails, the
Windows security layer cannot determine the account associated with the SPN, and Kerberos authentication will not be used.

QUESTION 2
You need to configure the partition storage settings to support the reporting requirements. Which partition storage setting should you use?
A. DirectQuery
B. In-Memory
C. MOLAP
D. Low-latency MOLAP
E. Scheduled MOLAP
F. High-latency MOLAP
Correct Answer: D Section: [none] Explanation
Explanation/Reference:
QUESTION 3
You need to develop the executive reports.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

A. Remove default values from all parameters.
B. Implement dataset query parameters to filter data.
C. Set the data source to use Windows authentication.
D. Set the data source to use stored Windows credentials.
E. Provide default values for all parameters.
F. Implement dataset filters to filter data.
Correct Answer: BDE Section: [none] Explanation
Explanation/Reference:

* From scenario:
Deliver executive reports that are parameterized and rendered from report snapshots

BD: The data source that the shared dataset is based on has Prompt or Windows Integrated credentials.

QUESTION 4
You need to modify the Sales Regions hierarchy to meet the reporting requirements. Which S5A5 feature should you use?
A. Calculation
B. Translation
C. Action
D. Perspective
Correct Answer: B Section: [none] Explanation
Explanation/Reference:
QUESTION 5
You need to configure SSRS to meet the maximum number of snapshots requirement. What should you do? (Each answer presents a complete solution. Choose all that apply.)
A. In SharePoint Central Administration, set the System Snapshot Limit option to 5.
B. In Reporting Services Configuration Manager, set the System Snapshot Limit option to 5.
C. For each report, set the Limit number of snapshots option to 5.
D. Use PowerShell to set the System Snapshot Limit option to 5. Correct Answer: AC
Section: [none] Explanation
Explanation/Reference:
A: Reporting Services Service Applications are managed from SharePoint Central Administration. The Management and Properties pages allow you to update the configuration of the service application as well as common administration tasks.
Note:
*
From scenario: The system must support report snapshots. The default maximum number of retained snapshots must not exceed five.
*
System Snapshot Limit
Default is -1, which is no limit.
Set a site-wide default value for the number of copies of report history to retain. The default value provides an initial setting that establishes the number of
snapshots that can be stored for each report. You can specify different limits in property pages for specific reports.

Not B: Use the Reporting Services Configuration Manager to configure a Reporting Services Native Mode installation. If you installed a report server by using the files-only installation option, you must use this tool to configure the server before you can use it. If you installed a report server by using the default configuration installation option, you can use this tool to verify or modify the settings that were specified during setup.
Not D: SQL Server 2012 supports Windows PowerShell, which is a powerful scripting shell that lets administrators and developers automate server administration and application deployment.
QUESTION 6
You need to configure per-user security authentication for reporting against the Sales cube.
What should you do? (Each correct answer presents part of the complete solution. Choose all that apply.)
A. Create Service Principal Names (SPNs).
B. Configure account delegation.
C. Enable forms-based authentication.
D. Enable mixed-mode authentication.
Correct Answer: AD Section: [none] Explanation
Explanation/Reference:
* From scenario:
/ Administrative staff from around the world will produce sales reports with Microsoft Excel 2010 based on the Sales cube.
/ Security requirements

When possible, the system must use Windows authentication for all database connections.
The system must prevent users from querying data from outside of their region.
The system must allow certain users to query data from multiple regions.

A: To use Kerberos authentication with SQL Server requires both the following conditions to be true:
The client and server computers must be part of the same Windows domain, or in trusted domains.
A Service Principal Name (SPN) must be registered with Active Directory, which assumes the role of the Key Distribution Center in a Windows domain. The SPN,
after it is registered, maps to the Windows account that started the SQL Server instance service. If the SPN registration has not been performed or fails, the
Windows security layer cannot determine the account associated with the SPN, and Kerberos authentication will not be used.

D: For windows authentication we need to enable mixed-mode authentication

QUESTION 7
You need to modify the Sales cube to support the planning requirements. Which SSA5 feature should you use?
A. At KPI
B. A translation
C. A writeback partition
D. A perspective
Correct Answer: C Section: [none] Explanation
Explanation/Reference:
QUESTION 8
You need to configure the UserRegions role.
Which Multidimensional Expressions (MDX) function should you use?

A. ANCESTOR ( )
B. USERNAME ( )

C. FIRSTSIBLING ( )
D. LEAD ( )
E. COUSIN ( )
Correct Answer: B Section: [none] Explanation
Explanation/Reference:
QUESTION 9
You need to configure the partition storage settings to support the reporting requirements.
Which partition storage setting should you use?
A. Low-latency MOLAP
B. In-Memory
C. High-latency MOLAP
D. Regular
E. DirectQuery
F. LazyAggregations
Correct Answer: A Section: [none] Explanation
Explanation/Reference:
QUESTION 10
You need to develop an SSRS report that retrieves currency exchange rate data.
How should you configure the data source for the report?
A. Use the Windows Azure SQL Database data source type and then set Windows authentication for the credentials.
B. Use the Windows Azure SQL Database data source type and then set a username and password for the credentials.
C. Use the SQL Server data source type and then set a username and password for the credentials.
D. Use the SQL Server data source type and then set Windows authentication for the credentials.
Correct Answer: B Section: [none] Explanation
Explanation/Reference:
QUESTION 11
You need to optimize the Regions dimension.
How should you configure the attribute relationships? (To answer, drag the appropriate attribute from the list of attributes to the correct location in the hierarchy relationship. Use only attributes that apply.)
Select and Place:

Correct Answer: Section: [none] Explanation

Explanation/Reference: Question Set 1
QUESTION 1
You are developing a multidimensional project that includes a dimension named Organization. The dimension is based on the DimOrganization table in the data warehouse. The following diagram illustrates the table design.

The Organization dimension includes a parent-child hierarchy named Organizations.
The dimension includes the following dimension attributes:
· Organization, which is a key attribute

· Organizations, which defines the parent-child hierarchy
· Currency Code, which is a regular attribute
When users browse the dimension, three hierarchies are visible to them.
You need to ensure that the Organization hierarchy is not visible to users.
What should you do?

A. Set the AttributeHierarchyDisplayFolder property to Null for the Organization attribute.
B. Delete the Organization attribute.
C. Set the AttributeHierarchyEnabled property to False for the Organization attribute.
D. Set the AttributeHierarchyVisible property to False for the Organization attribute.
Correct Answer: D Section: [none] Explanation
Explanation/Reference:
QUESTION 2

You are conducting a design review of a multidimensional project. In the geography dimension, all non-key attributes relate directly to the key attribute. The
underlying data of the geography dimension supports relationships between attributes.
You need to increase query and dimension processing performance.
What should you do?

A. For the geography dimension, set the ProcessingMode property to LazyAggregations
B. For the dimension attributes of the geography dimension, define appropriate attribute relationships.
C. For the geography dimension, set the ProcessingPriority property to 1.
D. For the dimension attributes of the geography dimension, set the GroupingBehavior property to EncourageGrouping.
Correct Answer: B Section: [none] Explanation
Explanation/Reference:
QUESTION 3

You are developing a BI Semantic Model (BISM) that will be used to analyze complex budgeting and forecast data sourced from a financial database. The model

will be deployed to a server with 28 GB of RAM.
The source data, located in a SQL Server data warehouse, is currently using 15 terabytes of disk space and is doubling in size every month. The model will be
queried by staff in the accounting department by using Microsoft Excel 2010.

You need to ensure the highest query performance and scalability for the accounting department queries. Which project type should you choose?
A. Tabular project that uses the In-Memory query mode
B. Tabular project that uses the DirectQuery query mode
C. Multidimensional project
D. PowerPivot workbook deployed to SharePoint
Correct Answer: C Section: [none]
Explanation Explanation/Reference:
QUESTION 4
You are developing a BI Semantic Model (BISM) that retrieves data from several sources including a SQL Azure database and an OData data feed. The model will
be deployed to a server with significantly more memory than the total size of the source data.

You have the data feed URL, which you will use when developing the model in SQL Server Data Tools (SSDT).
The model must meet the following requirements:
· Maximize performance
· Data latency of up to one month is acceptable

You need to choose a project type and a data access mode to meet the requirements.

What should you do?

A. Select the tabular project type and use the In-Memory query mode.
B. Select the multidimensional project type and use the MOLAP storage mode.
C. Select the tabular project type and use the DirectQuery query mode.
D. Select the multidimensional project type and use the ROLAP storage mode.
Correct Answer: A Section: [none] Explanation
Explanation/Reference:
QUESTION 5
You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains several dimensions, a local measure group, and a linked measure group.
Both measure groups use MOLAP partitions.
You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable What-If Analysis.
What should you do before the partition can be write-enabled?

A. Implement the linked measure group as a local measure group.
B. Implement the local measure group as a linked measure group.
C. Set the Type property of the partition’s measure group to Forecast.
D. Set the StorageMode property of the linked measure group to Rolap.
Correct Answer: A Section: [none] Explanation
Explanation/Reference:
QUESTION 6
You are developing a SQL Server Analysis Services (SSAS) cube for the accounts department. You create a measure group named Exchange Rate that consists 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.

A. AverageOfChildren
B. ByAccount
C. Count
D. DistinctCount
E. FirstChild
F. FirstNonEmpty
G. LastChild
H. LastNonEmpty
I. Max
J. Min
K. None
L. Sum
Correct Answer: A
Section: [none]
Explanation

Explanation/Reference:

Explanation: AverageOfChildren
Specifies average of leaf descendants in time. Average does not count an empty value as 0.

QUESTION 7

You are developing a SQL Server Analysis Services (SSAS) cube for the sales department at your company.
The sales department requires the following set of metrics:
Unique count of customers
Unique count of products sold
Sum of sales

You need to ensure that the cube meets the requirements while optimizing query response time.

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

A. Use the Define Semiadditive Behavior page to enable semi-additive behavior.
B. Use ROLAP storage for all partitions.
C. Use the Define Semiadditive Behavior page to disable semi-additive behavior.
D. Use the Distinct Count and Sum measure aggregation functions.
E. Place the distinct count measures in separate measure groups.
F. Create a single measure group containing all measures
Correct Answer: AE Section: [none] Explanation
Explanation/Reference:
A: Semiadditive Function
Select the aggregation function for the selected measure. The aggregate functions available include DistinctCount, Aggregated using the DistinctCount function.
E (not D, Not F): Typically, the best performance occurs when each distinct count measure is in its own measure group, and that measure group has the same
dimensionality as the initial measure group.

QUESTION 8
You are developing a BI Semantic Model (BISM) based on 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.)

A. a tabular project that uses the DirectQuery query mode
B. a tabular project that uses the In-Memory query mode
C. a multidimensional project that uses the ROLAP storage mode
D. a PowerPivot workbook that is deployed to Microsoft SharePoint Server 2010
E. a multidimensional project that uses the MOLAP storage mode
Correct Answer: ABE Section: [none] Explanation
Explanation/Reference:
Power View is a thin web client that launches right in the browser from a data model in SharePoint Server 2010. The model can be a PowerPivot model workbook or a tabular model running on a SQL Server 2012 Analysis Services (SSAS) server.
QUESTION 9
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?
A. Create a new measure group for the Total Quantity On Hand measure. Configure the storage mode for the new measure group’s partition to ROLAP.
B. Create an XMLA script that will process the cube and then use SQL Server Agent to execute the script continuously.
C. Change the storage mode of the partition to use proactive caching with minimum latency.
D. Create a new measure group for the Average Quantity On Hand measure. Configure the storage mode for the new measure group’s partition to ROLAP.
Correct Answer: A Section: [none] Explanation Explanation/Reference:
QUESTION 10

You are modifying a SQL Server Analysis Services (SSAS) cube. Users of the cube report that the precision for the SalesAmount measure is four digits.
You need to ensure that the SalesAmount measure stores values to two digits of precision.
What should you do?

A. Add a named query in the data source view that casts the data source column to two digits of precision. Bind the SalesAmount measure to the new query.
B. Use the MeasureExpression measure property to change the precision of SalesAmount to two digits.
C. Add a named calculation in the data source view that casts the data source column to two digits of precision. Bind the SalesAmount measure to the new column.
D. Use the FormatString measure property to format SalesAmount as Currency.
E. Use the FormatString measure property to format SalesAmount as #,##0.00;-#,##0.00.
Correct Answer: C Section: [none] Explanation
Explanation/Reference:
QUESTION 11
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?

A. Add a custom action to the Price text box.
B. Set the SortExpression property to =Fields!Price.Value for the Price text box.
C. In the Expression dialog box for the Price text box, enter the =SortBy FieldslPrice.Value expression.
D. Set the SortExpression value to =Fields!Price.Description for the Price text box.
Correct Answer: B Section: [none] Explanation
Explanation/Reference:
QUESTION 12
You are designing a SQL Server Reporting Services (SSRS) report. The report defines a single SQL Server data source and dataset. You need to include additional data sourced from a SQL Azure database in the report.
What should you do?
A. Create a SQL Azure dataset that uses the existing data source.
B. Create a SQL Azure data source and then add a dataset that uses the new data source.
C. Create a SQL Server data source and then add a dataset that uses the new data source.
D. Generate an Atom-compliant data feed for the report.
Correct Answer: B Section: [none] Explanation
Explanation/Reference:
QUESTION 13
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 schedule until the email server is brought back online.
What should you do?

A. In SharePoint Central Administration, delete the shared schedule.
B. In Report Manager, pause the shared schedule.
C. In Report Manager, delete the shared schedule.
D. In SharePoint Central Administration, pause the shared schedule.
Correct Answer: D Section: [none]
Explanation Explanation/Reference:
QUESTION 14
You are designing a SQL Server Reporting Services (SSRS) report to display product names and their year-to-date (YTD) sales quantity YTD sales quantity values
are classified in three bands:
High Sales, Medium Sales, and Low Sales.

You add a table to the report. Then you define two columns based on the fields named ProductName and YTDSalesQuantity.

You need to set the color of the product text to red, yellow, or blue, depending on the value of the YTD sales quantity values.
What should you do?

A. Use an expression for the TextDecoration property of the text box.
B. Use an expression for the Style property of the text box.
C. Add an indicator to the table.
D. Use an expression for the Font property of the text box.
E. Use an expression for the Color property of the text box.
Correct Answer: E Section: [none] Explanation
Explanation/Reference:
QUESTION 15
You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A role named Folder Access Controller is present on the server.
The Folder Access Controller role consists of only the Set security for individual items task. When role members open Report Manager, they cannot view folders.
You need to modify the Folder Access Controller role so that the role members can view folders.
Which task should you add to the Folder Access Controller role?

A. Manage data sources
B. Manage folders
C. View models
D. View reports
Correct Answer: B Section: [none] Explanation
Explanation/Reference:
QUESTION 16
You are designing a SQL Server Reporting Services (SSRS) report for a bank. The bank has Automated Teller Machines (ATMs) in several regions. ATM operational data is stored in a SQL Azure database.
The report must use a map to display the location and status of the ATMs as shown in the following exhibit. (Click the Exhibit button.)

You need to ensure that the report displays only a user selected map region. Which source of spatial data should you use for the map?
A. SQL Server spatial query
B. Bing Maps layer
C. ESRI shape file
D. Map gallery
Correct Answer: A Section: [none]
Explanation Explanation/Reference:
QUESTION 17
You are creating a new report in SQL Server Report Builder. You add a SQL Azure data source. Then you add a dataset that has four fields named Year, Country, Category, and Sales.
You must design a matrix as shown in the following diagram.

The category rows (the first three rows as shown in the diagram) must present total sales amount by category. The country rows (the next six rows as shown in the
diagram) must present total sales amount by country. The total row must present the total sales for each year.
You add a matrix to the report. You add a grouping of the Category field on the rows and a grouping of the Year field on the columns.
You need to add the countries on the rows of the matrix.
Which Row Group option should you select when you add the group?

A. Adjacent Below
B. Parent Group
C. Adjacent Above
D. Child Group
Correct Answer: A Section: [none] Explanation
Explanation/Reference:
QUESTION 18

A multinational retailer has retail locations on several continents. A single SQL Server Reporting Services (SSRS) instance is used for global reporting.

A SQL Server Analysis Services (SSAS) instance for each continent hosts a multidimensional database named RetailSales. Each RetailSales database stores data
only for the continent in which it resides. All of the SSAS instances are configured identically. The cube names and objects are identical.
Reports must meet the following requirements:

· A report parameter named ServerName must be defined in each report. · When running a report, users must be prompted to select a server instance. · The
report data source must use the Microsoft SQL Server Analysis Services data source type.
You need to create a data source to meet the requirements.
How should you define the expression that is assigned to the connection string property of the data source?

A. =”Server=” &Parameters!ServerName.Value& “;Initial Catalog=RevenueData”
B. =”Data Source=” &Parameters!ServerName.Value& “;Initial Catalog=RevenueData”
C. =”Server=” & Parameters!ServerName.Value
D. =”Data Source=@ServerName;Initial Catalog=RevenueData”
E. =”Server=@ServerName;Initial Catalog=RevenueData”
Correct Answer: B Section: [none] Explanation
Explanation/Reference:
QUESTION 19
You install SQL Server Reporting Services (SSRS).
You need to restore a copy of the symmetric key. Which command should you run?
A. rskeymgmt d
B. rskeymgmt a f %temp%\rs.key p Password1
C. rskeymgmt e f %temp%\rs. key p Password1
D. rskeymgmt i
Correct Answer: B Section: [none] Explanation
Explanation/Reference:
QUESTION 20
You are working with a SQL Server Reporting Services (SSRS) instance in native mode. An item role named Reports Writer is present on the server.
The Reports Writer role cannot view and modify report caching parameters.
You need to ensure that the Reports Writer role can view and modify report caching parameters.
What should you do?

A. Add the Manage individual subscriptions task to the Reports Writer role.
B. Add the Manage report history task to the Reports Writer role.
C. Add the View data sources task to the Reports Writer role.
D. Add the Manage all subscriptions task to the Reports Writer role.
Correct Answer: B Section: [none] Explanation
Explanation/Reference:

latest Microsoft 70-466 exam is one of popular Certification.Many candidates won’t have confidence to get latest Microsoft 70-466 . Now We guaranteed latest Microsoft 70-466 exam training is available in various formats to best suit your needs and learning style.Whether you are a hands-on tactile learner,visually or even a textbook training veteran,Flydumps has latest Microsoft 70-466 resources that will enable you to pass your Microsoft 70-466 test with flying colors. As with Cisco exams, the Microsoft 70-466 exam is structured to stack or plug into other related courses.The combination of Microsoft 70-466 courses builds the complete core knowledge base you need to meet your Microsoft 70-466 certification requirements.