Latest MCTS 70-448 Dumps Real Exam Download 51-60

Ensurepass

QUESTION 51

You work for an organization with global operations. You are responsible for the SQL Server 2008 Integration Services (SSIS) instance. You develop SSIS packages to load daily and weekly feeds. These packages are deployed via the SQL Server method.

These servers reside in geographies with a high risk of natural disaster.

You need to implement a disaster recovery plan to back up the SSIS packages for availability.

What should you back up?

 

A. The tempdb database

B. The MSDB database

C. The model database

D. The Microsoft SQL Server90DTSPackage folder.

 

Correct Answer: B

Explanation

Explanation/Reference:

 

 

QUESTION 52

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in this series. Information and details provided in a question apply only to the question.

You maintain the SQL Server 2008 Integration Services (SSIS) instance for a healthcare supply chain data management company. Your company uses third-party event based scheduler.

You develop a package named Memberinformation.dtsx and save it in the SSISpackages folder on the company network.

You need to deploy this package to the ProdSSISpackages file system on the production server. You need to rename the package to

Memberinformation_Prod.dtsx, and the event based scheduler will execute the renamed package.

Which command syntax should you use?

 

A. dtutil /SQL Memberinformation /COPY DTS;c:SSISpackagesMemberinformation

B. dtutil /FILE c:SSISpackagesMemberinformation.dtsx /COPY FILE;W: ProdSSISpackages Memberinformation_Prod.dtsx

C. dtutil /FILE c: SSISpackages|Memberinformation.dstx /DestServer DBPROD /COPY SQL; Memberinformation.dtsx

D. dtutil /FILE c: SSISpackages|Memberinformation.dstx /COPY SQL; Memberinformation.dtsx

E. dtexec /f ” Z: Memberinformation.dtsx ” /conf ”

Z: Memberinformationconfig,cfg ”

F. dtexec /sq Memberinformation / verify (a400e860-38d5-11c5-11ce-ae62-08002b2b79ef)

G. dtexec /sq Memberinformation /ser productionServer / va

H. dtexec /f “c: Memberinformation .dtsx” /1 ” DTS.LogProviderTextFile;Y:Loginformation.txt”

 

Correct Answer: B

Explanation/Reference:

 

 

QUESTION 53

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in the question apply only to that question.

You maintain the SQL Server 2008 integration Services (SSIS) instance for a healthcare supply chain data management company. Your company uses third-party event based scheduler.

You develop a package named Memberinformation.dtsx and save it in the SSIS packages folder on the company network.

You need to deploy this package by connecting with the DBPROD production server SSIS engine. The event based scheduler will execute the deployed SSIS package.

Which command syntax should you use

 

A. dtutil /SQL Memberinformation /COPY DTS;c:SSISpackagesMemberinformation

B. dtutil /FILE c:SSISpackagesMemberinformation.dtsx /COPY FILE;W: ProdSSISpackages Memberinformation_Prod.dtsx

C. dtutil /FILE c: SSISpackages|Memberinformation.dstx /DestServer DBPROD /COPY SQL; Memberinformation.dtsx

D. dtutil /FILE c: SSISpackages|Memberinformation.dstx /COPY SQL; Memberinformation.dtsx

E. dtexec /f ” Z: Memberinformation.dtsx ” /conf ”

Z: Memberinformationconfig,cfg ”

F. dtexec /sq Memberinformation / verify (a400e860-38d5-11c5-11ce-ae62-08002b2b79ef)

G. dtexec /sq Memberinformation /ser productionServer / va

H. dtexec /f “c: Memberinformation .dtsx” /1 ” DTS.LogProviderTextFile;Y:Loginformation.txt”

 

Correct Answer: C

Explanation/Reference:

 

 

QUESTION 54

Note: This question is part of a series of questions that use the same of similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.

You maintain the SQL Server 2008 Integration Services (SSIS) instances for a an insurance company.

You develop a package named Memberinformation.dtsx and save it in the SSISpackages folder on the company network. The package is configured externally to

the file Mamberinformationconfig.cfg.

You need to execute the package.

Which command syntax should you use?

 

A. dtutil /SQL Memberinformation /COPY DTS;c:SSISpackagesMemberinformation

B. dtutil /FILE c:SSISpackagesMemberinformation.dtsx /COPY FILE;W: ProdSSISpackages Memberinformation_Prod.dtsx

C. dtutil /FILE c: SSISpackages|Memberinformation.dstx /DestServer DBPROD /COPY SQL; Memberinformation.dtsx

D. dtutil /FILE c: SSISpackages|Memberinformation.dstx /COPY SQL; Memberinformation.dtsx

E. dtexec /f ” Z: Memberinformation.dtsx ” /conf ”

Z: Memberinformationconfig,cfg ”

F. dtexec /sq Memberinformation / verify (a400e860-38d5-11c5-11ce-ae62-08002b2b79ef)

