70-466 Exam
Breathing 70-466 Q&A Reviews & Tips
Proper study guides for Far out Microsoft Implementing Data Models and Reports with Microsoft SQL Server 2012 certified begins with Microsoft 70-466 preparation products which designed to deliver the Vivid 70-466 questions by making you pass the 70-466 test at your first time. Try the free 70-466 demo right now.
Q41. - (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
Q42. - (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
Q43. - (Topic 4)
You are modifying a SQL Server Analysis Services (SSAS) cube.
Users of the cube report that the precision for the TransactionCost measure is five digits.
You need to ensure that the TransactionCost measure stores values to two digits of precision.
What should you do?
A. Use the FormatString measure property to format TransactionCost as Currency.
B. Add a named calculation in the data source view that casts the data source column to two digits of precision. Bind the TransactionCost measure to the new column.
C. Add a named query in the data source view that casts the data source column to two digits of precision. Bind the TransactionCost measure to the new query.
D. Use the MeasureExpression measure property to change the precision of TransactionCost to two digits.
E. Use the FormatString measure property to format TransactionCost as #, ##0.00;-#,##0.00.
Answer: B
Q44. - (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.
Q45. DRAG DROP - (Topic 4)
You are developing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database and a SQL Server Analysis Services (SSAS) cube. The cube contains a date dimension and other dimensions. The report design includes two report parameters named StartDate and FinishDate as shown in the following diagram.
The Data Type property of the parameters is set to Date/Time.
You need to create the dataset based on the SSAS cube. You also need to ensure that the dataset is filtered by the existing report parameters.
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:
Q46. DRAG DROP - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) tabular project based on a Microsoft Azure SQL Database database. The ProcessingOption property for the project is set to Do Not Process.
Several calculated columns have been added to a table. The project has been deployed to the production server.
You need to ensure that newly added data is processed on the production server.
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:
Q47. - (Topic 4)
You install SQL Server Reporting Services (SSRS). You need to back up a copy of the symmetric key. Which command should you run?
A. rskeymgmt -a -f %temp%\rs.key -p Password1
B. rskeymgmt -d
C. rskeymgmt -i
D. rskeymgmt -e -f %temp%\rs.key -p Password1
Answer: D
Q48. - (Topic 1)
After you deploy the RegionalSales report, you attempt to configure the subscriptions.
You discover that the subscription creation screen does not display the option to deliver the report by email.
You need to ensure that subscriptions can be delivered by using email.
What should you do?
A. Modify the Rsmgrpolicy.config file.
B. From Central Administration, modify the SMTP settings of the SharePoint Server server farm.
C. Modify the Rssrvrpolicy.config file.
D. From Central Administration, modify the properties of the Reporting Service Application.
Answer: C
Q49. DRAG DROP - (Topic 2)
You need to optimize the Regions dimension.
How should you configure the attribute relationships? (To answer, drag the appropriate attribute from the list of attributes to the correct location in the hierarchy relationship. Use only attributes that apply.)
Answer:
Q50. - (Topic 4)
You are designing a SQL Server Reporting Services (SSRS) report based on a SQL Server Analysis Services (SSASJ cube.
The cube contains a Key Performance Indicator (KPI) to show if a salesperson's sales are off target slightly off target, or on target.
You need to add a report item that visually displays the KPI status value as a red, yellow, or green circle.
Which report item should you add?
A. Linear Gauge
B. Indicator
C. Data Bar
D. Radial Gauge
E. Sparkline
Answer: B