Q1. - (Topic 9)
Your network contains the following components:
...
Microsoft SharePoint Server 2010 SQL Server 2008 Service Pack 2 (SP2) SQL Server 2008 Service Pack 1 (SP1) in Reporting Services Native Mode
You need to recommend a solution to upgrade the network to SQL Server 2014. The solution must meet the following requirements:
..
Minimize the amount of time that SharePoint services are unavailable. Deploy the upgraded Reporting Services instance in Reporting Services SharePoint Integrated Mode.
You upgrade the Database Engine to SQL Server 2014.
Which three actions should you recommend performing next? Each correct answer presents part of the solution.
A. Install a SQL Server 2014 Reporting Services add-in for SharePoint on all of the front-end Web servers that have SharePoint Server installed.
B. Perform an in-place upgrade to SQL Server Reporting Services (SSRS) 2014.
C. Perform a SharePoint 2013 side-by-side upgrade.
D. Perform a SharePoint 2013 in-place upgrade.
E. Migrate legacy reports and application data.
F. Install a new instance of SQL Server Reporting Services (SSRS) 2014.
Answer: A,E,F
Q2. DRAG DROP - (Topic 10)
You are developing a SQL Server Analysis Services (SSAS) cube.
You need to reuse a measure group from a different database.
In SQL Server Data Tools (SSDT), 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:
Q3. - (Topic 1)
You need to create the hierarchy in the AdhocReports project in time for the next 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
Q4. 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:
Q5. DRAG DROP - (Topic 9)
You have a business intelligence (BI) infrastructure that contains three servers. The servers are configured as shown in the following table.
You need to recommend a health monitoring solution for the BI infrastructure.
The solution must meet the following requirements:
Monitor the status of the Usage Data Collection feature.
Monitor the number of end-users accessing the solution.
Monitor the amount of cache used when the users query data.
Which health monitoring solution should you recommend using on each server? To answer, drag the appropriate monitoring solutions to the correct servers. Each monitoring solution may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
...
Answer:
Q6. - (Topic 9)
You are designing a partitioning strategy for a large fact table in a Manufacturing data warehouse.
Tens of millions of new inventory fact records are loaded into the data warehouse weekly, outside of business hours. Most queries against the database are generated by reports and by cube processing. Data is frequently queried at the day level and occasionally at the month level.
A. Partition the inventory fact table by month, and compress each partition.
B. Partition the inventory fact table by day, and compress each partition.
C. Partition the inventory fact table by year.
D. Partition the inventory fact table by week.
Answer: B
Q7. - (Topic 1)
You need to identify the reports that produce the errors that Marc is receiving.
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
Q8. - (Topic 4)
You need to re-establish subscriptions on SSRS01. 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
Explanation:
SSRS reports are scheduled by SQL server Agent jobs. Start the SQL Server Agent on SSRS01.
Q9. DRAG DROP - (Topic 10)
You are developing a SQL Server Analysis Services (SSAS) cube.
You need to add a calculated member to the Customer dimension to evaluate the sum of values for France and Germany.
Which expression should you use? (To answer, drag the appropriate expression to the answer area.)
Answer:
Q10. - (Topic 5)
You need to design a cube partitioning strategy to be implemented as the cube size increases.
What should you do?
A. Use relational OLAP (ROLAP) on all local partitions.
B. Implement monthly remote partitions.
C. Use multidimensional OLAP (MOLAP) on all local partitions.
D. Implement monthly local partitions.
Answer: B