Q1. - (Topic 8)
You need to configure Library1 to support the planned self-service reports.
What is the best configuration you should add to Library1? More than one answer choice may achieve the goal. Select the BEST answer.
A. The Report Builder report content type
B. The PowerPivot Gallery Document content type
C. The Report Builder Model content type
D. The Report content type
Answer: A
Q2. - (Topic 10)
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 custom action to the Price text box.
B. Set the SortExpression property to =Fields!Price.Value for the Price text box.
C. In the Expression dialog box for the Price text box, enter the =SortBy FieldslPrice.Value expression.
D. Set the SortExpression value to =Fields!Price.Description for the Price text box.
Answer: B
Q3. DRAG DROP - (Topic 10)
You manage a SQL Server Reporting Services (SSRS) instance running in native mode.
You are troubleshooting a performance problem and need to know which reports are frequently executed. You discover that the report server execution logs are empty, despite significant report activity.
You need to ensure that the server is configured for report execution logging.
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:
Q4. HOTSPOT - (Topic 9)
You are designing aggregations for a SQL Server Analysis Services (SSAS) cube. You need to ensure that every aggregation excludes the Category attribute. Which option should you select?
To answer, select the appropriate option in the answer area.
Answer:
Q5. DRAG DROP - (Topic 7)
You are creating the Australian postal code query.
Which arguments should you use to complete the query?
To answer, drag the appropriate arguments to the correct location or locations in the
answer area. (Use only arguments that apply.)
Answer:
Q6. - (Topic 5)
You need to scale out SSAS.
What should you do?
A. Back up the cube on ServerB and restore it on ServerC each day.
B. Create an empty cube on ServerC and link to the objects in the cube on ServerB.
C. Process the cube on both ServerB and ServerC each day.
D. Synchronize the cube from ServerB to ServerC each day.
Answer: D
Q7. DRAG DROP - (Topic 9)
You have a business intelligence (BI) infrastructure.
You create a SQL Server Integration Services (SSIS) project that contains the packages for the BI infrastructure.
You need to automate the deployment of the SSIS project. The solution must ensure that the deployment can occur as part of an unattended Transact-SQL script.
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 8)
You need to recommend a partitioning strategy that meets the performance requirements for CUBE1.
What should you include in the recommendation?
A. Create separate measure groups for each distinct count measure.
B. Createone measure group for all distinct count measures.
C. Createa separate dimension for each distinct count attribute.
D. Createone dimension for all distinct count attributes.
Answer: A
91. - (Topic 8)
You need to recommend a SQL Server Integration Services (SSIS) package design that meets the ETL requirements.
What should you include in the recommendation?
A. Add new rows for changes to existing dimension members and enable inferred members.
B. Update non-key attributes in the dimension tables to use new values.
C. Update key attributes in the dimension tables to use new values.
D. Add new rows for changes to existing dimension members and disable inferred members.
Q9. - (Topic 9)
You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that includes several SSIS packages. Each SSIS package will define the same connection managers and variables.
You have the following requirements:
. Ensure that the deployment model supports changing the content of connection strings by using parameters at execution time. . Ensure that the deployment model automatically starts from calls to the
catalog.start_execution stored procedure in the SSISDB database.
. Maximize performance at execution time.
. Minimize development effort.
You need to design a solution that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Use a package deployment model. Use a SQL Server package configuration with a common filter. Change the contents of the SSIS Configurations table at runtime.
B. Use a project deployment model. Configure connections in an XML configuration file referenced by an environment variable that corresponds to the SQL Server environment of each SSIS package.
C. Use a package deployment model. Save each SSIS package to a file share that can be accessed from all environments.
D. Use a project deployment model. Modify connection manager properties to use project parameters. Ensure that the SSISDB database is created.
Answer: D
Q10. - (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