70-470 Exam
70-470 preparation exams（31 to 40） for IT candidates: Jan 2021 Edition
Cause all that matters here is passing the Microsoft 70-470 exam. Cause all that you need is a high score of 70-470 Recertification for MCSE: Business Intelligence exam. The only one thing you need to do is downloading Examcollection 70-470 exam study guides now. We will not let you down with our money-back guarantee.
Q31. - (Topic 10)
You are planning to develop a SQL Server Analysis Services (SSAS) tabular project. The
project will be deployed to a SSAS server that has 16 GB of RAM.
The project will source data from a SQL Server 2012 database that contains a fact table named Sales. The fact table has more than 60 billion rows of data.
You need to select an appropriate design to maximize query performance.
Which data access strategy should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Configure the database to use DirectQuery mode. Create a columnstore index on all the columns of the fact table.
B. Configure the database to use In-Memory mode. Create a clustered index which includes all of the foreign key columns of the fact table.
C. Configure the database to use In-Memory mode. Create a columnstore index on all the columns of the fact table.
D. Configure the database to use DirectQuery mode. Create a clustered index which includes all of the foreign key columns of the fact table.
Answer: A
Q32. DRAG DROP - (Topic 10)
You are using Multidimensional Expressions (MDX) to query a SQL Server Analysis Services (SSAS) cube.
You need to compute the aggregate value of the 10 most-ordered produces in the Product Categories hierarchy. The Product level is the lowest in the hierarchy.
Which functions should you use to complete the MDX query? (To answer, drag the appropriate functions from the list of functions to the correct locations in the answer area.)
Answer:
Q33. - (Topic 10)
You are developing a BI Semantic Model (BISM) based on a simple and small dataset sourced from SQL Server. The data size and complexity of the data relationships will not change. The model will be used to produce reports in Power View.
You need to use an appropriate project type.
Which project types should you use? (Each answer presents a complete solution. Choose all that apply.)
A. a tabular project that uses the DirectQuery query mode
B. a tabular project that uses the In-Memory query mode
C. a multidimensional project that uses the ROLAP storage mode
D. a PowerPivot workbook that is deployed to Microsoft SharePoint Server 2010
E. a multidimensional project that uses the MOLAP storage mode
Answer: A,B,E
Explanation: Power View is a thin web client that launches right in the browser from a data model in SharePoint Server 2010. The model can be a PowerPivot model workbook or a tabular model running on a SQL Server 2012 Analysis Services (SSAS) server.
Q34. - (Topic 5)
You need to identify changes in the financial database.
What should you do?
A. Add SQL Server log shipping to each table.
B. Add SQL Server mirroring to each table.
C. Perform a full extract of each table.
D. Enable change data capture on each table.
E. Create an AlwaysOn Availability Group that includes all the tables.
Answer: D
Q35. HOTSPOT - (Topic 10)
You create a new report in SQL Server Data Tools (SSDT). The report queries a Windows Azure SQL Database database table.
In a report table showing sales by countries and cities, you need to enable users to hide or show cities by clicking the name of a country.
Which property page of the city text box should you use? (To answer, select the appropriate tab in the answer area.)
Answer:
281. - (Topic 10)
You manage a SQL Server Reporting Services (SSRS) instance. The ReportingServicesService.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?
A. View the Report Server service trace log.
B. View the ExecutionLog view in the Report Server database.
C. View the Report Server HTTP log.
D. View the Windows System event log.
Answer: C
Q36. - (Topic 10)
You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A role named Folder Access Controller is present on the server.
The Folder Access Controller role consists of only the Set security for individual items task. When role members open Report Manager, they cannot view folders.
You need to modify the Folder Access Controller role so that the role members can view folders.
Which task should you add to the Folder Access Controller role?
A. Manage data sources
B. Manage folders
C. View models
D. View reports
Answer: B
Q37. HOTSPOT - (Topic 9)
You are developing a SQL Server Analysis Services (SSAS) cube. A dimension named Category is based on the DimCategory table.
A subset of the data source view is shown in the following graphic.
You need to relate the Category dimension to the Sales measure group.
Which relationship type should you choose?
To answer, select the appropriate option from the drop-down list in the dialog box.
Answer:
Q38. - (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. Install PowerPivot.
B. Create Service Principal Names (SPNs).
C. Configure account delegation.
D. Set up the Unattended Service Account.
Answer: A,B
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.
B: 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.
Q39. - (Topic 5)
You need to restrict access to data in the tables in the data warehouse.
What should you do?
A. Configure column-level permissions.
B. Configure database roles.
C. Create views and grant permissions to the views.
D. Configure application roles.
Answer: C
Q40. - (Topic 9)
You are developing the database schema for a SQL Server Analysis Services (SSAS) BI Semantic Model (BISM). The BISM will be based on the schema displayed in the following graphic.
You have the following requirements:
. Ensure that queries of the data model correctly display average student age by
class.
. Ensure that the solution supports role-based security and partitions.
. Minimize development effort.
You need to design the data model.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Create a multidimensional project and define measures and a many-to-many dimensional relationship. Create partitions in SQL Server Management Studio (SSMS).
B. Create a multidimensional project and define measures and a reference relationship. Create partitions in SQL Server Data Tools (SSDT).
C. Create a tabular project and define measures. Create partitions in SQL Server Data Tools (SSDT).
D. Create a tabular project and define calculated columns. Create partitions in SQL Server Management Studio (SSMS).
Answer: A