Q1. - (Topic 4)
You are developing a SQL Server Reporting Services (SSRS) sales summary report.
The report header consists of several images.
You need to ensure that the header of the report is hidden when a user exports the report to PDF format.
Which Hidden property expression should you use for the report header? {More than one answer choice may achieve the goal. Select the BEST answer.)
A. =(GlobalsIRenderFormat.IsInteractive = False)
B. = (Globals!RenderFormat.Name = "PDF")
C. =False
D. =True
Answer: B
Q2. - (Topic 4)
You are working with a SQL Server Reporting Services (SSRS) instance in native mode. An item role named Reports Writer is present on the server.
The Reports Writer role cannot view and modify report caching parameters.
You need to ensure that the Reports Writer role can view and modify report caching parameters.
What should you do?
A. Add the Manage all subscriptions task to the Reports Writer role.
B. Add the Manage report history task to the Reports Writer role.
C. Add the View data sources task to the Reports Writer role.
D. Add the Manage individual subscriptions task to the Reports Writer role.
Answer: B
Explanation: http://msdn.microsoft.com/en-us/library/ms157363.aspx Manage report history Create, view, and delete report history, view report history properties, and view and modify settings that determine snapshot history limits and how caching works.
Q3. - (Topic 4)
You are deploying an update to a SQL Server Analysis Services (SSAS) cube to a production environment.
The production database has been configured with security roles.
You need to preserve the existing security roles in the production database. Database roles and their user accounts from the development environment must not be deployed to the production server.
Which deployment method should you use?
A. Use the SQL Server Analysis Services Deployment Wizard.
B. Backup and restore the database.
C. Use the SQL Server Analysis Services Migration Wizard.
D. Deploy the project from SQL Server Data Tools to the production server.
Answer: A
Q4. - (Topic 4)
You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server Data Tools (SSDT).
The report must define a report parameter to prompt the user for the business unit. Each business unit has a unique color scheme combination of foreground and background colors.
You need to ensure that all of the text boxes in the table headers use the correct business unit colors.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Add one report variable for Color. Assign it with an expression to return the appropriate colors. For each header text box, set the Color and BackgroundColor properties by using the variable.
B. Add two report variables named Color and BackgroundColor. Assign them with expressions to return the appropriate colors. For each header text box, use expressions to set the Color and BackgroundColor properties by using the variables.
C. For each header text box, assign expressions to the Color and BackgroundColor properties.
D. Add two Microsoft Visual C# functions to the code block of the report to implement Color and BackgroundColor functions. For each header text box, use expressions to set the Color and BackgroundColor properties by using the functions.
Answer: D
Q5. - (Topic 1)
You need to modify the environment before you create the QuarterSales report.
What should you do?
A. Add a date table to the model that contains columns for the fiscal and calendar quarters.
B. Add a date table to the model that contains measures for the fiscal and calendar quarters.
C. Configure a time dimension by using the Time Intelligence Wizard.
D. Configure SSAS to use a server time dimension.
Answer: C
Q6. - (Topic 4)
You are developing a BI Semantic Model (BISM) that retrieves data from several sources including a Microsoft Azure SQL Database database and an OData data feed. The model will be deployed to a server with significantly more memory than the total size of the source data.
You have the data feed URL, which you will use when developing the model in SQL Server Data Tools (SSDT).
The model must meet the following requirements:
. Maximize performance
. Data latency of up to one month is acceptable
You need to choose a project type and a data access mode to meet the requirements.
What should you do?
A. Select the multidimensional project type and use the ROLAP storage mode.
B. Select the tabular project type and use the In-Memory query mode.
C. Select the tabular project type and use the DirectQuery query mode.
D. Select the multidimensional project type and use the MOLAP storage mode.
Answer: B
Q7. DRAG DROP - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) multidimensional project.
You identify that a dimension, which has a large number of attributes, is issuing a separate (SELECT DISTINCT) query for each attribute even though they all come from a single database table. The table does not have a large number of rows.
You need to configure the processing of the dimension to issue only a single SQL query to the underlying database, and processing must continue if any errors are encountered.
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:
Q8. - (Topic 1)
You need to ensure that all reports meet the reporting requirements.
What is the best way to achieve the goal? More than one answer choice may achieve the goal. Select theBEST answer.
A. Create a report part. Publish the report part to a server that has SSRS installed. Add the report part to each new report that is created.
B. Create a report part. Publish the report part to a SharePoint site. Add the report part to each new report that is created.
C. Create a report. Copy the report to source code control. Create each new report by using the report template in source code control.
D. Create a report. Copy the report to the PrivateAssemblies\ProjectItems\ReportProject folder in the Visual Studio directory. Create each new report by using the locally stored report
Answer: D
Q9. - (Topic 4)
You are developing a SQL Server PowerPivot workbook that sources data from a Microsoft Azure SQL Database database. The PowerPivot model includes a single table named FactSales that consists of four columns named Year, Country, Product and Revenue. The model includes the following two measures.
. Sales:=SUM(FactSales[Revenue])
. Sales %:=[Sales] / CALCULATE([Sales], ALL(FactSales))
In Microsoft Excel 2010 you create the following PivotTable report.
Users report that the Sales % measure computes an incorrect ratio. The measure should
meet a requirement to compute a ratio over all visible sales values defined by the query filters. The Grand Total value for the Sales % measure should equal 100%.
You need to fix the Sales % measure to meet the requirement.
Which Data Analysis Expressions (DAX) expression should you use?
A. = [Sales] / CALCULATE([Sales])
B. = [sales] / [Sales](ALLSELECTED(FactSales))
C. = [sales] / CALCULATE([Sales], VALUES(FactSales[Year]), VALUES(FactSales[Country]))
D. = [sales] / [Sales](ALLEXCEPT(FactSales, FactSales[Year]))
Answer: B
Q10. HOTSPOT - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) cube.
Revenue must be compared to a goal and described by a status and a trend. Revenue,
goal, status, and trend will be defined by Multidimensional Expressions (MDX) expressions.
You need to add the Revenue measure.
Which tab should you select? (To answer, select the appropriate tab in the answer area.)
Answer: