70-470 Exam
70-470 discount pack（151 to 160） for IT examinee: Nov 2021 Edition
Master the 70-470 Recertification for MCSE: Business Intelligence content and be ready for exam day success quickly with this Pass4sure 70-470 free exam. We guarantee it!We make it a reality and give you real 70-470 questions in our Microsoft 70-470 braindumps.Latest 100% VALID Microsoft 70-470 Exam Questions Dumps at below page. You can use our Microsoft 70-470 braindumps and pass your exam.
Q151. HOTSPOT - (Topic 9)
A school stores information about teachers, students, classes, and enrollments in a Microsoft Azure SQL Database database. The database includes a table that maps the user IDs of teachers to the subjects they teach.
Teachers access reports in a SQL Server Reporting Services (SSRS) instance by using their credentials.
You are developing a report that displays a table of class enrollments for a specific subject. The report will prompt teachers to select from their mapped subjects. The table is based on a dataset named ClassData. To minimize report execution time, the ClassData dataset has been configured to cache all class enrollment data.
You need to ensure that the report displays the correct class enrollment data.
Which item should you configure?
To answer, select the appropriate item in the answer area.
Answer:
Q152. DRAG DROP - (Topic 10)
You are developing a SQL Server Analysis Services (S5AS) cube. The cube consists of a
single measure group.
The measure group consists of one partition that uses MOLAP.
The proactive caching policy has the following requirements:
..
The cache must be updated when data is changed in the table named tbIOrders. Changes must be notified through the use of the XML for Analysis (XMLA) NotifyTableChange command.
You need to configure the proactive caching policy to meet the requirements.
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:
Q153. DRAG DROP - (Topic 3)
You need to configure the attribute relationship types for the Salesperson dimension.
Which configuration should you use?
To answer, drag the appropriate pair of attributes and attribute relationships from the list to the correct location or locations in the answer area. (Answer choices may be used once, more than once, or not all.)
Answer:
Q154. - (Topic 10)
You develop a SQL Server Analysis Services (SSAS) tabular project. The tabular model loads data from a SQL Server 2012 relational database each day.
You define a connection.
You need to ensure that the connection minimizes the attack surface area of the server.
How should you define the impersonation information for the connection? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Use the credentials of the SQL Server Analysis Services (SSAS) service account. Grant least privilege to this account in the source database.
B. Use your domain credentials. Grant least privilege to your account in the source database.
C. Create and use a new Windows domain account. Grant least privilege to this account in the source database.
D. Use SQL Server authentication.
Answer: C
Q155. DRAG DROP - (Topic 10)
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.)
Answer:
Q156. - (Topic 10)
You are developing a SQL Server Reporting Services (SSRS) sales summary report. The report header consists of several images.
You need to ensure that the header of the report is hidden when a user exports the report to PDF format.
Which Hidden property expression should you use for the report header? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. = True
B. = False
C. = (Globals!RenderFormat.Name = "PDF")
D. = (Globals!RenderFormat.IsInteractive = False)
Answer: C
Q157. - (Topic 6)
You need to select the appropriate mode for the Sales database.
Which mode should you select?
A. ROLAP
B. Direct Query
C. MOLAP
D. In-Memory
Answer: B
Q158. DRAG DROP - (Topic 9)
You are designing a SQL Server Integration Services (SSIS) package to execute 12 Transact-SQL (T-SQL) statements on a SQL Azure database.
The T-SQL statements may be executed in any order. The T-SQL statements have unpredictable execution times.
You have the following requirements:
. The package must maximize parallel processing of the T-SQL statements. . After all the T-SQL statements have completed, a Send Mail task must notify administrators.
You need to design the SSIS package.
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:
Q159. - (Topic 10)
You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains several dimensions, a local measure group, and a linked measure group. Both measure groups use MOLAP partitions.
You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable What-If Analysis.
What should you do before the partition can be write-enabled?
A. Implement the linked measure group as a local measure group.
B. Implement the local measure group as a linked measure group.
C. Set the Type property of the partition's measure group to Forecast.
D. Set the StorageMode property of the linked measure group to Rolap.
Answer: A
Q160. - (Topic 10)
You are developing a tabular Business Intelligence Semantic Model (BISM) database based on a SQL Server database.
In the data source, the FactInternetSales table is partitioned by month. Data from the current month has been updated and new data has been inserted in the FactInternetSales table, in the DimProduct table, and in the DimCustomer table.
In the model, the FactInternetSales table is also partitioned by month.
You need to ensure that the model has the most recent data while minimizing the processing time.
What should you do?
A. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer cable with the Process Defrag processing option. Then process the database with the Process Recalc processing option.
B. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Clear processing option. Then process the database with the Process Data processing option.
C. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Data processing option. Then process the database with the Process Defrag processing option.
D. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Clear processing option. Then process the database with the Process Full processing option.
E. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Data processing option. Then process the database with the Process Recalc processing option.
Answer: D
300. - (Topic 10)
You are designing a SQL Server Reporting Services (SSRS) report based on a SQL Server Analysis Services (SSAS) cube. The cube is used to measure sales growth by salesperson.
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 flag.
Which report item should you add?
A. A Sparkline
B. A Gauge that uses the Radial type
C. An Indicator
D. A Gauge that uses the Linear type
E. A Data Bar
Answer: C