70-470 Exam
Finding Most recent 70-470 discount pack
Want to know Testking 70-470 Exam practice test features? Want to lear more about Microsoft Recertification for MCSE: Business Intelligence certification experience? Study Breathing Microsoft 70-470 answers to Down to date 70-470 questions at Testking. Gat a success with an absolute guarantee to pass Microsoft 70-470 (Recertification for MCSE: Business Intelligence) test on your first attempt.
Q21. DRAG DROP - (Topic 9)
You are designing a SQL Server Analysis Services (SSAS) data model on a very large
data warehouse.
The fact tables in the data warehouse contain terabytes of data in tens of billions of rows.
You must support the following features:
...
Complex attribute/column relationships Advanced calculations in the data model definition Advanced calculations using logic deployed in a custom assembly
You need to choose the correct SSAS design strategy.
What should you do?
To answer, drag the appropriate term or terms to the correct location or locations in the answer area. (Answer choices may be used once, more than once, or not all.)
Answer:
Q22. - (Topic 3)
You need to configure data refresh for the Manufacturing Performance PowerPivot workbook.
What should you do? (Each correct answer presents part of the solution. Choose ail that apply.)
A. Configure the PowerPivot Data Refresh Timer Job to run every 60 minutes.
B. Restore the PowerPivot workbook to an SSAS instance in tabular mode.
C. Script a process command and configure a SQL Server Agent job to execute the command every 60 minutes.
D. Restore the PowerPivot workbook to an SSAS instance in PowerPivot for SharePoint mode.
Answer: A
Q23. - (Topic 10)
You are developing a SQL Server Reporting Services (SSRS) report that renders in HTML. The report includes a dataset with fields named Description, Price, and Color. The report layout includes a table that displays product details and also includes columns named Description, Price, and Color.
You need to modify the report so that users can sort products by the Price column.
What should you do?
A. Add a custom action to the Price text box.
B. Set the SortExpression property to =Fields!Price.Value for the Price text box.
C. In the Expression dialog box for the Price text box, enter the =SortBy FieldslPrice.Value expression.
D. Set the SortExpression value to =Fields!Price.Description for the Price text box.
Answer: B
Q24. - (Topic 2)
You need to develop the executive reports.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
A. Remove default values from all parameters.
B. Implement dataset query parameters to filter data.
C. Set the data source to use Windows authentication.
D. Set the data source to use stored Windows credentials.
E. Provide default values for all parameters.
F. Implement dataset filters to filter data.
Answer: B,D,E
Explanation: * From scenario:
Deliver executive reports that are parameterized and rendered from report snapshots
BD: The data source that the shared dataset is based on has Prompt or Windows
Integrated credentials.
Q25. - (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
Q26. - (Topic 10)
.. ..
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
Explanation: 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.
C:
The lookupvalue function returns the value in result_columnName for the row that meets all
criteria specified by search_columnName and search_value.
Syntax:
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.
Q27. - (Topic 5)
You need to implement the aggregation designs for the cube.
What should you do?
A. Use the Usage-Based Optimization Wizard.
B. Use the Aggregation Design Wizard.
C. Partition the cube by month.
D. Implement cache warming in SSAS via an SSIS package.
Answer: B
Q28. DRAG DROP - (Topic 10)
You are developing a SQL Server Reporting Services (SSRS) report to display a list of
employees. The report will be embedded into a Microsoft SharePoint Server Web Part Page of the company intranet site.
The report consists of a single table. The design of the table is shown in the following diagram.
You need to configure the EmailAddress detail text box to create a new email message. The email message must be addressed to the email address that was clicked by the user.
Which four 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:
312. - (Topic 10)
You are designing a SQL Server Reporting Services (SSRS) report to display product names and their year-to-date (YTD) sales quantity YTD sales quantity values are classified in three bands: High Sales, Medium Sales, and Low Sales.
You add a table to the report. Then you define two columns based on the fields named ProductName and YTDSalesQuantity.
You need to set the color of the product text to red, yellow, or blue, depending on the value of the YTD sales quantity values.
What should you do?
A. Use an expression for the TextDecoration property of the text box.
B. Use an expression for the Style property of the text box.
C. Add an indicator to the table.
D. Use an expression for the Font property of the text box.
E. Use an expression for the Color property of the text box.
Answer: E
Q29. DRAG DROP - (Topic 10)
You are developing a SQL Server Analysis Services (SSAS) tabular project based on a SQL Azure database. The ProcessingOption property for the project is set to Do Not Process.
Several calculated columns have been added to a table. The project has been deployed to the production server.
You need to ensure that newly added data is processed on the production server.
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:
Q30. - (Topic 6)
You need to ensure that you can monitor the usage data.
What should you do?
A. In SharePoint Central Administration, enable usage data collection.
B. In the PowerPivot Configuration Tool, repair PowerPivot for SharePoint.
C. In the PowerPivot Configuration Tool, upgrade PowerPivot for SharePoint.
D. In Reporting Services Configuration Manager, enable report execution logging.
Answer: A