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

You have a business intelligence (BI) infrastructure.
You create a SQL Server Integration Services (SSIS) project that contains the packages for the BI infrastructure.
You need to automate the deployment of the SSIS project. The solution must ensure that the deployment can occur as part of an unattended Transact-SQL script.
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.

正解：

Explanation
Box 1:

Box 2:

Box 3:

You need to create the Sales Reporting shared SSRS data source.
Which SSRS data connection type should you use?

• A.OLE DB
• B.Microsoft SQL Server
• C.ODBC
• D.OData

You are designing aggregations for a SQL Server Analysis Services (SSAS) cube.
You need to ensure that every aggregation excludes the Category attribute.
Which option should you select?
To answer, select the appropriate option in the answer area.

正解：

Explanation

You are developing the database schema for a SQL Server Analysis Services (SSAS) BI Semantic Model (BISM). The BISM will be based on the schema displayed in the following graphic.

You have the following requirements:
* Ensure that queries of the data model correctly display average student age by class.
* Ensure that the solution supports role-based security and partitions.
* Minimize development effort.
You need to design the data model.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Create a tabular project and define measures. Create partitions in SQL Server Data Tools (SSDT).
• B.Create a multidimensional project and define measures and a many-to-many dimensional relationship.
  Create partitions in SQL Server Management Studio (SSMS).
• C.Create a tabular project and define calculated columns. Create partitions in SQL Server Management Studio (SSMS).
• D.Create a multidimensional project and define measures and a reference relationship. Create partitions in SQL Server Data Tools (SSDT).

You need to select a method of moving data from the staging tables to the factOrders table.
What type of Transact-SQL (T-SQL) statement should you use?

• A.ALTER PARTITION-SWITCH
• B.SELECT...INTO
• C.ALTER PARTITION FUNCTION
• D.ALTER TABLE...SWITCH
• E.INSERT INTO...SELECT