Online Access Free 70-448 Exam Questions

You design a report by using SQL Server 2008 Reporting Services (SSRS).
The report uses a Table data region and contains a dataset. The dataset has a column named LastName.
You need to ensure that the report items are grouped by the first character in the LastName column.
Which expression in the Group properties dialog box should you use?

• A.=First(Fields!LastName)
• B.=Fields!LastName.Value
• C.=Fields!LastName.Value.Substring(0,1)
• D.=First(Fields!LastName.Value)

You create a SQL Server 2008 Reporting Services (SSRS) report.
The report contains a tablE.You need to ensure that alternate rows in the table have a pale green
backgrounD.Which code segment should you use for each text box?

• A.=iif(RowNumber(Nothing) Mod 2, "PaleGreen", "White")
• B.=iif(CountRows() / 2, "PaleGreen", "White")
• C.=iif(RowNumber(Nothing) / 2, "PaleGreen", "White")
• D.=iif(CountRows() Mod 2, "PaleGreen", "White")

You are developing a SQL Server 2008 Integration Services (SSIS) data flow that loads data to a SQL Server 2008 database.
You need to ensure that the data flow updates the existing records and inserts the updated records into the SQL Server database by using data from the rows in your data flow.
Which three data flow components should you use? (Each correct answer presents part of the solution. Choose three.)

• A.Conditional Split Transformation
• B.Lookup Transformation
• C.OLE DB Destination
• D.Data Conversion Transformation
• E.OLE DB Command Transformation

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 Region attribute's IsAllowed = True, DeniedSet = "Except(Region..Members,{West})", ApplyDenied = False, and VisualTools = True.
• B.Set the State attribute's IsAllowed = True, AllowedSet = "Except(Region..Members,{West} + {Washington})", ApplyDenied = False, and VisualTools = False.
• 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})", ApplyDenied = True, and VisualTools = False.

You create a SQL Server 2008 Analysis Services (SSAS) solution. The cube structure is as shown in the
following exhibit. (Click the Exhibit button.)
The Ownership column contains decimal values that represent percentage of ownership. The sum of all the
values in the Ownership column for a single DimAccount member is 100%.
You create the following measures:
Ownership
Amount
You need to ensure that when the Amount measure is calculated against the DimCustomer dimension, the
weighted value is calculated based on the Ownership measure.
What should you do?

• A.Set the FormatString property of the Amount measure to [Amount]*[Ownership].
• B.Set the MeasureExpression property of the Amount measure to [Amount]*[Ownership].
• C.Set the MeasureExpression property of the Amount measure to [DimCustomer].[Amount]*[Ownership].
• D.Set the FormatString property of the Amount measure to [DimCustomer].[Amount]*[Ownership].