Microsoft 70-470 - Recertification for MCSE: Business Intelligence Exam
Page: 2 / 64
Total 316 questions
Question #6 (Topic: Topic 1)
You need to identify the reports that produce the errors that Marc is receiving.
What should you do?
What should you do?
A. Write a query by using the Subscriptions table in the report server database.
B. Use the Windows Event Viewer to search the Application log for errors.
C. Write a query by using the ExecutionLog3 view in the report server database.
D. Search the ReportServerService_<timestamp>.log file for errors.
Answer: C
Question #7 (Topic: Topic 1)
You need to create the sales territory and product measures.
Which aggregate function should you use for both measures?
Which aggregate function should you use for both measures?
A. COUNT (DISTINCT column_name)
B. Distinct Count
C. Distinct
D. Count
Answer: B
Question #8 (Topic: Topic 1)
You need to ascertain why Marc did not receive his reports.
What should you do?
What should you do?
A. Search the ReportServerService_<timestamp>.log file for errors.
B. Search the registry for errors.
C. Use the Windows Event Viewer to search the Application log for errors.
D. Use SQL Server Management Studio to search the SQL Server logs for errors.
Answer: B
Question #9 (Topic: Topic 1)
You need to create the hierarchy in the AdhocReports project in time for the next
production release cycle.
What should you do?
production release cycle.
What should you do?
A. Multi-select all of the columns, right-click the columns, and then click the Create Hierarchy command. Check in the changes before the next release cycle.
B. Use the RELATED() function to consolidate the columns in the DimSalesTerritory table, multi-select the columns, right-click the columns, and then click the Create Hierarchy command. Check in the changes before the next release cycle.
C. Use the RELATEDTABLEQ function to consolidate the tables, multi-select the columns in the hierarchy, right-click the columns, and then click the Create Hierarchy command. Check in the changes before the next release cycle.
D. Use the RELATED() function to consolidate the columns in the DimEmployee table, multi-select the columns, right-click the columns, and then click the Create Hierarchy command. Check in the changes before the next release cycle.
Answer: D
Question #10 (Topic: Topic 1)
You need to configure the SSRS data source.
What should you do?
A. Store the credentials.
B. In the data source configuration window, select the Prompt for credentials option.
C. Create a .NET form to enable users to enter their credentials.
D. Configure Kerberos authentication.
What should you do?
A. Store the credentials.
B. In the data source configuration window, select the Prompt for credentials option.
C. Create a .NET form to enable users to enter their credentials.
D. Configure Kerberos authentication.
Answer: A
Topic 2, Contoso Ltd
Background
You are the business intelligence (BI) solutions architect for Contoso Ltd, a multinational
sales company with offices in London, Madrid, Paris, Brisbane, Tokyo, and New York.
Contoso sells office consumable products such as pens, printer ink, and paper.
You produce solutions by using SQL Server 2012 Business Intelligence Edition and
Microsoft SharePoint Server 2010 Enterprise Edition with SP1.
Technical Background
Contoso's products are categorized by using four levels while some use only two or three
levels. Products are categorized as shown in the following table.
[Microsoft-70-470-5.0/Microsoft-70-470-13_2.png]
Contoso sells products through mobile sales staff, direct marketing, and its website. Sales
personnel are located in various regions around the world, and each region has a sales
manager who is paid a quarterly bonus based on the total sales in the region during the
quarter. Regions are categorized as shown in the following table.
[Microsoft-70-470-5.0/Microsoft-70-470-14_2.png]
SQL Server Analysis Services (SSAS) is used to host a multidimensional database. The
database contains a single cube named Sales and three database dimensions named
Products, Regions, and Date. A single measure named Sales Total has been defined in the
cube. The data source for the database is a SQL Server data warehouse.
The Products dimension contains a single user-defined hierarchy named Products. To
prevent the display of empty members when users browse the Products dimension, the
Extract, Transform, and Load (ETL) process populates all missing values as shown in the
following diagram.
[Microsoft-70-470-5.0/Microsoft-70-470-14_3.png]
The structure of the Products hierarchy is shown in the following diagram.
[Microsoft-70-470-5.0/Microsoft-70-470-14_4.png]
The Regions dimension contains a single user-defined hierarchy named Sales Regions.
The dimension is based on a single dimension table in the data warehouse and t
