70-460 試験問題を無料オンラインアクセス

DRAG DROP
You are developing a SQL Server Analysis Services (SAS) multidimensional project that is configured to source data from a SQL Azure database.
You plan to use multiple servers to process different partitions simultaneously. You create and configure a new data source.
You need to create a new partition and configure SQL Server Analysis Services (SSAS) to use a remote server to process data contained within the partition.
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.)

正解：

A production SQL Server Analysis Services (SSAS) cube is processed daily. The users query facts by using a hierarchy named Geography from a dimension named Geography.
The DimGeography table in the data source view is used as the source of the Geography dimension. The table has the following structure.

The Geography dimension has three attribute hierarchies:
---
City
State-Province
Country
The attributes have the following relationships defined: City > State-Province > Country. Each attribute has a key and a name sourced from the related key and name columns in the DimGeography table.
During processing, you receive the following error message: "Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_DimGeography, Column: StateProvinceKey', Value: '23'. The attribute is 'State-Province'."
You verify that the data is accurate.
You need to ensure that the dimension processes successfully.
What should you do?

• A.Remove the duplicate data from the DimGeography table.
• B.Delete the Geography hierarchy.
• C.Remove the State-Province attribute.
• D.Relate the State-Province and Country attributes directly to the City attribute.

You need to use SQL Server Management Studio (SSMS) to make the SSAS databases available for application testing.
What should you do?

• A.Script the databases as a Create script to a new window and then execute the script on SSAS01.
• B.Detach the SSAS databases from the SSASCluster, and then attach them to SSAS01.
• C.Use the Import/Export Wizard to copy the databases from the production server to the development server.
• D.Restore the SSAS databases from the latest backup to SSAS01.

You are developing a SQL Server Analysis Services (SSAS) cube named Sales Planning. The cube consists of two measure groups named Sales and Planning. Each measure group is based on a data warehouse fact table and consists of a single MOLAP partition that has the same name as its measure group.
The Planning measure group consists of two measures:
- Forecast, which uses the Sum aggregate function
- Forecast Count, which uses the Count aggregate function
Users contribute planning values by using a legacy application. An extract, transform, load (ETL) process is scheduled to periodically transfer the planning values from the database of the legacy application to the data warehouse.
Financial analysts query the Sales Planning cube and report that the planning values are sometimes out of date. A new company requirement mandates that the planning values be entered directly into the cube by using Microsoft Excel 2010 PivotTable What-If Analysis.
You need to write-enable the Planning partition.
What should you do before write-enabling the partition?

• A.Set the StorageMode property of the Planning partition to Rolap
• B.Remove the Forecast Count measure.
• C.Set the ProcessingMode property of the Planning measure group to LazyAggregations.
• D.Set the Type property of the Planning measure group to Budget.
• E.Convert the Planning measure group to a linked measure group.
• F.Set the ProcessingMode property of the Planning partition to LazyAggregations.

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.

正解：