Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
Q1. HOTSPOT - (Topic 9)
A company maintains separate environments for test, production, and quality assurance. The company uses the project deployment model for SQL Server Integration Services (SSIS) deployments.
You create an SSIS project to perform a weekly refresh of the company's data warehouse and cubes. The project has three packages.
You need to configure the project to ensure so that the test and production teams can run each package without manually adding server-specific information.
Which program should you use?
To answer, select the appropriate program in the answer area.
Answer:
156. - (Topic 9)
...
You are designing a self-service reporting solution based on published PowerPivot workbooks.
The reporting solution must allow users to perform the following tasks:
Easily create reports.
Create report queries by dragging and dropping fields.
Create presentation-quality reports with minimal effort.
You need to choose a reporting tool that meets the requirements.
Which reporting tool should you choose? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Report Builder
B. Report Designer
C. Power View
D. Microsoft Excel
Q2. - (Topic 9)
You administer a SQL Server Reporting Services (SSRS) instance in native mode.
You need to assign a predefined role that meets the following requirements:
. Members of the role must be able to update shared data sources.
. Members of the role must not be able to consume reports or manage
subscriptions.
. The role must provide only the minimum permissions required.
Which role should you assign? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. The Content Manager role
B. The Read and Process role
C. The Publisher role
D. The Browser role
Answer: C
Q3. - (Topic 10)
You are designing a SQL Server Reporting Services (SSRS) report. The report defines a single SQL Server data source and dataset.
You need to include additional data sourced from a SQL Azure database in the report.
What should you do?
A. Create a SQL Azure dataset that uses the existing data source.
B. Create a SQL Azure data source and then add a dataset that uses the new data source.
C. Create a SQL Server data source and then add a dataset that uses the new data source.
D. Generate an Atom-compliant data feed for the report.
Answer: B
Q4. - (Topic 10)
You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to grant the minimum permissions necessary to enable users to query data in a tabular model.
Which role permission should you use?
A. Browser
B. ReadDefinition
C. Read
D. Process
E. Explorer
F. Select
Answer: C
Q5. - (Topic 6)
You need to select the appropriate model type for the Finance database. Which model type should you select?
A. Star schema
B. Multidimensional
C. Relational
D. Tabular with PowerPivot
Answer: B
Q6. - (Topic 8)
You are deploying the Research model.
You need to ensure that the data contained in the model can be refreshed.
What should you do?
A. Import MarketResearch.xlsx to a new tabular database on the Tabular instance.
B. Assign the Tabular instance service account permissions to the MarketResearch.xlsx network location.
C. Create a SQL Server Integration Services (SSIS) package that imports data from MarketResearch.xlsx nightly. Load the data to CUBE1.
D. Upload MarketResearch.xlsx to Library1.
Answer: B
Q7. - (Topic 10)
You are administrating a SQL Server Analysis Services (SSAS) tabular database.
You need to create a new role that allows its members to query data and to refresh data in the model.
Which permission should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Read and Process
B. Explore and Manage
C. Browse And Manage
D. Administrator
Answer: A
Q8. - (Topic 9)
An existing cube dimension that has 30 attribute hierarchies is performing very poorly. You have the following requirements:
. Implement drill-down browsing. . Reduce the number of attribute hierarchies but ensure that the information contained within them is available to users on demand. . Optimize performance.
You need to redesign the cube dimension to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. set the AggregateFunction property to Sum on all measures. Use the SCOPE statement in a Multidimensional Expressions (MDX) calculation to tune the aggregation types.
B. Set the AttributeHierarchyOptimizedState property to FullyOptimized on the attribute hierarchies.
C. Create user-defined hierarchies. For the attributes sourced by the levels of the user-defined hierarchies, set the RelationshipType property to Rigid. Run incremental processing.
D. Remove as many attribute hierarchies as possible from the dimension. Reintroduce the information in the attribute hierarchies as properties. Implement natural hierarchies and set the AttributeHierarchyVisible property to False for attributes used as levels in the natural
hierarchies.
Answer: D
Q9. - (Topic 10)
You manage a SQL Server Reporting Services (SSRS) instance.
An application must pass credentials to the local security authority for Reporting Services.
You need to configure Reporting Services to issue a challenge/response when a
connection is made without credentials.
Which authentication type should you configure in the RSReportServer.config file?
A. RSWindowsNTLM
B. RSWindowsBasic
C. RSWindowsKerberos
D. RSWindowsNegotiate
Answer: B
Q10. DRAG DROP - (Topic 9)
You are creating a SQL Server Integration Services (SSIS) package to populate a fact table from a source table. The fact table and source table are located in a SQL Azure database. The source table has a price field and a tax field. The OLE DB source uses the data access mode of Table.
You have the following requirements:
. The fact table must populate a column named TotalCost that computes the sum of the price and tax columns. . Before the sum is calculated, any records that have a price of zero must be discarded.
You need to create the SSIS package in SQL Server Data Tools.
In what sequence should you order four of the listed components for the data flow task? (To answer, move the appropriate components from the list of components to the answer area and arrange them in the correct order.)
Answer:
Q11. - (Topic 10)
You develop a SQL Server Analysis Services (SSAS) tabular project. The tabular model loads data from a SQL Server 2012 relational database each day.
You define a connection.
You need to ensure that the connection minimizes the attack surface area of the server.
How should you define the impersonation information for the connection? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Use the credentials of the SQL Server Analysis Services (SSAS) service account. Grant least privilege to this account in the source database.
B. Use your domain credentials. Grant least privilege to your account in the source database.
C. Create and use a new Windows domain account. Grant least privilege to this account in the source database.
D. Use SQL Server authentication.
Answer: C
Q12. - (Topic 7)
You need to develop the tabular project to support the date analysis requirements.
What should you do?
A.
.
Create one date table named Date.
.
Create an active relationship between the DateKey column of the Date table and the OrderDateKey column of the Sales table.
.
Create an inactive relationship between the DateKey column of the Date table and the ShipDateKey column of the Sales table.
B.
.
Create two date tables, one named Order Date and one named Ship Date.
.
Create an active relationship between the DateKey column of the Order Date table and the OrderDateKey column of the Sales table.
.
Create an inactive relationship between the DateKey column of the Ship Date table and the ShipDateKey column of the Sales table.
C.
.
Create one date table named Date.
.
Create an active relationship between the DateKey column of the Date table and the ShipDateKey column of the Sales table.
.
Create an inactive relationship between the DateKey column of the Date table and the OrderDateKey column of the Sales table.
D.
.
Create two date tables, one named Order Date and one named Ship Date.
.
Create an active relationship between the DateKey column of the Order Date table and the OrderDateKey column of the Sales table.
.
Create an active relationship between the DateKey column of the Ship Date table and the ShipDateKey column of the Sales table.
Answer: C
Q13. HOTSPOT - (Topic 10)
You are developing a SQL Server Analysis Services (SSAS) cube.
You are writing the following Multidimensional Expressions (MDX) statement for use by a calculated measure. The measure computes the sales amount for the same time period of the previous year. (Line numbers are included for reference only.)
You need to complete the MDX statement.
Which MDX function should you use in line 03? To answer, select the appropriate MDX function in the functions list.
Answer:
Q14. DRAG DROP - (Topic 10)
You are developing a SQL Server Analysis Services (SAS) multidimensional project that is configured to source data from a SQL Azure database.
You plan to use multiple servers to process different partitions simultaneously. You create and configure a new data source.
You need to create a new partition and configure SQL Server Analysis Services (SSAS) to use a remote server to process data contained within the partition.
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:
Q15. - (Topic 2)
You need to modify the Sales Regions hierarchy to meet the reporting requirements.
Which S5A5 feature should you use?
A. Calculation
B. Translation
C. Action
D. Perspective
Answer: B
Q16. - (Topic 10)
You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains several dimensions, a local measure group, and a linked measure group. Both measure groups use MOLAP partitions.
You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable What-If Analysis.
What should you do before the partition can be write-enabled?
A. Implement the linked measure group as a local measure group.
B. Implement the local measure group as a linked measure group.
C. Set the Type property of the partition's measure group to Forecast.
D. Set the StorageMode property of the linked measure group to Rolap.
Answer: A