cert24.com Microsoft 070-466 070-467 Preparation Materials exam training tools deliver you extensive training of all the key concepts and skills of exam curriculum. cert24.com 070-466 070-467 real exam make you prepare the questions same as the exam. Whats more, cert24.com practice exam questions are based on VUE testing centre features so to provide you every thing before you actually take your exam.
070-466 Implementing Data Models and Reports with Microsoft SQL Server 2012
QUESTION 1
You are working with a SQL Server Reporting Services (SSRS) instance in native mode.
An item role named Developer is present on the server.
The Developer role cannot view and modify report caching parameters.
You need to ensure that the Developer role can view and modify report caching parameters.
Which task should you add to the Developer role?
A. View data sources
B. Manage individual subscriptions
C. Manage all subscriptions
D. Manage report history
Answer: D
QUESTION 2
You are developing a SQL Server Reporting Services (SSRS) report that renders in HTML.
The report includes a dataset with fields named Description, Price, and Color.
The report layout includes a table that displays product details and also includes columns named Description, Price, and Color.
You need to modify the report so that users can sort products by the Price column.
What should you do?
A. Add a group for the Price field.
B. Add a custom action to the Price text box.
C. Set the SortExpression property to =Fields!Price.Name for the Price text box.
D. Set the SortExpression property to =Fields!Price.Value for the Price text box.
E. Set the SortExpression value to =Fields!Price.Description for the Price text box.
F. In the Expression dialog box for the Price text box, enter the =SortBy Fields!Price.Value expression.
G. On the Row Visibility dialog box, select the Display can be toggled by this report item check box. Then select the Price text box.
H. In the Interactive Sorting page of the Price text box properties, select the Enable interactive sorting on this text box check box, and then select the Price field for the Sort by property.
Answer: DH
QUESTION 3
You are developing a SQL Server Analysis Services (SSAS) tabular project.
The model includes a table named Sales.
The Sales table includes a single date column.
The Sales table must meet the following requirements:
- Queries must be able to return all rows.
- Must be able to support four different processing schedules for different date ranges.
- Date ranges must not include any overlapping data.
You need to implement a solution that meets the requirements.
What should you do?
A. Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for each of the four tables.
B. Create four partitions for the Sales table. Use row filter queries for each partition.
C. Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for all four tables.
D. Create four partitions for the Sales table. Create four roles. Use the same row filter queries for each role and partition.
Answer: B
070-467 Designing Business Intelligence Solutions with Microsoft SQL Server 2012
QUESTION NO: 1
You need to fix the PowerPivot data refresh problem by using the least amount of administrative effort.
What should you do?
A. Use the PowerPivot Configuration Tool and select the Upgrade Features, Services,
Applications and Solutions option.
B. Use the PowerPivot Configuration Tool and7s0e-4le6c7t the Configure or Repair PowerPivot for SharePoint option.
C. Reinstall SSAS in PowerPivot for SharePoint mode by using the SQL Server 2012 installation media.
D. In SharePoint Central Administration, create a target application and configure the PowerPivot service application settings to use the target application.
Answer: B
QUESTION NO: 2
You need to grant appropriate permissions to the SSISOwners SQL Server login.
What should you do?
A. Map the login to the SSISDB database. Assign the user to the ssis_admin role.
B. Map the login to the msdb database. Assign the user to the db_owner role.
C. Map the login to the msdb database. Assign the user to the db_ssisadmin role.
D. Map the login to the SSISDB database. Assign the user to the db_ssisadmin role.
E. Map the login to the SSISDB database. Assign the user to the db_owner role.
F. Map the login to the msdb database. Assign the user to the ssis_admin role.
Answer: E
QUESTION NO: 3
You need to configure the Scenario attribute to ensure that business users appropriately query the Sales Plan measure.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
A. Set the AttributeHierarchyVisible property to False.
B. Set the IsAggregatable property to False.
C. Set the Usage property to Parent.
D. set the DefaultMember property to the Forecast member.
E. Set the AttributeHierarchyEnabled property to False.
F. Set the RootMemberIf property to ParentIsMissing.
Answer: C,D
Give it a thought! You have nothing to lose in it.