Q1. - (Topic 10) 

You are developing a BI Semantic Model (BISM) that will be used to analyze complex budgeting and forecast data sourced from a financial database. The model will be deployed to a server with 28 GB of RAM. 

The source data, located in a SQL Server data warehouse, is currently using 15 terabytes of disk space and is doubling in size every month. The model will be queried by staff in the accounting department by using Microsoft Excel 2010. 

You need to ensure the highest query performance and scalability for the accounting department queries. 

Which project type should you choose? 

A. Tabular project that uses the In-Memory query mode 

B. Tabular project that uses the DirectQuery query mode 

C. Multidimensional project 

D. PowerPivot workbook deployed to SharePoint 

View Answer

Q2. - (Topic 5) 

You need to implement security in the cube to limit the sites visible to each user. 

What should you do? 

A. Create an SSAS database role in the cube for each user and assign the sites each user can access to his or her database role. 

B. Create an SSAS server role for each user and assign the sites each user can access to his or her server role. 

C. Create an SSAS database role and define a Multidimensional Expressions (MDX) calculation to implement dynamic dimension security. 

D. Create a view on the SalesTransactions table that uses the SecurityFilter and User table data to limit the sites for each user. 

View Answer

Q3. - (Topic 10) 

You are developing a SQL Server Reporting Services (SSRS) report. The report includes a dataset with fields named Year, MonthNumber, and InvCount. The report includes a table that displays the inventory count per year, as shown in the following diagram. 

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 select the MonthNumber field for Value. 

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

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

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

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

View Answer

Q4. - (Topic 6) 

You need to select and configure a tool for the monitoring solution. What should you choose? 

A. Performance Monitor configured with the MSAS11:Storage Engine Query counter 

B. Performance Monitor configured with the MSAS11:Processing counter 

C. SQL Server Profiler configured with the Query Processing: Query Subcube event 

D. SQL Server Profiler configured with the Queries Events: Query Begin event 

View Answer

Q5. - (Topic 9) 

You have a data warehouse named DW1. 

An OLAP cube named Cube1 uses DW1 as its data source. Cube1 uses the MOLAP 

storage mode. 

You create a SQL Server Integration Services (SSIS) package that updates DW1, and then processes Cube1. The package executes each day at 06:00. 

You need to configure the storage settings of Cube1. The solution must ensure that aggregation processing is reduced as much as possible during cube querying. 

What is the best storage setting you should you use for Cube1? More than one answer choice may achieve the goal. Select the BEST answer. 

A. Medium-latency MOLAP 

B. Scheduled MOLAP 

C. Low-latency MOLAP 

D. Automatic MOLAP 

View Answer

Q6. DRAG DROP - (Topic 10) 

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

Q7. - (Topic 10) 

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

A model contains tables and columns that must not be visible to the user. The columns and tables cannot be removed because they are used in calculations. 

You need to hide the tables and columns. 

What should you do? 

A. Right-click the applicable tables and columns and select the Hide option. 

B. in the Properties window for the applicable tables and columns, set the Enabled property to False. 

C. in the Properties window for the applicable tables and columns, set the Visible property to True. 

D. Right-click the applicable tables and columns and select the Hide from Client Tools option. 

View Answer

Q8. - (Topic 3) 

You need to configure data refresh for the Manufacturing Performance PowerPivot workbook. 

What should you do? (Each correct answer presents part of the solution. Choose ail that apply.) 

A. Configure the PowerPivot Data Refresh Timer Job to run every 60 minutes. 

B. Restore the PowerPivot workbook to an SSAS instance in tabular mode. 

C. Script a process command and configure a SQL Server Agent job to execute the command every 60 minutes. 

D. Restore the PowerPivot workbook to an SSAS instance in PowerPivot for SharePoint mode. 

View Answer

Q9. HOTSPOT - (Topic 9) 

You are setting role permissions for a SQL Server Analysis Service (SSAS) cube. 

You plan to grant Read access for specific attribute members only to specific Active Directory security groups. 

You need to enter a Multidimensional Expressions (MDX) expression to configure the attribute member access. 

On which tab should you enter the MDX expression? To answer, select the appropriate tab in the answer area. 

View Answer

Q10. DRAG DROP - (Topic 7) 

You need to implement the requirements for the StageFactSales package. 

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