Prep and try our 70-460 valid and latest training questions & answers

DRAG DROP
You need to configure the attribute relationship types for the Salesperson dimension.
Which configuration should you use?
To answer, drag the appropriate pair of attributes and attribute relationships from the list to the correct location or locations in the answer area. (Answer choices may be used once, more than once, or not all.)

You need to select the appropriate storage settings for the cube. Which settings should you choose?

• A. relational OLAP (ROLAP) with proactive caching enabled
• B. hybrid OLAP (HOLAP) with proactive caching disabled
• C. multidimensional OLAP (MOLAP) with proactive caching enabled and a rebuild interval of 24 hours
• D. hybrid OLAP (HOLAP) with proactive caching enabled

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 designing a SQL Server Analysis Services (SSAS) cube.
You need to create a measure to count unique customers.
What should you do?

• A. Add a measure group that has one measure that uses the DistinctCount aggregate function.
• B. Add a measure that uses the DistinctCount aggregate function to an existing 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. Use role playing dimensions.
• F. Create several dimensions. Add each dimension to the cube.
• G. Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
• H. 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.
• I. Create a dimension with one attribute hierarchy. Set the IsAggrcgatable property to False and then set the DefaultMember property. Use a regular relationship between the dimension and measure group.
• J. 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.
• K. Add a measure that uses the Count aggregate function to an existing measure group.
• L. Use the Business Intelligence Wizard to define dimension intelligence.
• M. 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.
• N. 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.
• O. Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.

You are modifying a star schema data mart that feeds order data from a Microsoft Azure SQL Database database into a SQL Server Analysis Services (SSAS) cube. The data mart contains two large tables that include flags and indicators for some orders. There are 100 different flag columns, each with 10 different indicator values. Some flags reuse indicators. The tables both have a granularity that matches the fact table.
You have the following requirements:
- Allow users to slice data by all flags and indicators. - Modify the date dimension table to include a surrogate key of a numeric data type and add the surrogate key to the fact table. - Use the most efficient design strategy for cube processing and queries.
You need to modify the schema.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Define the surrogate key as a BIGINT data type. Create a single fact dimension in each table for its flags and indicators.
• B. Define the surrogate key as an INT data type. Create a single fact dimension in each table for its flags and indicators.
• C. Define the surrogate key as an INT data type. Combine the distinct flag/indicator combinations into a single dimension.
• D. Define the surrogate key as a BIGINT data type. Combine the distinct flag/indicator combinations into a single dimension.

You need to define the trend calculation for the sales performance KPI. Which KPI trend MDX expression should you use?

• A. Option A
• B. Option B
• C. Option D
• D. Option C