Microsoft 070-448 Exam Syllabus Topics:

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

1. You company network includes a SQL Server 2008 R2 database server with the SQL Server 2008 Analysis Services (SSAS) role enabled.
You design a cube named Materials with a measure group named MaterialsInventory. This group has a measure, QualityOnHand, which shows the total stock in inventory for the company by the time.
You need to determine the inventory at the end of the quarter. What should you do?

A) Define the QuantityOnHand measure as an additive measure.
B) Define the QuantityOnHand measure as a semi-additive measure.
C) Define the MaterialsInventory group as a semi-additive measure group.
D) Define the MaterialsInventory group as an additive measure group.

2. You are implementing a disaster recovery strategy for SQL Server 2008 Reporting Services (SSRS).
You want to be able to restore the report catalog database in the event of a failure.
You need to back up the encryption key.
Which command line utility should you use?

A) dtsutil.exe
B) rskeymgmt.exe
C) Rs.exe
D) Rsconfig.exe

3. You update a role named Managers for the Human Resources cube in your SQL Server 2008 Analysis
Services (SSAS) database. The database contains a dimension named Employee.
You plan to configure the security for the Managers role.
You need to allow the Managers role to access aggregate data based on only three or less employees.
What should you do?

A) Add the following expression to the Allow Reading property in Cell Data in the Managers role. Descendants([Employee].[Employees].CurrentMember,,LEAVES).Count <= 3
B) Add the following expression to the Allow Reading property in Cell Data in the Managers role. IIF(Descendants([Employee].[Employees].CurrentMember,,LEAVES).Count <= 3, [Employee]. [Employees].CurrentMember, null)
C) Add members of the [Employee].[Employees] hierarchy that contain more than three children to the allowed set for the Managers role.
D) Add members of the [Employee].[Employees] hierarchy that contain three or less children to the denied set for the Managers role.

4. You create a SQL Server 2008 R2 Analysis Services (SSAS) solution.
You are configuring security settings for a new database role with the following requirements:
Only the West member can be viewed by the database role. All other existing members and any newly
added members of the Region attribute will not be visible. Members in attribute hierarchies that include a
member of the Region attribute remain visible. The members in other attribute hierarchies remain visible.
The state of Washington is visible.
The aggregated totals for the ALL Level and Region attributes include only the values for members that are
visible.
You need to ensure that the database role has these security settings.
What should you do? (Each correct answer presents part of the solution. Choose two.)

A) Set the State attribute's IsAllowed = True, AllowedSet = "Except(Region..Members,{West})", ApplyDenied = True, and VisualTools = False.
B) Set the Region attribute's IsAllowed = True, DeniedSet = "Except(Region..Members,{West})", ApplyDenied = False, and VisualTools = True.
C) Set the Region attribute's IsAllowed = False, DeniedSet = "Except(Region..Members,{West})", ApplyDenied = False, and VisualTools = False.
D) Set the State attribute's IsAllowed = True, AllowedSet = "Except(Region..Members,{West} + {Washington})", ApplyDenied = False, and VisualTools = False.

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 cache hits from the memory when the database is processed.
Which object should you use?

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

Solutions: