Q1. - (Topic 4) 

You are developing a Microsoft SQL Analysis Services (SSAS) multidimensional project 

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? 

A. Use role playing dimensions. 

B. Use the Business Intelligence Wizard to define dimension intelligence. 

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

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

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

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

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

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

I. Create several dimensions. Add each dimension to the cube. 

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

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

L. 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. 

M. 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. 

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 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. 

View Answer

Q2. - (Topic 4) 

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

The data warehouse has a table named FactStock that is used to track movements of stock. A column namedMovementQuantity contains quantities of stock. A positive quantity is used for input and negative quantity is used for output. A column named Movement Date is related to the time dimension. The quantity in stock, at a given point in time, can be evaluated as the sum of all MovementQuantity values at that point in time. 

You need to create a measure that calculates the quantity in stock value. 

What should you do? 

A. Use role playing dimensions. 

B. Use the Business Intelligence Wizard to define dimension intelligence. 

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

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

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

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

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

H. Create several dimensions. Add each dimension to the cube. 

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

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

K. 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. 

L. 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. 

M. 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. 

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 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. 

View Answer

Q3. DRAG DROP - (Topic 4) 

You manage a SQL Server Reporting Services (SSRS) instance in native mode. You are building a shared dataset for your weekly performance reports. The shared dataset uses a data source that is configured to use credentials that are stored in the Report Server. 

You have a predefined shared schedule to perform cleanup and maintenance tasks for SSRS. 

You need to enable caching on the shared dataset. You also need to use an existing shared schedule to discard the cache. 

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.) 

View Answer

Q4. - (Topic 4) 

You are developing a SQL Server Reporting Services (SSRS) report. The report includes a dataset with fields named. 

Year MonthNumber, and RegCount. The report includes a table that displays the number of recorded registration occurrences per year,as shown in the following table. 

You need to modify the table to include a graphical item displaying the monthly registration trend to the right of the Reg Count column. 

What should you do? 

A. Add an Indicator item to a new column on the right of the Reg Count column. Select the Directional Indicator Type and then assign the MonthNumber field to the Start property. 

B. Add an Indicator item to a new column on the right of the Reg Count column. Select the Directional Indicator Type and then select the MonthNumber field for Value. 

C. Add a Sparkline item to a new column on the right of the Reg Count column. Then select the RegCount field for Values and the MonthNumber field for Series Groups. 

D. Add a text box to a new column on the right of the Reg Count column. Then use a Go to report action to link to a separate report showing the monthly trend. 

E. Add a Sparkline item to a new column on the right of the Reg Count column. Then select the RegCount field for Values and the MonthNumber field for Category Groups. 

View Answer

Q5. - (Topic 4) 

You are administrating a SQL Server Analysis Services (SSAS) tabular database. 

You need to create a new role that allows its members to query data and to refresh data in the model. 

Which permission should you use? (More than one answer choice may achieve the goal. Select the BEST answer.) 

A. Browse and Manage 

B. Administrator 

C. Read and Process 

D. Explore and Manage 

View Answer

Q6. - (Topic 4) 

You are developing a SQL Server Reporting Services (SSRS) report. The report includes a dataset with fields namedYear Month Number, and InvCount. The report includes a table that displays the inventory count per year, as shown in the followingtable. 

You need to modify the table to include a graphical item displaying the inventory count trend to the right of the Inv Count column. 

What should you do? 

A. Add an Indicator item to a new column on the right of the Inv Count column. Select the Directional Indicator type and then assign the MonthNumber field to the Start property. 

B. Add a Sparkline item to a new column on the right of the Inv Count column. Then select the InvCount field for Values and the MonthNumber field for Series Groups. 

C. Add a Sparkline item to a new column on the right of the Inv Count column. Then select the InvCount field for Values and the MonthNumber field for Category Groups. 

D. Add a text box to a new column on the right of the Inv Count column. Then use a Go to report action to link to a separate report showing the monthly trend. 

E. Add an Indicator item to a new column on the right of the Inv Count column. Select the Directional Indicator type and then select the MonthNumber field for Value. 

View Answer

Q7. - (Topic 4) 

You are designing a SQL Server Analysis Services (SSAS) cube for the sales department at your company. 

The sales department has the following requirements for the cube: 

. Include a year-over-year (YOY) calculation 

. Include a month-over-month (MOM) calculation 

You need to ensure that the calculations are implemented in the cube. 

Which Multidimensional Expressions (MDX) function should you use? 

A. UNREGINTERCEPT() 

B. LASTPER1ODS() 

C. TIMQNTELUGENCE() 

D. PARALLELPERIOD() 

View Answer

Q8. - (Topic 4) 

You are managing a SQL Server Reporting Services (SSRS) instance. 

A website must pass credentials to the local security authority for Reporting Services. 

You need to configure Reporting Services to issue a challenge/response when a 

connection is made without credentials. 

Which authentication type should you configure in the RSReportServer.config file? 

A. RSWindowsKerberos only 

B. RSWindowsKerberos and RSWindowsNTLM 

C. RSWindowsBasic 

D. RSWindowsKerberos and RSWindowsNegotiate 

View Answer

Q9. - (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? 

A. Register the assembly on the SSAS server instance. 

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

C. Register the assembly on the SSAS server by using regedit.exe. 

D. Register the assembly on the SharePoint server by using regeditexe. 

View Answer

Q10. - (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? 

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

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

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

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

View Answer