070-470 무료 덤프문제 온라인 액세스
| 시험코드: | 070-470 |
| 시험이름: | Recertification for MCSE: Business Intelligence |
| 인증사: | Microsoft |
| 무료 덤프 문항수: | 316 |
| 업로드 날짜: | 2026-10-12 |
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?
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.)
HOTSPOT
You are designing a SQL Server Integration Services (SSIS) package configuration strategy.
The package configuration must meet the following requirements:
--
Include multiple properties in a configuration.
Support several packages with different configuration settings.
You need to select the appropriate configuration. Which configuration type should you use?
To answer, select the appropriate option from the drop-down list in the dialog box.
DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package to add a large amount of data to a fact table named factOrders. The factOrders table is partitioned by week and has a clustered index.
You need to load three weeks' data into the factOrders table by using the most efficient method.
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.
HOTSPOT
You are developing a SQL Server Reporting Services (SSRS) solution.
You plan to create reports based on a SQL Server Analysis Services (SSAS) tabular
database configured in DirectQuery mode.
You need to configure a shared data source.
Which data source type should you use?
To answer, select the appropriate type from the drop-down list in the answer area.
