Q1. - (Topic 4)
You are designing a SQL Server Reporting Services (SSRS) report for a bank. The bank has Automated Teller Machines (ATMs) in several regions. ATM operational data is stored in a Microsoft Azure SQL Database database.
The report must use a map to display the location and status of the ATMs as shown in the following exhibit. (Click the Exhibit button.)
You need to ensure that the report displays only a user selected map region.
Which source of spatial data should you use for the map?
A. SQL Server spatial query
B. Map gallery
C. ESRI shape file
D. Bing Maps layer
Answer: A
Q2. - (Topic 4)
You have a SQL Server Reporting Services (SSRS) instance. The instance has a report that displays 3 million records.
Users report that they experience performance issues when they use the report.
You need to ensure that the report renders as quickly as possible.
Which two actions should you perform? Each correct answer presents part of the solution.
A. Enable versioning.
B. Enable caching.
C. Enable report history.
D. Create snapshots.
E. Implement pagination.
Answer: A,B
Q3. DRAG DROP - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) cube.
You need to reuse a Revenue 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:
Q4. - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) tabular project. A model defines a measure named Profit and includes a table named Date. The table includes year, semester, quarter, month, and date columns. The Date column is of data type Date. The table contains a set of contiguous dates.
You need to create a measure to report on year-over-year growth of profit.
What should you do? (Each answer presents a complete solution. Choose all that apply.)
A. Option A
B. Option B
C. Option C
D. Option D
Answer: C,D
Q5. - (Topic 4)
...
A large manufacturing company has manufacturing plants in many states. Each state has a dedicated SQL Server instance that stores its manufacturing data. Each SQL Server instance is configured identically and all instances have identical database structures.
You are developing a daily report that summarizes information on manufacturing activity.
The report has the following requirements:
It must have a stale name as one of the report parameters.
It must provide a daily summary of manufacturing activity of a selected state.
It must require minimal development and maintenance effort.
You need to develop the report to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Build one report for each state and instruct users to execute reports as needed.
B. Use a report-specific data source that defines an expression-based connection string based on the state parameter.
C. Build a centralized data repository, schedule a regular Extract Transform, and Load (ETL) process on all manufacturing data, and then use the repository to generate the report.
D. Use a shared data source that defines an expression-based connection string based on the state parameter.
Answer: B
Q6. - (Topic 4)
You are adding dimensions and a new measure group named Service Quality to an existing SQL Server Analysis Services (SSAS) cube.
Date is one of the existing dimensions in the SSAS database. The underlying fact table for the measure group is associated with multiple dates, including FirstServiceDate, SecondServiceDate, and ThirdServiceDate.
You need to ensure that users can slice the Service Quality measures by FirstServiceDate, SecondServiceDate, and ThirdServiceDate. You also need to ensure that the time required to process the database is minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Create cube dimensions named FirstServiceDate. SecondServiceDate, and ThirdServiceDate by using the existing date dimension in the database.
B. Create three independent dimensions named FirstServiceDate, SecondServiceDate, and ThirdServiceDate and then link all three of them to the Service Quality measure group.
C. Create three new perspectives named FirstServiceDate. SecondServiceDate, and ThirdServiceDate.
D. Add three attributes named FirstServiceDate. SecondServiceDate, and ThirdServiceDate to the existing date dimension in the database.
Answer: C
Q7. - (Topic 4)
You manage a SQL Server Reporting Services (SSRS) instance. The ReportingServicesService.exe.config file has been modified to enable logging.
Some users report that they cannot access the server.
You need to ascertain the IP addresses of the client computers that are accessing the server.
What should you do?
A. View the ExecutionLog view in the Report Server database.
B. View the Report Server service trace log.
C. View the Report Server HTTP log.
D. View the Windows System event log.
Answer: C
Explanation: http://msdn.microsoft.com/en-us/library/bb630443.aspx
Q8. - (Topic 2)
You need to modify the Sales Regions hierarchy to meet the reporting requirements.
Which SSAS feature should you use?
A. Calculation
B. Translation
C. Perspective
D. Action
Answer: B
Q9. - (Topic 1)
You need to configure a hierarchy for DimProduct that meets the technical requirements.
What should you do?
A. Set ProductName as the parent of ProductSubCategory and set ProductSubcategory as the parent of ProductCategory. For ProductSubcategory, click Hide if Name Equals Parent.
B. Set ProductCategory as the parent of ProductSubCategory and set ProductSubcategory as the parent of ProductName. For ProductSubcategory, click Hide if Name Equals Parent.
C. Set ProductName as the parent of ProductSubcategory and set ProductSubCategory as the parent of ProductCategory. For ProductCategory, click Hide if Name Equals Parent.
D. Set ProductCategory as the parent of ProductSubcategory and set ProductSubCategory as the parent of ProductName. For ProductCategory, click Hide if Name Equals Parent.
Answer: B
Q10. - (Topic 4)
You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A
role named Folder Access Controller is present on the server.
The Folder Access Controller role consists of only the Set security for individual items task.
When role members open Report Manager, they cannot view folders.
You need to modify the Folder Access Controller role sc that the role members can view
folders.
Which task should you add to the Folder Access Controller role?
A. Manage models
B. Manage reports
C. View reports
D. Manage folders
Answer: D