70-470 Demo and Sample
Note: Answers are below each question.
Samples are taken from full version.
You manage an environment that has SharePoint Server 2010 and a SQL Server Reporting Services (SSRS) instance in SharePoint integrated mode. Several report subscriptions are configured to deliver reports through a shared folder by using a shared schedule. The shared folder will be going offline. You need to temporarily suspend the shared schedule until the shared folder is brought back online. What should you do?
In SharePoint Central Administration, pause the shared schedule.
Open Report Manager and then delete the shared schedule.
In SharePoint Central Administration, delete the shared schedule.
Open Report Manager and then pause the shared schedule.
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.)
Use the Define Semiadditive Behavior page to enable semi-additive behavior.
Use ROLAP storage for all partitions.
Use the Define Semiadditive Behavior page to disable semi-additive behavior.
Use the Distinct Count and Sum measure aggregation functions.
Place the distinct count measures in separate measure groups.
Create a single measure group containing all measures
Answer: A, E
A: Semiadditive Function
Select the aggregation function for the selected measure.
The aggregate functions available include DistinctCount, Aggregated using the DistinctCount function.
E (not D, Not F): 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.
You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server Data Tools (SSDT). This report has a table named Table1 and a textbox named Textbox1. Table1 is initially visible but the user must be able to choose when to hide it. You need to develop the report to meet the requirement. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Add a parameter to the report so users can choose the display state of Table1.
For the properties of Table1, configure the Display can be toggled by this report item option to use Textbox1.
Configure Textbox1 to drill through to rerun the report to toggle the display of Table1.
For the properties of Table1, configure the Display can be toggled by this report item option to use Table1.
You are developing a SQL Server Analysis Services (SSAS) tabular project. The model has tables named Invoice Line Items and Products. The Invoice Line Items table has the following columns:
✑ Product Id
✑ Unit Sales Price The Unit Sales Price column stores the unit price of the product sold. The Products table has the following columns:
✑ Product Id
✑ Maximum Sales Price
The Maximum Sales Price column is available only in the Products table. You add a column named Is Overpriced to the Invoice Line Items table. The Is Overpriced column must store a value of TRUE if the value of the Unit Sales Price is greater than the value of the Maximum Sales Price. Otherwise, a value of FALSE must be stored. You need to define the Data Analysis Expressions (DAX) expression for the Is Overpriced column. Which DAX formula should you use? (Each answer represents a complete solution. Choose all that apply.)
A. =IF([Unit Sales Price] > RELATED(Products[Maximum Sales Price]), TRUE, FALSE)
B. =IF(RELATED(Products[Unit Sales Price]) > [Maximum Sales Price], TRUE, FALSE)
C. =IF([Unit Sales Price] > LOOKUPVALUE(Products[Maximum Sales Price], Products[Product Id], [Product Id]), TRUE, FALSE)
D. =IF(LOOKUPVALUE(Products[Unit Sales Price], Products[Product Id], [Product Id]) > [Maximum Sales Price]), TRUE, FALSE)
Answer: A, C
A: RELATED Function Returns a related value from another table.
* The RELATED function requires that a relationship exists between the current table and the table with related information. You specify the column that contains the data that you want, and the function follows an existing many-to-one relationship to fetch the value from the specified column in the related table.
The lookupvalue function returns the value in result_columnName for the row that meets all criteria specified by search_columnName and search_value.
LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value>[,
<search_columnName>, <search_value>]…) Note:
The syntax of DAX formulas is very similar to that of Excel formulas, and uses a combination of functions, operators, and values.
You install SQL Server Reporting Services (SSRS). You need to back up a copy of the symmetric key. Which command should you run?
rskeymgmt -e -f %temp%\rs.key -p Password1
rskeymgmt -a -f %temp%\rs.key -p Password1
QUESTION: 108 DRAG DROP
You are planning the installation of PowerPivot for SharePoint. You install SharePoint Server 2010 Enterprise Edition with Service Pack 1. You need to install the PowerPivot for SharePoint instance. Then you need to configure the Default Account username used to provision shared services in the SharePoint farm. 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.)
You manage a SQL Server Reporting Services (SSRS) instance. The
Reporting Services Service. 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?
View the Report Server service trace log.
View the ExecutionLog view in the Report Server database.
View the Report Server HTTP log.
View the Windows System event log.
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?
RSWindowsKerberos and RSWindowsNegotiate
RSWindowsKerberos and RSWindowsNTLM
QUESTION: 111 HOTSPOT
A sales cube contains two years of data. The sales team must see year-over-year (YOY) and month-over-month (MOM) sales metrics. You need to modify the cube to support the sales
team's requirements. Which Business Intelligence Wizard enhancements should you use? (To answer, configure the appropriate option or options in the dialog box in the answer area.)
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 SQL Azure 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?
SQL Server spatial query
Bing Maps layer
ESRI shape file
You are developing a SQL Server Analysis Services (SSAS) multidimensional database. The underlying data source does not have a time dimension table. You need to implement a time dimension. What should you do?
Use the SQL Server Data Tools Dimension Wizard and generate a time table in the data source.
Create a time dimension by using the Define dimension intelligence option in the Business Intelligence Wizard.
Create a time dimension by using the Define time intelligence option in the Business Intelligence Wizard.
Add an existing SSAS database time dimension as a cube dimension.
QUESTION: 114 DRAG DROP
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 the United Kingdom and the United States. Which expression should you use? (To answer, drag the appropriate expression to the answer area.)
You are modifying a SQL Server Analysis Services (SSAS) cube. Users of the cube report that the precision for the SalesAmount measure is four digits. You need to ensure that the SalesAmount measure stores values to two digits of precision. What should you do?
Add a named query in the data source view that casts the data source column to two digits of precision. Bind the SalesAmount measure to the new query.
Use the MeasureExpression measure property to change the precision of SalesAmount to two digits.
Add a named calculation in the data source view that casts the data source column to two digits of precision. Bind the SalesAmount measure to the new column.
Use the FormatString measure property to format SalesAmount as Currency.
Use the FormatString measure property to format SalesAmount as #,##0.00;-#,##0.00.
You are designing a SQL Server Reporting Services (SSRS) report to display vineyard names and their year-to-date (YTD) grape yield. Grape yield values are classified in three bands:
✑ High Yield
✑ Medium Yield
✑ Low Yield
You add a table to the report. Then you define two columns based on the fields named VineyardName and YTDGrapeYield. You need to set the color of the vineyard text to red, yellow, or blue, depending on the value of the YTD grape yield values. What should you do?
Add an indicator to the table.
Use an expression for the Style property of the vineyard text box.
Use an expression for the Font property of the vineyard text box.
Use an expression for the TextDecoration property of the vineyard text box.
Use an expression for the Color property of the vineyard text box.
Read more Details »