070-460 무료 덤프문제 온라인 액세스

You are developing a SQL Server Analysis Services (SSAS) tabular project for a Power View solution.
You need to grant permission for salespersons to view only the data based on their sales territory.
What should you do?

• A.Create a member and then create a Multidimensional Expressions (MDX) filter.
• B.Use SQL Server Management Studio to create a role. Then create a Multidimensional Expressions (MDX) filter.
• C.Use SQL Server Management Studio to create a role. Then create a Data Analysis Expressions (DAX) filter.
• D.Create a member and then create a Data Analysis Expressions (DAX) filter.

HOTSPOT
You are designing a dimension named Employee for a SQL Server Analysis Services
multidimensional project.
The Employee dimension contains a DateOfBirth attribute and a MaritalStatus attribute.
You need to minimize the amount of time required to process the cube.
What should you do? To answer, select the appropriate relationship type for each attribute
in the answer area.

정답:

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.Use role playing dimensions.
• B.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.
• C.Create a dimension. Then add a cube dimension and link it several times to the measure group.
• D.Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
• E.Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
• F.Create several dimensions. Add each dimension to the cube.
• G.Add a measure group that has one measure that uses the DistinctCount aggregate function.
• H.Use the Business Intelligence Wizard to define dimension intelligence.
• I.Add a measure that uses the LastNonEmpty aggregate function. Use a regular relationship between the time dimension and the measure group.
• J.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.
• K.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.
• L.Add a measure that uses the DistinctCount aggregate function to an existing measure group.
• M.Add a measure that uses the Count aggregate function to an existing measure group.
• N.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.
• O.Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.

You execute the SalesbyCategory report and receive the following error message: "Members, types, or sets must use the same hierarchies in the function."
You need to ensure that the query executes successfully.
Which two actions should you perform? Each correct answer presents part of the solution.

• A.Move the Measures clause on line 02 to axis 1.
• B.Move the Date clause from line 10 to line 08.
• C.Move the Product clause from line 08 to line 10.
• D.Move the Date and Product clauses on line 11 to axis

You need to perform the pre-upgrade database backup operation by using SQL Server Management Studio (SSMS).
How should you configure the backup options?

• A.Clear the Apply compression check box. Clear the Encrypt backup file check box.
• B.Select the Apply compression check box. Clear the Encrypt backup file check box.
• C.Clear the Apply compression check box. Select the Encrypt backup file check box and supply a password.
• D.Select the Apply compression check box. Select the Encrypt backup file check box and supply a password.