G. dtexec /sq Memberinformation /ser productionServer / va

H. dtexec /f “c: Memberinformation .dtsx” /1 ” DTS.LogProviderTextFile;Y:Loginformation.txt”

 

Correct Answer: E

Explanation/Reference:

 

 

QUESTION 55

Note: This question is part of a series of questions that use the same of similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.

You maintain the SQL Server 2008 Integration Services (SSIS) instance for a healthcare device manufacturing company.

You develop a package named Memberinformation.dtsx with Windows authentication. You deploy it to SQL Server.

You need to validate Memberinformation.dtsx packages without package execution.

Which command syntax should you use?

 

A. dtutil /SQL Memberinformation /COPY DTS;c:SSISpackagesMemberinformation

B. dtutil /FILE c:SSISpackagesMemberinformation.dtsx /COPY FILE;W: ProdSSISpackages Memberinformation_Prod.dtsx

C. dtutil /FILE c: SSISpackages|Memberinformation.dstx /DestServer DBPROD /COPY SQL; Memberinformation.dtsx

D. dtutil /FILE c: SSISpackages|Memberinformation.dstx /COPY SQL; Memberinformation.dtsx

E. dtexec /f ” Z: Memberinformation.dtsx ” /conf ”

Z: Memberinformationconfig,cfg ”

F. dtexec /sq Memberinformation / verify (a400e860-38d5-11c5-11ce-ae62-08002b2b79ef)

G. dtexec /sq Memberinformation /ser productionServer / va

H. dtexec /f “c: Memberinformation .dtsx” /1 ” DTS.LogProviderTextFile;Y:Loginformation.txt”

 

Correct Answer: G

Explanation/Reference:

 

 

QUESTION 56

You are designing a SQL Server 2008 Integration Services (SSIS) package.

The package includes a Data Flow task that copies several million rows. The data flow requires a match against a reference table that contains 10,000 rows. Each row in the reference table will be used during the data flow.

Same row are not matching due to a mismatched case type

You need to ensure that the data flow executes to match all rows correctly.

Which data flow component should you select?

 

A. A Fuzzy Lookup transformation

B. A Lookup transformation along with the Full cache option

C. A Lookup transformation along with the No cache option

D. A Lookup transformation along with the Partial cache option

 

Correct Answer: C

Explanation

Explanation/Reference:

 

 

QUESTION 57

You create a SQL Server 2008 Analysis Services (SSAS) solution. Your solution has a date dimension named Data along with a hierarchy named Calendar. The

Calendar hierarchy has levels for the Year, Quarter, Month, and Date attributes.

You need to create a named set that refers to July of the year 2007.

Which expression should you write for the named set?

 

A. PeriodsToDate ([DinTime] . [Yr-Qtr-Mth]. [Year], [DimTime] . [Yr-Qtr-Mth] . [Month]. [July 2007])

B. PeriodsToDate ([DinTime] . [Yr-Qtr-Mth]. [Month], [DimTime] . [Yr-Qtr-Mth] . [Month]. [July 2007])

C. ParallelPeriod ([DimTime] . [Yr-Qtr-Mth] . [Year] , 7, [DimTime] . [Yr-Qtr-Mth] . [Month] . [July 2007])

D. ParallelPeriod ([DimTime] . [Yr-Qtr-Mth] . [Month] , 7, [DimTime] . [Yr-Qtr-Mth] . [Month] . [July 2007])

 

Correct Answer: B

Explanation

Explanation/Reference:

 

 

QUESTION 58

You create a report by using SQL Server 2008 Reporting Services (SSRS).

The report is complex and takes several minutes to generate.

You need to configure the report server to run in the morning and have the users access that copy of the report for the remainder of the day.

What should you do?

 

A. Implement report snapshots

B. Implement report execution caching

C. Configure the data source to use snapshot isolation

D. Configure the data source to use a database snapshot

 

Correct Answer: A

Explanation

Explanation/Reference:

 

 

QUESTION 59

Two months ago you created a report by using SQL Server 2008 Reporting Services (SSRS).

The report is already in production and is currently being emailed to the CID every Monday at 8:30am. The CIO wants to report also to be emailed to members of the finance management team.

You need t enable this functionality.

What should you do?

 

A. Select the report you created, and click the New Subscription button.

B. Select the My Subscriptions page, and the click the New Data-driven Subscription button.

C. Select the report you created, click the Subscription tab, and then click the New Data-driven Subscription button.

D. Select the report you created, click the Subscriptions tab, and then click the New Subscription button.

 

Correct Answer: C

Explanation/Reference:

 

 

QUESTION 60

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. clip_image002

B. clip_image004

B. clip_image006

D. clip_image008

 

Correct Answer: A

Explanation/Reference:

 

Download Lates MCTS 70-448 Real Free Tests , help you to pass exam 100%.