70-470 Exam
[Best Quality] 70-470 Microsoft free download 101-110 (Jan 2021)
It is impossible to pass Microsoft 70-470 exam without any help in the short term. Come to Exambible soon and find the most advanced, correct and guaranteed Microsoft 70-470 practice questions. You will get a surprising result by our Latest Recertification for MCSE: Business Intelligence practice guides.
Q101. - (Topic 10)
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.)
A. Add a parameter to the report so users can choose the display state of Table1.
B. For the properties of Table1, configure the Display can be toggled by this report item option to use Textbox1.
C. Configure Textbox1 to drill through to rerun the report to toggle the display of Table1.
D. For the properties of Table1, configure the Display can be toggled by this report item option to use Table1.
Answer: B
Q102. - (Topic 3)
You need to configure package execution logging to meet the requirements.
What should you do?
A. Configure logging in each ETL package to log the OnError, OnInformation, and Diagnostic events.
B. Set the SSIS catalog's Server-wide Default Logging Level property to Performance.
C. Set the SSIS catalog's Server-wide Default Logging Level property to Basic.
D. Set the SSIS catalog's Server-wide Default Logging Level property to Verbose.
E. Configure logging in each ETL package to log the OnError, OnPreExecute, and OnPostExecute events.
Answer: B
Q103. - (Topic 6)
You need to configure permissions for the Customers dimension.
What should you do? (Each correct answer presents a complete solution. Choose all that apply.)
A. In SQL Server Management Studio, configure the BusinessUsers role to disallow the reading of all definitions.
B. In SQL Server Data Tools, configure the BusinessUsers role to disallow the reading of the Customers dimension definition.
C. In SQL Server Management Studio, deny the member set for the Customers dimension data by using the Multidimensional Expressions (MDX) expression Filter([BusinessUsers]).
D. In SQL Server Management Studio, configure the BusinessUsers role to disallow the reading of the Customers dimension definition.
Answer: B,D
66. - (Topic 6)
You need to implement the date dimension in the Operations database.
What should you do?
A. Create three database dimensions. Add each database dimension as a cube dimension by setting the Referenced relationship type.
B. Create one database dimension. Add three cube dimensions based on the database dimension. Set the Regular relationship type for each cube dimension.
C. Create three database dimensions. Add each database dimension as a cube dimension by setting the Regular relationship type.
D. Create one database dimension. Add three cube dimensions based on the database dimension. Set the Referenced relationship type for each cube dimension.
Answer: B
Q104. - (Topic 10)
You are developing a SQL Server Analysis Services (SSAS) tabular project.
A model contains tables and columns that must not be visible to the user. The columns and tables cannot be removed because they are used in calculations.
You need to hide the tables and columns.
What should you do?
A. Right-click the applicable tables and columns and select the Hide option.
B. in the Properties window for the applicable tables and columns, set the Enabled property to False.
C. in the Properties window for the applicable tables and columns, set the Visible property to True.
D. Right-click the applicable tables and columns and select the Hide from Client Tools option.
Answer: D
Q105. 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:
Q106. - (Topic 2)
You need to configure per-user security authentication for reporting against the Sales cube.
What should you do? (Each correct answer presents part of the complete solution. Choose all that apply.)
A. Create Service Principal Names (SPNs).
B. Configure account delegation.
C. Enable forms-based authentication.
D. Enable mixed-mode authentication.
Answer: A,D
Explanation: * From scenario:
/ Administrative staff from around the world will produce sales reports with Microsoft Excel
2010 based on the Sales cube.
/ Security requirements
When possible, the system must use Windows authentication for all database connections.
The system must prevent users from querying data from outside of their region.
The system must allow certain users to query data from multiple regions.
A: To use Kerberos authentication with SQL Server requires both the following conditions to be true: The client and server computers must be part of the same Windows domain, or in trusted domains. A Service Principal Name (SPN) must be registered with Active Directory, which assumes the role of the Key Distribution Center in a Windows domain. The SPN, after it is registered, maps to the Windows account that started the SQL Server instance service. If the SPN registration has not been performed or fails, the Windows security layer cannot determine the account associated with the SPN, and Kerberos authentication will not be used.
D: For windows authentication we need to enable mixed-mode authentication
Q107. DRAG DROP - (Topic 9)
You are administering a SQL Server Analysis Services (SSAS) database on a server. The database hosts a financial cube based on a SQL Azure database.
You need to grant read access to the financial cube for all users in the group USA\PowerUsers.
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:
Q108. - (Topic 4)
You need to design the recovery strategy for SSRS01.
What should the strategy include? (Each correct answer presents part of the solution. Choose all that apply.)
A. Re-create the SQL Server Agent jobs that are used to trigger schedules.
B. Restore the ReportServer and ReportServerTempDB databases with recovery.
C. Restore the ReportServer and ReportServerTempDB databases with no recovery.
D. Restore the msdb database.
E. Restore the Report Server encryption key.
F. Restore the database encryption key.
Answer: A,B,E
39. - (Topic 4)
You need to re-establish subscriptions on SSRS01.
What should you do?
A. Start the SQL Server Agent on SSRS01.
B. Restore the ReportServer database.
C. Restore the ReportServerTempDB database.
D. Use the SQL Server Configuration Manager to reset the SQL Service account credentials.
Answer: A
Q109. HOTSPOT - (Topic 10)
You are developing a SQL Server Analysis Services (SSAS) cube.
You are writing the following Multidimensional Expressions (MDX) statement for use by a calculated measure. The measure computes the sales amount for the same time period of the previous year. (Line numbers are included for reference only.)
You need to complete the MDX statement.
Which MDX function should you use in line 03? To answer, select the appropriate MDX function in the functions list.
Answer:
Q110. DRAG DROP - (Topic 9)
You have a business intelligence (BI) infrastructure that contains three servers. The servers are configured as shown in the following table.
You need to recommend a health monitoring solution for the BI infrastructure.
The solution must meet the following requirements:
Monitor the status of the Usage Data Collection feature.
Monitor the number of end-users accessing the solution.
Monitor the amount of cache used when the users query data.
Which health monitoring solution should you recommend using on each server? To answer, drag the appropriate monitoring solutions to the correct servers. Each monitoring solution may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
...
Answer: