70-470 試験問題を無料オンラインアクセス
| 試験コード: | 70-470 |
| 試験名称: | Recertification for MCSE: Business Intelligence |
| 認定資格: | Microsoft |
| 無料問題数: | 316 |
| 更新日: | 2025-08-27 |
HOTSPOT
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.
You are managing a SQL Server Reporting Services (SSRS) instance.
A website must pass credentials to the local security authority for Reporting Services.
You need to configure Reporting Services to issue a challenge/response when a
connection is made without credentials.
Which authentication type should you configure in the RSReportServer.config file?
You need to implement the Customer Sales and Manufacturing data models.
What should you do? (Each correct answer presents a partial solution. Choose all that apply.)
DRAG DROP
You are the database administrator of a SQL Server 2012 data warehouse implemented as a single database on a production server. The database is constantly updated by using SQL Server Integration Services (SSIS) packages and SQL Server Analysis Services (SSAS) cube writeback operations.
---
The database uses the full recovery model. A backup strategy has been implemented to minimize data loss in the event of hardware failure.
SQL Server Agent jobs have been configured to implement the following backup operations:
A full database backup every day at 12:00 A.M.
Differential database backups every day at 6:00 A.M., 12:00 P.M., and 6:00 P.M.
Transaction log backups every hour on the hour.
At 2:38 P.M. a SSIS package corrupts the data in a fact table. The corruption cannot be undone. You are notified at 3:15 P.M. You immediately take the database offline to prevent further data access and modification.
You need to restore the data warehouse and minimize downtime and data loss.
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.
DRAG DROP
You are designing a dataset for a SQL Server Reporting Services (SSRS) report. The report includes the report items displayed in the following graphic.
The dataset is sourced from a commonly used stored procedure in an inventory data mart hosted in a SQL Azure database.
It returns the status for all products across all storage sites. The report must display data for the storage site that is selected by the Site report parameter. You cannot change the stored procedure code.
You need to filter the dataset to use only data specific to the selected site.
How should you configure the filter?
To answer, drag the appropriate expression or expressions to the correct location or locations in the answer area. (Answer choices may be used once, more than once, or not all.)
