Microsoft 70-467 - Designing Business Intelligence Solutions with Microsoft SQL Server 2012 Exam
Page: 3 / 36
Total 176 questions
Question #11 (Topic: Topic 1)
You need to grant appropriate permissions to the SSISOwners SQL Server login.
What should you do?
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: D
Question #12 (Topic: Topic 1)
You need to create the calculation for SalespersonName.
What should you do? (Each correct answer presents a complete solution. Choose all that
apply.)
What should you do? (Each correct answer presents a complete solution. Choose all that
apply.)
A. Create a computed column in the data warehouse's DimSalesperson table. Include the column in the Sales Reporting model's Salesperson table.
B. Modify the data warehouse's DimSalesperson table and add a new column. Use an UPDATE statement to populate the new column with values. Update the SSIS package developed to populate the data warehouse's DimSalesperson table to use a Derived Column transformation to produce the calculation.
C. Configure the Sales Reporting model's Salesperson table properties to be based on a query. Define a derived column in the query.
D. Add a calculated column to the Sales Reporting model's Salesperson table by using the Data Analysis Expressions (DAX) language CONCATENATE function.
E. Create a view in the data warehouse that defines a derived column based on the DimSalesperson table. Base the Sales Reporting model's Salesperson table on the view. Include the column in the Sales Reporting model's Salesperson table.
F. Add a calculated column to the Sales Reporting model's Salesperson table by using the Data Analysis Expressions (DAX) language ADDCOLUMNS function.
Answer: B,E
Question #13 (Topic: Topic 1)
You need to complete the following UPDATE statement to initialize the budget sales values
for 2012.
Which MDX weight value expression should you use?
To answer, drag the appropriate weight value expression to the answer area.
[Microsoft-70-467-11.0/Microsoft-70-467-16_2.png]
for 2012.
Which MDX weight value expression should you use?
To answer, drag the appropriate weight value expression to the answer area.
[Microsoft-70-467-11.0/Microsoft-70-467-16_2.png]
Answer: [Microsoft-70-467-11.0/Microsoft-70-467-17_2.png]
Question #14 (Topic: Topic 2)
You need to re-establish subscriptions on SSRS01.
What should you do?
What should you do?
A. Manually failover the active node.
B. Install prerequisites and upgrade shared components on Node1 and Node2.
C. Generate a SQL Server 2012 configuration file by running the SQL Server Setup executable.
D. Upgrade Node1 by using the SQL Server 2012 Upgrade wizard.
Answer: A
Question #15 (Topic: Topic 2)
You need to design the recovery strategy for SSRS01.
What should the strategy include? (Each correct answer presents part of the solution.
Choose all that apply.)
What should the strategy include? (Each correct answer presents part of the solution.
Choose all that apply.)
A. Re-create the SQL Server Agent jobs that are used to trigger schedules.
B. Restore the ReportServer and ReportServerTempDB databases with recovery.
C. Restore the ReportServer and ReportServerTempDB databases with no recovery.
D. Restore the msdb database.
E. Restore the Report Server encryption key.
F. Restore the database encryption key.
Answer: A,B,E
