Microsoft 70-467 - Designing Business Intelligence Solutions with Microsoft SQL Server 2012 Exam
Page: 2 / 36
Total 176 questions
Question #6 (Topic: Topic 1)
You need to configure the attribute relationship types for the Salesperson dimension.
Which configuration should you use?
To answer, drag the appropriate pair of attributes and attribute relationships from the list to
the correct location or locations in the answer area. (Answer choices may be used once,
more than once, or not all.)
[Microsoft-70-467-11.0/Microsoft-70-467-12_2.png]
Which configuration should you use?
To answer, drag the appropriate pair of attributes and attribute relationships from the list to
the correct location or locations in the answer area. (Answer choices may be used once,
more than once, or not all.)
[Microsoft-70-467-11.0/Microsoft-70-467-12_2.png]
Answer: [Microsoft-70-467-11.0/Microsoft-70-467-12_3.png]
Question #7 (Topic: Topic 1)
You need to fix the PowerPivot data refresh problem by using the least amount of
administrative effort.
What should you do?
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 and select 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 #8 (Topic: Topic 1)
You need to create the Sales Reporting shared SSRS data source.
Which SSRS data connection type should you use?
Which SSRS data connection type should you use?
A. OData
B. Microsoft SQL Server
C. ODBC
D. OLE DB
Answer: B
Question #9 (Topic: Topic 1)
You need to configure data refresh for the Manufacturing Performance PowerPivot
workbook.
What should you do? (Each correct answer presents part of the solution. Choose ail that
apply.)
workbook.
What should you do? (Each correct answer presents part of the solution. Choose ail that
apply.)
A. Configure the PowerPivot Data Refresh Timer Job to run every 60 minutes.
B. Restore the PowerPivot workbook to an SSAS instance in tabular mode.
C. Script a process command and configure a SQL Server Agent job to execute the command every 60 minutes.
D. Restore the PowerPivot workbook to an SSAS instance in PowerPivot for SharePoint mode.
Answer: A
Question #10 (Topic: Topic 1)
You need to select an appropriate tool for creating the Regional Sales report.
Which tool or tools should you use? (Each correct answer presents a complete solution.
Choose all that apply.)
Which tool or tools should you use? (Each correct answer presents a complete solution.
Choose all that apply.)
A. Excel 2010, using the CUBE functions
B. Power View, using a Matrix
C. Excel 2010, using a PivotTable
D. Report Builder, using a Matrix
Answer: B,C,D
