Q1. - (Topic 10)
...
You are developing a SQL Server Analysis Services (SSAS) cube for the sales department at your company. The sales department requires the following set of metrics:
Unique count of customers
Unique count of products sold
Sum of sales
You need to ensure that the cube meets the requirements while optimizing query response time.
What should you do? (Each answer presents a complete solution. Choose all that apply.)
A. Place the measures in a single measure group.
B. Place the distinct count measures in separate measure groups.
C. Use the additive measure group functions.
D. Use the semiadditive measure group functions.
E. Use the Count and Sum measure aggregation functions.
F. Use the Distinct Count and Sum measure aggregation functions.
Answer: B,D
Explanation: B: Typically, the best performance occurs when each distinct count measure is in its own measure group, and that measure group has the same dimensionality as the initial measure group.
D: Semiadditive Function
Select the aggregation function for the selected measure.
The aggregate functions available include DistinctCount, Aggregated using the
DistinctCount function.
Q2. DRAG DROP - (Topic 3)
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.)
Answer:
Q3. - (Topic 10)
You are managing a SQL Server Reporting Services (SSRS) instance.
A website must pass credentials to the local security authority for Reporting Services.
You need to configure Reporting Services to issue a challenge/response when a
connection is made without credentials.
Which authentication type should you configure in the RSReportServer.config file?
A. RSWindowsKerberos and RSWindowsNegotiate
B. RSWindowsKerberos only
C. RSWindowsKerberos and RSWindowsNTLM
D. RSWindowsBasic
Answer: A
Q4. - (Topic 9)
You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube.
The cube includes a Product dimension that contains a Category hierarchy and a Color attribute hierarchy.
You need to return only the blue products in the Category hierarchy.
Which set should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Option A
B. Option B
C. Option C
D. Option D
Answer: C
Q5. - (Topic 9)
You are designing a customer dimension for a multidimensional OLAP (MOLAP) database. The dimension table will contain millions of rows of data.
Customer dimension attributes will come from the following two sources:
. An enterprise resource planning (ERP) system that contains millions of rows of data. Attributes from this source will be updated daily.
. A marketing database that contains thousands of rows of data representing customers' geographic information. Attributes from this source will be updated monthly.
Most report queries against the cube use attributes from both sources. Customers in the cube dimension will frequently be filtered by the geographic attributes.
You need to design the dimension table and cube dimension to ensure that report queries perform well, and minimize the time required to reprocess cube attributes.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Create a dimension table for each source. Create one cube dimension that joins the two dimension tables together.
B. Create one dimension table that combines data from both sources. Create a cube dimension for each source.
C. Create one dimension table that combines data from both sources. Create one cube dimension that references the dimension table.
D. Create a dimension table for each source, and a cube dimension for each source.
Answer: D
Q6. - (Topic 1)
You need to create the sales territory and product measures.
Which aggregate function should you use for both measures?
A. COUNT (DISTINCT column_name)
B. Distinct Count
C. Distinct
D. Count
Answer: B
Q7. - (Topic 10)
You manage a SQL Server Reporting Services (SSRS) instance.
An application must pass credentials to the local security authority for Reporting Services.
You need to configure Reporting Services to issue a challenge/response when a
connection is made without credentials.
Which authentication type should you configure in the RSReportServer.config file?
A. RSWindowsNTLM
B. RSWindowsBasic
C. RSWindowsKerberos
D. RSWindowsNegotiate
Answer: B
Q8. - (Topic 8)
You need to recommend a cube architecture for CUBE1. The solution must meet the performance requirements for CUBE1.
Which two partitions should you recommend creating? Each correct answer presents part of the solution.
A. Partitions based on the values of the customerID column in the dimension table
B. Partitions based on the values of the customerID column in the fact table
C. Partitions based on the values of the productID column in the fact table
D. Partitions based on the values of the productID column in the dimension table
Answer: A,D
Topic 9, Mix Questions Set A
Q9. - (Topic 9)
You have a SQL Server Reporting Services (SSRS) 2008 instance integrated with an Internet-facing Microsoft SharePoint 2010 farm. PerformancePoint Services and Excel Services are installed and configured.
You need to upgrade to SSRS 2012 with the minimum downtime and hardware requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Migrate SSRS content to a separate instance of SSRS 2012 on the same server.
B. Perform an in-place upgrade of the SSRS environment.
C. Migrate SSRS content to new servers that run SSRS 2012.
D. Install SSRS 2012 on a new SharePoint farm and migrate content to the new farm.
Answer: C
Q10. HOTSPOT - (Topic 10)
You maintain a multidimensional Business Intelligence Semantic Model (BISM) that was developed with default settings.
The model has one cube and the cube has one measure group. The measure group is based on a very large fact table and is partitioned by month. The fact table is incrementally loaded each day with approximately 800,000 new rows.
You need to ensure that all rows are available in the cube while minimizing the processing time.
Which processing option should you use? (To answer, select the appropriate option in the answer area.)
Answer:
233. - (Topic 10)
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. Define the following calculation.
Year Over Year Revenue Growth:= CALCULATE([Revenue], DATEADD('Date'[Date], 1,
YEAR))
B. Define the following calculation.
Year Over Year Revenue Growth:-[Revenue; = CALCULATE ([Revenue;,
PARALLELPERIOD ('Date'[Date;, -12, MONTH))
C. Use the Business Intelligence Wizard and then use the Define time intelligence
enhancement.
D. Define the following calculation.
Year Over Year Revenue Growth: = [Revenue] = CALCULATE ([Revenue],
SAMEPERIODLASTYEAR('Date' [Date]))