Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan Sample Questions:

1. 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 report you created, click the Subscriptions tab, and then click the New Subscription button.
C) Select the report you created, click the Subscription tab, and then click the New Data-driven Subscription button.
D) Select the My Subscriptions page, and the click the New Data-driven Subscription button.

2. You administer an instance of a SQL Server 2008 server.
The server is used to execute SQL Server 2008 Integration Services (SSIS) packages.
You need to ensure that the server executes only correctly signed packages.
What should you do?

A) Set the BlockedSignatureStates registry entry to NoAdministrativeRestriction.
B) Set the package protection level on all packages to DontSaveSensitive.
C) Set the BlockedSignatureStates registry entry to Block invalid and untrusted signatures and unsigned
packages.
D) Set the package protection level on all packages to EncryptSensitiveWithPassword.

3. You need to increase the value of the SalesAmount measure by 50% for each month in the first quarter of
2007. You also need to ensure that the value for the first quarter of 2007 remains unchanged.
What should you do?

A) Add the following code segment at line 04. Scope([Measures].[SalesAmount], Descendants([DimTime].[Date].[Quarter]. [Q1 2007] [DimTime].[Date].[Month]) ); This=[DimTime].[Date].currentmember * 1.5; End Scope;
B) Add the following code segment at line 01. Scope([Measures].[Amount], [DimTime].[Date].[Quarter]. [Q1 2007] ); This=[DimTime].[Date].currentmember * 1.5; End Scope;
C) Add the following code segment at line 01. Scope([Measures].[SalesAmount], Descendants([DimTime].[Date].[Quarter].[Q1 2007] [DimTime].[Date].[Month]) ); This=[DimTime].[Date].currentmember * 1.5; End Scope;
D) Add the following code segment at line 04. Scope([Measures].[Amount], [DimTime].[Date].[Quarter]. [Q1 2007] ); This=[DimTime].[Date].currentmember * 1.5; End Scope;

4. 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 master database.
B) Back up the tempdb databse.
C) Back up the MSDB database.
D) Back up the model database.

5. 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 /FILE c:\ SSISpackages|Memberinformation.dstx /COPY SQL; Memberinformation.dtsx
B) dtutil /FILE c:\ SSISpackages|Memberinformation.dstx /DestServer DBPROD /COPY SQL; Memberinformation.dtsx
C) dtexec /f "c: \ Memberinformation .dtsx" /1 " DTS.LogProviderTextFile;Y:\Loginformation.txt"
D) dtutil /FILE c:\SSISpackages\Memberinformation.dtsx /COPY FILE;W: \ProdSSISpackages\ Memberinformation_Prod.dtsx
E) dtutil /SQL Memberinformation /COPY DTS;c:\SSISpackages\Memberinformation
F) dtexec /sq Memberinformation / verify (a400e860-38d5-11c5-11ce-ae62-08002b2b79ef)
G) dtexec /f " Z:\ Memberinformation.dtsx " /conf "
Z: \Memberinformationconfig,cfg "
H) dtexec /sq Memberinformation /ser productionServer / va

Solutions: