Q1. - (Topic 10)
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.
A. AverageOfChildren
B. ByAccount
C. Count
D. DistinctCount
E. FirstChild
F. FirstNonEmpty
G. LastChild
H. LastNonEmpty
I. Max
J. Min
K. None
L. Sum
Answer: A
Explanation: AverageOfChildren Specifies average of leaf descendants in time. Average does not count an empty value as
0.
Q2. - (Topic 10)
You are designing a SQL Server Reporting Services (SSRS) report. The report defines a single SQL Server data source and dataset.
You need to include additional data sourced from a SQL Azure database in the report.
What should you do?
A. Create a SQL Azure dataset that uses the existing data source.
B. Create a SQL Azure data source and then add a dataset that uses the new data source.
C. Create a SQL Server data source and then add a dataset that uses the new data source.
D. Generate an Atom-compliant data feed for the report.
Answer: B
Q3. HOTSPOT - (Topic 9)
You are designing a SQL Server Integration Services (SSIS) package configuration strategy.
The package configuration must meet the following requirements:
. Include multiple properties in a configuration.
. Support several packages with different configuration settings. You need to select the appropriate configuration.
Which configuration type should you use?
To answer, select the appropriate option from the drop-down list in the dialog box.
Answer:
99. - (Topic 9)
You have a SQL Server Reporting Services (SSRS) 2012 instance integrated with a Microsoft SharePoint 2010 farm.
You need to upgrade to SSRS 2014 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. Install SSRS 2014 on a new SharePoint farm and migrate content to the new farm.
B. Migrate SSRS content to new servers that run SSRS 2014.
C. Migrate SSRS content to a separate instance of SSRS 2014 on the same server.
D. Perform an in-place upgrade of the SSRS environment.
Q4. - (Topic 8)
You execute the SalesbyCategory report and receive the following error message: "Members, tuples, or sets must use the same hierarchies in the function."
You need to ensure that the query executes successfully.
Which two actions should you perform? Each correct answer presents part of the solution.
A. Move the Product clause from line 08 to line 10.
B. Move the Date and Product clauses on line 11 to axis 0.
C. Move the Date clause from line 10 to line 08.
D. Move the Measures clause on line 02 to axis 1.
Answer: C
Q5. - (Topic 10)
You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A system role named Developer Support is present on the server.
Members of the Developer Support role cannot modify the report execution timeout period. You need to enable members of the Developer Support role to modify the report execution timeout period.
Which task should you add to the Developer Support role?
A. Execute report definitions
B. Manage shared schedules
C. Manage jobs
D. Manage report server properties
Answer: D
Q6. - (Topic 4)
You need to configure security for the SSRS instance on SSRS01 to connect to SSAS and minimize downtime.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
A. Register a service principal name for the Report Server service.
B. Register a service principal name for the Analysis Services service.
C. Restart the IIS service.
D. Configure SSRS01 to use the Negotiate authentication type.
E. Configure SSRS01 to use the Custom authentication type.
Answer: A,D
Explanation: A (not B): If you are deploying Reporting Services in a network that uses the Kerberos protocol for mutual authentication, you must create a Service Principal Name (SPN) for the Report Server service if you configure it to run as a domain user account.
D (not E):
* See step 6 below.
To register an SPN for a Report Server service running as a domain user
. ... ...
Install Reporting Services and configure the Report Server service to run as a
domain user account. Note that users will not be able to connect to the report
server until you complete the following steps.
Log on to the domain controller as domain administrator.
Open a Command Prompt window.
Copy the following command, replacing placeholder values with actual values that
are valid for your network:
Setspn -a http/<computer-name>.<domain-name>:<port><domain-user-account>
Run the command.
Open the RsReportServer.config file and locate the <AuthenticationTypes>
section. Add <RSWindowsNegotiate/> as the first entry in this section to enable
NTLM.
* RSWindowsNegotiate. If you initially set the Windows service account for the report server to NetworkService or LocalSystem in Reporting Services Configuration Manager, RSWindowsNegotiate is added to the RSReportServer.config file as the default setting. With this setting, the report server can accept requests from client applications requesting Kerberos or NTLM authentication. If Kerberos is requested and the authentication fails, the report server switches to NTLM authentication and prompts the user for credentials unless the network is configured to manage authentication transparently.
Using RSWindowsNegotiate is your best option because it provides the greatest flexibility for multiple clients in an intranet environment.
Not C: IIS is not mention in this scenario.
Note:
* From scenario:
/ A single-server deployment of SQL Server 2008 R2 Reporting Services (SSRS) in native
mode is installed on a server named SSRS01. The Reporting Server service is configured
to use a domain service account.
Reference: Register a Service Principal Name (SPN) for a Report Server
Q7. - (Topic 2)
You need to configure the partition storage settings to support the reporting requirements.
Which partition storage setting should you use?
A. DirectQuery
B. In-Memory
C. MOLAP
D. Low-latency MOLAP
E. Scheduled MOLAP
F. High-latency MOLAP
Answer: D
Q8. 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:
Q9. - (Topic 10)
You are designing a SQL Server Reporting Services (SSRS) report based on a SQL Server Analysis Services (SSAS) cube.
The cube contains a Key Performance Indicator (KPI) to show if a salesperson's sales are off target, slightly off target, or on target.
You need to add a report item that visually displays the KPI status value as a red, yellow, or green circle.
Which report item should you add?
A. Data Bar
B. Indicator
C. Radial Gauge
D. Linear Gauge
E. Sparkline
Answer: B
Q10. HOTSPOT - (Topic 10)
You are developing a SQL Server Analysis Services (SSAS) cube.
You create a degenerate dimension.
You need to define a relationship type for the dimension.
Which relationship type should you select? (To answer, configure the appropriate option or
options in the dialog box in the answer area.)
Answer:
218. - (Topic 10)
You are developing a SQL Server Analysis Services (SSAS) tabular project.
The model includes a table named DimEmployee. The table contains employee details, including the sales territory for each employee. The table also defines a column named EmployeeAlias which contains the Active Directory Domain Services (AD DS) domain and logon name for each employee. You create a role named Employees.
You need to configure the Employees roles so that users can query only sales orders for their respective sales territory.
What should you do?
A. Add a row filter that implements only the USERNAME function.
B. Add a row filter that implements the LOOKUPVALUE and USERNAME functions.
C. Add a row filter that implements only the CUSTOMDATA function.
D. Add a row filter that implements the LOOKUPVALUE and CUSTOMDATA functions.