本番の時間配分に不安がある場合は、70-448の模擬試験形式で解答ペースを確認する練習が役立ちます。Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenanに対応したFast2testの147問の問題集なら、知識の定着と時間管理をあわせて鍛えられます。

70-448試験対策に選べる3つの学習形式

• PDF版：印刷して持ち運べる形式で、専門家が作成した内容をすぐにダウンロードして確認できます。学習場所を選ばず、365日間の無料更新と無料PDFサンプルに対応しています。
• Desktop Test Engine：インストールして使用するソフトウェアで、実際の試験環境を再現した2つの練習モードを利用できます。オフライン学習に対応し、Windowsで動作します。
• Online Test Engine：ブラウザーからすぐにアクセスでき、学習履歴と成績を確認できます。Windows、Mac、Android、iOSで利用できます。

Fast2testの安心な購入・利用サポート

• McAfeeのセキュリティサービスにより、お客様の情報を安全に取り扱います。
• ご購入後365日間は無料で更新版をご利用いただけます。更新期間の終了後も、50%割引で継続更新が可能です。
• ご入金確認後はすぐにダウンロードでき、通常1分以内にメールでもお届けします。2時間経っても届かない場合は、カスタマーサポートへご連絡ください。
• インストール可能なパソコン台数に制限はありません。

Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenanの試験情報

Microsoft 70-448 試験概要:

70-448試験の出題範囲

Microsoft 70-448 試験シラバストピック:

70-448試験の疑問を解消するFAQ

Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan 認定 70-448 試験問題：

問題 #1

You are developing a SQL Server 2008 Integration Services (SSIS) data flow that extracts data from two
sources.
Each source database is located on a different server. Each source is based on a SELECT statement that
uses an ORDER BY clause.
The data flow is as shown in the following diagram.
When the paths from the two sources are connected to a Merge Join component, the following error
message is displayed:
"Data Flow Task: The input is not sorted. The 'input "Merge Join Left Input" (80)' must be sorted."
You need to ensure that data from each query is included in each row in the data flow. You want to achieve
this goal by using minimum amount of execution time.
What should you do?

A. Add a Sort transformation for each data flow.
B. Add an OLE DB Command transformation for each data flow.
C. Replace the Merge Join transformation with a Union All transformation.
D. Update the sorting properties in each source component.

問題 #2

You maintain SQL Server 2008 Integration Services (SSIS) on a SQL Server 2008 instance. You need to design a failure recovery plan for packages that are deployed to a SQL Server. What should you do?

A. Back up the model database.
B. Back up the master database.
C. Back up the tempdb databse.
D. Back up the MSDB database.

問題 #3

You create a SQL Server 2008 Analysis Services (SSAS) solution. You have a dimension named Account and a time dimension named Time. You have a fact table that contains a column named CurrentBalance. CurrentBalance contains the current account balance. You need to create a measure named AccountBalance from the CurrentBalance column to display the closing account balance for a time period. What should you do?

A. Set the AggregationFunction property of AccountBalance to FirstNonEmpty.
B. Set the AggregationFunction property of AccountBalance to ByAccount.
C. Set the AggregationFunction property of AccountBalance to LastNonEmpty.
D. Set the AggregationFunction property of AccountBalance to Sum.

問題 #4

You design a package by using SQL Server 2008 Integration Services (SSIS). The package is designed by using your local development environment.
The package extracts data from a remote server and inserts it in the PROD database on the local SQL
Server 2008 instance. You deploy the package to the MSDB database on the production server.
You need to ensure that only users that belong to an appropriate database role can modify and execute the
deployed package. You also need to ensure that these users cannot access other packages that are
deployed to the server.
What should you do?

A. Assign the users to the db_ssisltduser role.
B. Assign the users to a custom database role in the MSDB database.
C. Assign the users to a custom database role in the PROD database.
D. Assign the users to the db_ssisoperator role.

問題 #5

You create a SQL Server 2008 Reporting Services (SSRS) report.
The report contains a tablE.You need to ensure that alternate rows in the table have a pale green
backgrounD.Which code segment should you use for each text box?

A. =iif(CountRows() / 2, "PaleGreen", "White")
B. =iif(CountRows() Mod 2, "PaleGreen", "White")
C. =iif(RowNumber(Nothing) Mod 2, "PaleGreen", "White")
D. =iif(RowNumber(Nothing) / 2, "PaleGreen", "White")

解説：