Online Access Free 70-466 Exam Questions

HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube that contains the data for a running team.
The data warehouse used by the cube contains the time durations of laps run by each runner on the team. The time durations are stored in seconds as an integer.
You need to build the following two measures in the cube:
* A measure named Measure1 that must contain the average time duration of the laps run by each runner.
* A measure named Measure2 that must contain the lap-time duration and the name of the runner who ran the fastest lap.
What should you do? To answer, select the appropriate Aggregation Function property for each measure in the answer area.

Correct Answer:

Explanation:

Note: For Measure1 we use Average, and for Measure2 Min to get the fastest time.

After you deploy the RegionalSales report, users report that they cannot see product data when they receive the reports by email.
You need to ensure that the sales department managers can see all of the data.
In the report, you update the Hidden property of each group.
What should you do next?

• A.When the report is initially run, select Show or hide based on an expression. Set the expression to = (Globals!RenderFormat.IsInteractive)
• B.When the report is initially run, select Hide.
• C.When the report is initially run, select Show.
• D.When the report is initially run, select Show or hide based on an expression. Set the expression to =NOT (Globals!RenderFormat.IsInteractive).

You are adding dimensions and a new measure group named Accounts Receivable to an existing SQL Server Analysis Services (SSAS) cube.
Date is one of the existing dimensions in the SSAS database. The underlying fact table for the measure group is associated with multiple dates, including InvoiceDate, DueDate and PaymentDate.
You need to ensure that users can slice the Accounts Receivable measures by InvoiceDate, DueDate, and PaymentDate. You also need to ensure that the time required to process the database is minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Create three new perspectives named InvoiceDate, DueDate, and PaymentDate.
• B.Create three independent dimensions named InvoiceDate, DueDate and PaymentDate and then link all three of them to the Accounts Receivable measure group.
• C.Add three attributes named InvoiceDate, DueDate, and PaymentDate to the existing Date dimension in the database.
• D.Create cube dimensions named InvoiceDate, DueDate, and PaymentDate by using the existing Date dimension in the database.

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A model contains tables and columns that must not be visible to the user. The columns and tables cannot be removed because they are used in calculations. The calculations are used to calculate the budget and forecast for the current quarter.
You need to hide the tables and columns.
What should you do?

• A.Before adding the forecast calculations to the model, right-click the applicable tables and columns and select the Hide option.
• B.After adding the budget calculations to the model, in the Properties window for the applicable tables and columns, set the Enabled property to False.
• C.After adding the budget calculations to the model, in the Properties window for the applicable tables and columns, set the Visible property to True.
• D.Before adding the forecast calculations to the model, right-click the applicable tables and columns and select the Hide from Client Tools option.

HOTSPOT
A sales cube contains two years of data.
The sales team must see year-over-year (YOY) and month-over-month (MOM) sales metrics.
You need to modify the cube to support the sales team's requirements.
Which Business Intelligence Wizard enhancements should you use? (To answer, configure the appropriate option or options in the dialog box in the answer area.)

Correct Answer: