Online Access Free 070-460 Practice Test

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.Place the distinct count measures in separate measure groups.
• B.Use the Count and Sum measure aggregation functions.
• C.Use the Distinct Count and Sum measure aggregation functions.
• D.Place the measures in a single measure group.
• E.Use the additive measure group functions.
• F.Use the semiadditive measure group functions.

Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.
You are creating a SQL Server Analysis Services (SSAS) multidimensional database.
Users need a time dimension for:
Dates
Delivery dates
Ship dates
---
You need to implement the minimum number of required SSAS objects.
What should you do?

• A.Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a regular relationship between the dimension and measure group.
• B.Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.
• C.Add a measure that uses the LastNonEmpty aggregate function. Use a regular relationship between the time dimension and the measure group.
• D.Create a new named calculation in the data source view to calculate a rolling sum. Add a measure that uses the Max aggregate function based on the named calculation.
• E.Use role playing dimensions.
• F.Create a dimension. Then add a cube dimension and link it several times to the measure group.
• G.Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.
• H.Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
• I.Use the Business Intelligence Wizard to define dimension intelligence.
• J.Create a dimension with one attribute hierarchy. Set the ValueColumn property, set the IsAggregatable property to False, and then set the DefaultMember property. Configure the cube dimension so that it does not have a relationship with the measure group. Add a calculated measure that uses the MemberValue attribute property.
• K.Add a measure group that has one measure that uses the DistinctCount aggregate function.
• L.Create several dimensions. Add each dimension to the cube.
• M.Add a measure that uses the Count aggregate function to an existing measure group.
• N.Add a measure that uses the DistinctCount aggregate function to an existing measure group.
• O.Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.

DRAG DROP
You are developing a SQL Server Reporting Services (SSRS) report to display a list of employees. The report will be embedded into a Microsoft SharePoint Server Web Part Page of the company intranet site.
The report consists of a single table. The design of the table is shown in the following diagram.

You need to configure the EmailAddress detail text box to create a new email message. The email message must be addressed to the email address that was clicked by the user.
Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Correct Answer:

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 tabular model.
Which role permission should you use?

• A.Explorer
• B.Read
• C.Select
• D.Browser
• E.Process
• F.Read Definition

You are developing a SQL Server Analysis Services (SSAS) tabular project.
The model includes a table named Dim Employee. The table contains employee details,
including the sales territory for each employee. The table also defines a column named EmployeeAlias which 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?

• A.Add a row filter that implements the LOOKUPVALUE and CUSTOMDATA functions.
• B.Add a row filter that implements only the USERNAME function.
• C.Add a row filter that implements only the CUSTOMDATA function.
• D.Add a row filter that implements the LOOKUPVALUE and USERNAME functions.