070-470試験無料問題集（316題）「Microsoft Recertification for MCSE: Business Intelligence 認定」

出題：1

DRAG DROP
You have a single SQL Server 2008 R2 Analysis Services (SSAS) instance. You are planning to upgrade the instance to SQL Server 2012.
You need to import an existing PowerPivot workbook to create a tabular project.
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.)

正解：

出題：2

---
A SQL Server Analysis Services (SSAS) cube contains a large measure group. The fact table supporting the measure group is loaded with new data throughout the day.
You have the following requirements:
Ensure that the cube displays current data as quickly as possible.
Maximize availability of the cube.
Maximize query performance for all aggregation levels.
You need to choose a partitioning strategy that meets the requirements.
Which partitioning strategy should you choose? (More than one answer choice may achieve the goal. Select the BEST answer.)

A. Create one partition for the current day that uses relational OLAP (ROLAP) as a storage mode.

B. Create one partition for the current day that uses multidimensional OLAP (MOLAP) as a storage mode. Process the partition each night.

C. Create one partition for the current month that uses hybrid OLAP (HOLAP) as a storage mode.

D. Create one partition for the current day that uses multidimensional OLAP (MOLAP) with proactive caching as a storage mode.

正解：D 解答を投票する

出題：3

You need to ascertain why Marc did not receive his reports.
What should you do?

A. Use SQL Server Management Studio to search the SQL Server logs for errors.

B. Use the Windows Event Viewer to search the Application log for errors.

C. Search the ReportServerService_<timestamp>.log file for errors.

D. Search the registry for errors.

正解：D 解答を投票する

出題：4

DRAG DROP
You are the administrator of a SQL Server Integration Services (SSIS) catalog. You have
access to the original password that was used to create the SSIS catalog. A full database backup of the SSISDB database on the production server is made each day. The server used for disaster recovery has an operational SSIS catalog.
The production server that hosts the SSISDB database fails.
Sensitive data that is encrypted in the SSISDB database must not be lost.
You need to restore the production SSIS catalog to the disaster recovery server.
Which three steps 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.

正解：

出題：5

You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A system role named Developer Support is present on the server.
Members of the Developer Support role cannot modify the report execution timeout period.
You need to enable members of the Developer Support role to modify the report execution timeout period.
Which task should you add to the Developer Support role?

A. Manage jobs

B. Manage shared schedules

C. Execute report definitions

D. Manage report server properties

正解：D 解答を投票する

出題：6

You need to create the Package Activity report.
What should you do?

A. Create a log table and build a custom log provider to write to the log table. Then create an SSRS report that uses the log table.

B. Create an SSRS report that uses thecatalog.executions and catalog.execution_data_statistics views.

C. Use the SSIS log provider for SQL Server. Then create an SSRS report that uses the sysssislog table.

D. Create a log table and use SSIS event handlers to write to the log table. Then create an SSRS report that uses the log table.

正解：B 解答を投票する

出題：7

You need to recommend a partitioning strategy that meets the performance requirements for CUBE1.
What should you include in the recommendation?

A. Createa separate dimension for each distinct count attribute.

B. Createone measure group for all distinct count measures.

C. Createone dimension for all distinct count attributes.

D. Create separate measure groups for each distinct count measure.

正解：D 解答を投票する

出題：8

A large manufacturing company has manufacturing plants in many states. Each state has a dedicated SQL Server instance that stores its manufacturing data. Each SQL Server instance is configured identically and all instances have identical database structures.
You are developing a daily report that summarizes information on manufacturing activity.
The report has the following requirements:
It must have a state name as one of the report parameters.
It must provide a daily summary of manufacturing activity of a selected state.
It must require minimal development and maintenance effort.
You need to develop the report to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A. Build a centralized data repository, schedule a regular Extract, Transform, and Load
---
(ETL) process on all manufacturing data, and then use the repository to generate the report.

B. Build one report for each state and instruct users to execute reports as needed.

C. Use a report-specific data source that defines an expression-based connection string based on the state parameter.

D. Use a shared data source that defines an expression-based connection string based on the state parameter.

正解：C 解答を投票する

出題：9

HOTSPOT
A company maintains separate environments for test, production, and quality assurance. The company uses the project deployment model for SQL Server Integration Services (SSIS) deployments.
You create an SSIS project to perform a weekly refresh of the company's data warehouse and cubes. The project has three packages.
You need to configure the project to ensure so that the test and production teams can run each package without manually adding server-specific information.
Which program should you use?
To answer, select the appropriate program in the answer area.

正解：

出題：10

You need to create the KPI in the AdhocReports project in time for the next production release cycle.
What should you do?

A. Create a measure by using the SUM([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value. Check in the changes before the next release cycle.

B. Create a measure by using the SUM([OrderQuantity]) expression. Then use the CREATE KPI CURRENTCUBE statement to define the KPI and target value. Check in the changes before the next release cycle.

C. Create a KPI based on the OrderQuantity column and then set the target value. Check in the changes before the next release cycle.

D. Create a measure by using the COUNT([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value. Check in the changes before the next release cycle.

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：11

DRAG DROP
You need to implement the requirements for the StageFactSales package.
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.)

正解：

出題：12

You are developing a SQL Server Analysis Services (SSAS) tabular project. The model includes a table named Sales. The Sales table includes a single date column.
The Sales table must meet the following requirements:
- Queries must be able to return all rows. - Must be able to support four different processing schedules for different date ranges. - Date ranges must not include any overlapping data.
You need to implement a solution that meets the requirements.
What should you do?

A. Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for all four tables.

B. Create four partitions for the Sales table. Create four roles. Use the same row filter queries for each role and partition.

C. Create four partitions for the Sales table. Use row filter queries for each partition.

D. Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for each of the four tables.

正解：C 解答を投票する

出題：13

You need to configure a parameter for the database connection string.
What should you do?

A. Use a required project parameter.

B. Use a package configuration.

C. Use a global variable.

D. Use a required package parameter.

正解：A 解答を投票する

出題：14

HOTSPOT
You are using a new installation of SQL Server Reporting Services (SSRS) to create three sales reports that consume data from a stored procedure. The stored procedure is defined in a Windows Azure SQL Database.
All reports must pass USA to the Country parameter of the stored procedure. Users cannot change the Country report parameter value.
You need to configure the report parameter properties.
How should you configure the report parameter properties? To answer, select the appropriate setting or settings in the answer area.

正解：

070-470試験無料問題集「Microsoft Recertification for MCSE: Business Intelligence 認定」