Question No: 31 – (Topic 3)

You need to create the KPI in the AdhocReports project. What should you do?

Create a measure by using the SUM([OrderQuantity]) expression. Then use the CREATE KPI CURRENTCUBE statement to define the KPI and target value.

Create a measure by using the SUM([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value.

Create a measure by using the COUNT([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value.

Create a KPI based on the OrderQuantity column and then set the target value.

Answer: A

Question No: 32 – (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.)

Use the Analysis Services Deployment utility to create an XMLA deployment script and run it at the end of the day.

Use the Analysis Services Deployment wizard to create an MDX deployment script and run it at the end of the day.

Use the Analysis Services Deployment wizard to create an XMLA deployment script and run it at the end of the day.

Deploy the project from SQL Server Data Tools (SSDT) at the end of the day.

Answer: C,D

Question No: 33 – (Topic 3)

You need to deploy the StandardReports project.

What should you do? (Each correct answer presents a complete solution. Choose all that apply.)

Use the Analysis Services Deployment utility to create an XMLA deployment script.

Deploy the project from SQL Server Data Tools (SSDT).

Use the Analysis Services Deployment wizard to create an XMLA deployment script.

Use the Analysis Services Deployment wizard to create an MDX deployment script.

Answer: B,C

Question No: 34 – (Topic 3)

You need to configure the permissions for the sales team members in the Sales Reports library.

Which permissions should you use? (Each answer presents part of the solution. Choose all that apply.)

Delete Items

Add Items

View Items

Create Alerts

Manage Alerts

Edit Items

Answer: C,F

Question No: 35 DRAG DROP – (Topic 3)

You need to complete the design of the data warehouse.

Which design should you use? (To answer, drag the appropriate tables and relationships to the correct location in the answer area. Use only the tables and relationships that apply.)

Answer:

Explanation:

C:\Users\Kamran\Desktop\image.jpg

Topic 4, Mix Questions

Question No: 36 – (Topic 4)

You maintain a multidimensional Business Intelligence Semantic Model (BISM) that was developed with default settings.

The model has one cube and the cube has one measure group. The measure group is based on a very large fact table and is partitioned by month. The fact table is incrementally loaded each day with approximately 800,000 new rows.

You need to ensure that all rows are available in the cube while minimizing the processing time.

Which processing option should you use?

Process Index

Process Data

Process Add

Process Default

Process Clear

Process Full

Answer: C

Question No: 37 HOTSPOT – (Topic 4)

You are developing a SQL Server Analysis Services (SSAS) cube. You create a degenerate dimension.

You need to define a relationship type for the dimension.

Which relationship type should you select? (To answer, configure the appropriate option or options in the dialog box in the answer area.)

Answer:

Explanation:

C:\Users\Kamran\Desktop\02.png

Question No: 38 – (Topic 4)

You develop a SQL Server Analysis Services (SSAS) stored procedure.

You need to ensure that developers can create Multidimensional Expressions (MDX) calculations that use the stored procedure.

What should you do?

Register the assembly on the SSAS server instance.

Copy the assembly to the SSAS installation directory and register it by using the CREATE ASSEMBLY T-SQL command.

Question No: 39 – (Topic 4)

A fact table named FactHouseSales has a measure column named Area. All values in the column are stored in square feet. Users must be able to analyze the area in different units.

You create a table named AreaUnit. Each row in the table consists of the unit name and a square feet conversion factor value.

You need to implement the area conversion in the project. What should you do?

Use role playing dimensions.

Use the Business Intelligence Wizard to define dimension intelligence.

Add a measure that uses the Count aggregate function to an existing measure group.

Add a measure that uses the DistinctCount aggregate function to an existing measure group.

Add a measure that uses the LastNonEmpty aggregate function. Use a regular relationship between the time dimension and the measure group.

Add a measure group that has one measure that uses the DistinctCount aggregate function.

Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.

Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.

Create several dimensions. Add each dimension to the cube.

Create a dimension. Then add a cube dimension and link it several times to the measure group.

Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.

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.

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.

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.

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.

Answer: N

Question No: 40 – (Topic 4)

You are conducting a design review of a multidimensional project.

In the Customer Geography dimension, all non-key attributes relate directly to the key attribute.

The underlying data of the Customer Geography dimension supports relationships between attributes.

You need to increase query and dimension processing performance. What should you do?

For the dimension attributes of the Customer Geography dimension, define appropriate attribute relationships.

For the dimension attributes of the Customer Geography dimension, set the GroupingBehavior property to EncourageGrouping.

For the Customer Geography dimension, set the Processing Mode property to LazyAggregations.

For the Customer Geography dimension, set the ProcessingPriority property to 1.