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

1. 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 04. Scope([Measures].[Amount], [DimTime].[Date].[Quarter]. [Q1 2007] ); This=[DimTime].[Date].currentmember * 1.5; End Scope;
D) 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;

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

3. You maintain a SQL Server 2008 Analysis Services (SSAS) database.
You plan to troubleshoot query performance by using SQL Profiler.
You need to identify the queries that take a long time to run.
Which trace event should you use?

A) Query Cube End
B) Query Subcube
C) MDX Script End
D) Get Data from Cache

4. You maintain a SQL Server 2008 Analysis Services (SSAS) database. You create a new measure group
in one of the cubes.
You have a program that maintains partitions on the production copy of the cube.
You need to update the cube definition on the production server without overwriting any existing partitions.
What should you do?

A) Use the Business Intelligence Development Studio (BIDS) and set the processing option to Do Not Process.
B) Execute an UPDATE CUBE statement in Microsoft SQL Server Management Studio (SSMS).
C) Use the Analysis Services Destination component in Microsoft SQL Server Integration Services (SSIS).
D) Use the Deployment Wizard along with the appropriate options.

5. You maintain a SQL Server 2008 Analysis Services (SSAS) database on a default instancE.You plan to
document the Analysis Services performance information.
You need to collect information related to the temporary file usage when the database is processed.
Which object should you use?

A) MSAS 2008: Storage Engine Query
B) MSAS 2008: Proc Aggregations
C) MSAS 2008: Memory
D) MSAS 2008: Cache

Solutions: