Q1. - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to grant permission for salespersons to be able 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. Create a member and then create a Data Analysis Expressions (DAX) filter.
C. Create a role and then create a Multidimensional Expressions (MDX) filter.
D. Create a role and then create a Data Analysis Expressions (DAX) filter.
Answer: C
Q2. DRAG DROP - (Topic 4)
You have a single SQL Server 2008 R2 Analysis Services (SSAS) instance. You are planning to upgrade the instance to SQL Server 2014.
You need to import an existing PowerPivot workbook to create a tabular project.
Which three 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.)
Answer:
Q3. DRAG DROP - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) cube.
You need to add a calculated member to the Customer dimension to evaluate the sum of values for the United Kingdom and the United States.
Which expression should you use? (To answer, drag the appropriate expression to the answer area.)
Answer:
Q4. - (Topic 2)
You need to configure the partition storage settings to support the reporting requirements.
Which partition storage setting should you use?
A. High-latency MOLAP
B. In-Memory
C. Low-latency MOLAP
D. DirectQuery
E. LazyAggregations
F. Regular
Answer: C
Q5. - (Topic 4)
Topic 4, Mix Questions
You are developing a SQL Server Analysis Services (SSAS) tabular project. The model includes a table named Sales. The Sales table includes a single date column.
The Sales table must meet the following requirements:
. Queries must be able to return all rows. . Must be able to support four different processing schedules for different date ranges. . Date ranges must not include any overlapping data.
You need to implement a solution that meets the requirements.
What should you do?
A. Create four partitions for the Sales table. Create four roles. Use the same row filter queries for each role and partition.
B. Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for all four tables.
C. Create four partitions for the Sales table. Use row filter queries for each partition.
D. Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for each of the four tables.
Answer: C
Q6. - (Topic 3)
You need to deploy the StandardReports project at the end of the current business day.
What should you do? (Each correct answer presents a complete solution. Choose all that apply.)
A. Use the Analysis Services Deployment utility to create an XMLA deployment script and run it at the end of the day.
B. Use the Analysis Services Deployment wizard to create an MDX deployment script and run it at the end of the day.
C. Use the Analysis Services Deployment wizard to create an XMLA deployment script and run it at the end of the day.
D. Deploy the project from SQL Server Data Tools (SSDT) at the end of the day.
Answer: C,D
Q7. - (Topic 4)
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 cube as a local cube.
B. Ensure that the measure group measures only use semiadditive aggregation functions.
C. Implement the linked measure group as a local measure group.
D. Ensure that the measure group measures only use nonadditive aggregation functions
Answer: C
Q8. - (Topic 4)
You are working with a SQL Server Reporting Services (SSRS) instance in native mode. An item role named Developer is present on the server.
The Developer role cannot view and modify report caching parameters.
You need to ensure that the Developer role can view and modify report caching
parameters.
Which task should you add to the Developer role?
A. Manage individual subscriptions
B. View data sources
C. Manage report history
D. Manage all subscriptions
Answer: C
Q9. - (Topic 4)
A production SQL Server Analysis Services (SSAS) cube is processed daily. The users query products by using a hierarchy named Products from a dimension named Product.
The DimProduct table in the data source view is used as the source of the Product dimension. The table has the following structure.
...
The Product dimension has three attribute hierarchies:
Product
Subcategory
Category
The attributes have the following relationships defined: Product > Subcategory > Category. Each attribute has a key and a name sourced from the related key and name columns in the DimProduct table.
During processing, you receive the following error message: 'Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_DimProduct', Column: 'SubCategoryKey1, Value: "23'. The attribute is Subcategory'."
You verify that the data is accurate.
You need to ensure that the dimension processes successfully.
What should you do?
A. Delete the Products hierarchy.
B. Relate the Subcategory and Category attributes directly to the Product attribute.
C. Remove the duplicate data from the DimProduct table.
D. Remove the Subcategory attribute.
Answer: B
Q10. - (Topic 3)
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 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.
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 and create a KPI based on the measure. Then set the target value. Check in the changes before the next release cycle.
D. 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.
Answer: C