passquick

0愛的鼓勵 0訂閱站台

70-448 Exam

TS:MS SQL Server 2008.Business Intelligence Dev & Maintenan

科目編號：70-448

科目名稱：TS:MS SQL Server 2008.Business Intelligence Dev & Maintenan

語言：    英語，法語，德語，日語，俄語，西班牙語，葡萄牙語（巴西），中文（簡體）

考生：    IT專業人士

技術：    微軟SQL Server 2008

類型：    監考考試

Passquick題庫價格：$ 108.00 $ 28.50

70-448 考試是 Microsoft 公司的 TS:MS SQL Server 2008.Business Intelligence Dev & Maintenan 認證考試官方代號，TS:MS SQL Server 2008.Business Intelligence Dev & Maintenan 認證作為全球IT領域專家 Microsoft 熱門認證之一，是許多大中IT企業選擇人才標準的必備條件。

Microsoft70-448考試總綱：

Implementing an SSIS Solution (17%)

Configuring, Deploying, and Maintaining SSIS (15%)

Implementing an SSAS Solution (21%)

Configuring, Deploying, and Maintaining SSAS (17%)

Implementing an SSRS Solution (17%)

Configuring, Deploying, and Maintaining SSRS (13%)

70-448題庫：

19. You implement a SQL Server 2008 Integration Services (SSIS) package.

The package contains the following components:

A data flow task contained in a For Loop container

A Flat File destination component that uses a Flat File connection manager

An OnError event handler

When an error occurs in the package, you plan to write diagnostic information from an expression that includes the

version of the package to a text file.

You need to ensure that the required information is written to the text file.

What should you do?

A.Use the VersionGUID variable.

B.Use the ExecutionGUID variable.

C.Use the SourceID variable.

D.Use the TaskID variable.

Answer: A

20. You design a SQL Server 2008 Integration Services (SSIS) package. The package extracts data from flat files and

loads this data to a SQL Server 2008 database.

The package contains two Boolean variables named @IsWeekday and @IsHoliday. When the package is executed

on week days, the @IsWeekday variable is set to True. When the package is executed on holidays, the @IsHoliday

variable is set to TruE.You need to implement the following business logic in the control flow of the package:

When the @IsWeekday variable is set to True, the Perform Weekday Processing Data Flow task is executed.

When the @IsWeekday variable is set to False, the Perform Weekend Processing Data Flow task is executed.

When the @IsHoliday variable is set to True, the Perform Holiday Processing Data Flow task is executed.

Which control flow logic should you implement?

A.

B.

C.

D.

Answer: A

感謝Passquick帶來熱門Microsoft認證考試資料！