Q1. DRAG DROP - (Topic 4)
You are planning the installation of PowerPivot for SharePoint.
You install SharePoint Server 2010 Enterprise Edition with Service Pack 1.
You need to install the PowerPivot for SharePoint instance. Then you need to configure the
Default Account username used to provision shared services in the SharePoint farm. 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:
Q2. - (Topic 4)
You are developing a SQL Server Reporting Services (SSRS) sales summary report.
The report header consists of several images. Report users require PDF exports of the report with no bulky images of the report header.
You need to ensure that the header of the report is hidden when a user exports the report to PDF format.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Set the Hidden property of the report header to (GlobalslRenderFormat.Name = "PDF").
B. Set the Hidden property of the report header to (GlobalslRenderFormat.IsInteractive = False).
C. Set the Hidden property of the report header to FALSE.
D. Set the Hidden property of the report header to TRUE.
Answer: D
Q3. - (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.
Answer: B
Q4. - (Topic 4)
You are modifying a SQL Server Analysis Services (SSAS) cube. The cube consists of a single measure group that contains the following measures:
. Total Quantity On Hand
. Average Quantity On Hand
The measure group has a single partition that uses the MOLAP storage mode.
You need to modify the cube design to ensure that the Total Quantity On Hand measure is updated in real-time and that Average Quantity On Hand measure is updated hourly.
What should you do?
A. Create a new measure group for the Total Quantity On Hand measure. Configure the storage mode for the new measure group's partition to ROLAP.
B. Create a drillthrough action that will query the underlying data source in real time for the Total Quantity On Hand measure.
C. Change the storage mode of the partition to ROLAP.
D. Add an additional MOLAP partition to the measure group.
Answer: A
Q5. HOTSPOT - (Topic 4)
You are designing a dimension named Employee for a SQL Server Analysis Services
multidimensional project.
The Employee dimension contains a DateOfBirth attribute and a MaritalStatus attribute.
You need to minimize the amount of time required to process the cube.
What should you do? To answer, select the appropriate relationship type for each attribute
in the answer area.
Answer:
114. DRAG DROP - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to add a calculated column to a table in the model.
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.)
Q6. DRAG DROP - (Topic 4)
You have a database named DB1. DB1 contains four tables named FactSales, DimTime, DimCustomer, and DimEmployee. A sample from DimEmployee is shown in the following table.
A sample from DimCustomer is shown in the following table.
A sample from FactSales is shown in the following table.
You need to identify which type of dimension must be created for each table.
Which type of dimension should you create for each table? To answer, drag the appropriate dimensions to the correct tables. Each dimension may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.
Answer:
Q7. - (Topic 4)
...
You are managing a SQL Server Analysis Services (SSAS) tabular database.
The database must meet the following requirements:
The processing must load data into partitions or tables.
The processing must not rebuild hierarchies or relationships.
The processing must not recalculate calculated columns.
You need to implement a processing strategy for the database to meet the requirements.
Which processing mode should you use?
A. Process Clear
B. Process Data
C. Process Add
D. Process Full
E. Process Default
Answer: C
Q8. HOTSPOT - (Topic 4)
A SQL Server Analysis Services (SSAS) cube has roles to define dimension data security. A role named USA allows users to browse data pertaining to the United States. A role named Canada allows users to browse data pertaining to Canada.
A user can browse sales data pertaining to the United States but cannot browse sales data pertaining to Canada. You validate that the user belongs to the USA and Canada roles.
You need to reproduce the issue in SQL Server Management Studio (SSMS).
Which option should you select? To answer, select the appropriate action in the answer area.
Answer:
Q9. - (Topic 4)
You are developing a multidimensional project that includes a dimension named Organization. The dimension is based on the DimOrganization table in the data warehouse. The following diagram illustrates the table design.
The Organization dimension includes a parent-child hierarchy named Organizations. The dimension includes the following dimension attributes:
Organization, which is a key attribute
Organizations, which defines the parent-child hierarchy
Currency Code, which is a regular attribute
...
. PercentageOfOwnership, which is a regular attribute
When users browse the dimension, four hierarchies are visible to them.
You need to ensure that the Organization and PercentageOfOwnership hierarchies are not visible to users.
What should you do?
A. Set the AttributeHierarchyVisible property to False for the Organization and PercentageOfOwnership attributes.
B. Set the AttributeHierarchyEnabled property to False for the Organization and PercentageOfOwnership attributes.
C. Delete the Organization and the PercentageOfOwnership attributes.
D. Set the AttributHierarchyDisplayFolder property to Null for the Organization and PercentageOfOwnership attributes.
Answer: A
Explanation: the value of the AttributeHierarchyVisible property determines whether the attribute hierarchy is visible independent of its use in a user-defined hierarchy
Q10. - (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