Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
Q1. DRAG DROP - (Topic 4)
You are developing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database and a SQL Server Analysis Services (SSAS) cube. The cube contains a date dimension and other dimensions. The report design includes two report parameters named StartDate and FinishDate as shown in the following diagram.
The Data Type property of the parameters is set to Date/Time.
You need to create the dataset based on the SSAS cube. You also need to ensure that the dataset is filtered by the existing report parameters.
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:
Q2. DRAG DROP - (Topic 4)
You are developing reports based on the SQL Server Analysis Services (SSAS) cube named ProcessedOrders.
A Multidimensional Expressions (MDX) query must include a query-scoped calculated member, which computes average sales per order item. The query must also return the set of three states in a query-scoped named set named East Coast Customers.
You need to define the calculations in an MDX query to meet the requirements.
Which four MDX segments should you insert in sequence before a SELECT statement? (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 4)
You are developing a SQL Server Analysis Services (SSAS) tabular project. A model defines a measure named Revenue 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 revenue.
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
Q4. 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:
Q5. - (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
Q6. HOTSPOT - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) cube for the accounts department.
You create a measure group named Exchange Rate that consists of measures pertaining to currency exchange rates. One of the measures in this group is named Average Rate and it will be used to report the average currency exchange rate over time.
Currently the AggregationFunction property for the Average Rate measure is set to Sum.
You need to ensure that Average Rate measure reports the average of the currency exchange rate over time.
Which value should you select for the AggregationFunction property for the Average Rate measure? To answer, select the appropriate setting in the answer area.
Answer:
Q7. HOTSPOT - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) cube.
Revenue must be compared to a goal and described by a status and a trend. Revenue,
goal, status, and trend will be defined by Multidimensional Expressions (MDX) expressions.
You need to add the Revenue measure.
Which tab should you select? (To answer, select the appropriate tab in the answer area.)
Answer:
Q8. - (Topic 1)
You need to configure the dataset for the ManufacturingIssues report. The solution must
meet the technical requirements and the reporting requirements.
What should you do?
A. Configure the dataset to use a stored procedure. Add the necessary parameters to the stored procedure.
B. Add a query to retrieve the necessary data from the database. Configure the dataset to use query parameters.
C. Add a query to retrieve the necessary data from the database. Configure the dataset to use filter parameters.
D. Configure the dataset to use a table. Ensure that the database has a table that contains the necessary information.
Answer: B
Q9. HOTSPOT - (Topic 4)
You are designing a SQL Server Analysis Services (SSAS) cube that contains two measure groups named Sales History and Current Sales.
The Sales History measure group has the following characteristics:
....
Data changes on a monthly basis.
The measure group contains a very high data volume.
Queries that use the measure group only reference aggregate data.
The measure group includes SUM, MIN, MAX, and COUNT aggregate functions.
The Current Sales measure group has the following characteristics:
....
Data changes frequently.
The measure group contains a low data volume.
Queries that use the measure group often reference non-aggregate data.
The measure group includes SUM, MIN, MAX, and COUNT aggregate functions.
You need to select a storage mode for each measure group. The solution must meet the following requirements:
..
For the Sales History measure group, query performance must be optimized over
data latency.
For the Current Sales measure group, data latency must be optimized over query
performance.
What should you do? To answer, select the appropriate storage mode for each measure
group in the answer area.
Answer:
Q10. - (Topic 4)
A multinational retailer has retail locations on several continents. A single SQL Server Reporting Services (SSRS) instance is used for global reporting.
A SQL Server Analysis Services (SSAS) instance for each continent hosts a multidimensional database named RetailSales. Each RetailSales database stores data only for the continent in which it resides. All of the SSAS instances are configured identically. The cube names and objects are identical.
Reports must meet the following requirements:
...
A report parameter named ServerName must be defined in each report.
When running a report, users must be prompted to select a server instance.
The report data source must use the Microsoft SQL Server Analysis Services data
source type.
You need to create a data source to meet the requirements.
How should you define the expression that is assigned to the connection string property of the data source?
A. ="Server=" & ParametersIServerName.Value & "; Initial Catalog=RetailSales"
B. ="Data Source=@ServerName; Initial Catalog=RetailSales"
C. ="Data Source=" & Parameters!ServerName.Value & ";Initial Catalog=RetailSales"
D. ="Server=" & Parameters!ServerName.Value
E. ="Server=@ServerName; Initial Catalog=RetailSales"
Answer: C
Q11. - (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
Q12. - (Topic 4)
You are developing a SQL Server Reporting Services (SSRS) sales summary report.
The report header consists of several images.
You need to ensure that the header of the report is hidden when a user exports the report to PDF format.
Which Hidden property expression should you use for the report header? {More than one answer choice may achieve the goal. Select the BEST answer.)
A. =(GlobalsIRenderFormat.IsInteractive = False)
B. = (Globals!RenderFormat.Name = "PDF")
C. =False
D. =True
Answer: B
Q13. DRAG DROP - (Topic 4)
You are developing a SQL Server PowerPivot model to monitor the rate of production of defective products.
The PowerPivot model contains many tables. The FactProduction table is configured as shown in the following diagram.
The model requires a key performance indicator (KPI) named Defective Units to measure the rate of production of defective units. The rate of production of defective units is calculated by dividing the sum of the Defects column by the sum of the Units column.
The KPI has the following requirements.
. If the rate of production of defective products equals or exceeds 5% then the KPI must report a status of off target (red). . If the rate of production of defective products is less than 5% and equals or exceeds 2% then the KPI must report a status of slightly off target (yellow). . If the rate of production of defective products less than 2% then the KPI must report a status of on target (green).
You need to develop the KPI to meet the requirements.
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:
Q14. - (Topic 3)
You need create the data source view for the StandardReports project. What should you do?
A. Create a data source, connect it to the data warehouse, and then use the Data Source View wizard.
B. Generate a relational schema from the dimensions and cubes by using the Schema Generation wizard.
C. Create a new data source view and then use the Import from Table wizard.
D. Execute the Import from Table wizard and then use the Data Source View wizard.
Answer: A
Q15. DRAG DROP - (Topic 2)
You need to optimize the Regions dimension.
How should you configure the attribute relationships? (To answer, drag the appropriate attribute from the list of attributes to the correct location in the hierarchy relationship. Use only attributes that apply.)
Answer:
Q16. - (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