Online Access Free 70-452 Exam Questions

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to create a SQL
Server 2008 Reporting Services (SSRS) report. The report must display the list of orders placed through the
Internet.
You need to ensure that the following requirements are met:
-The amount of time required for processing the report is minimal.
-The report contains the most recent data at the end of each business day.
-A report is available for any of the last seven days.
Which type of report should you create?

• A.Linked
• B.Ad Hoc
• C.Snapshot
• D.Cached

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Analysis Services (SSAS) solution that has a dimension table named DimCustomer. The DimCustomer table has the following attributes: -Gender -Address -Marital Status -Phone Number
You discover that DimCustomer takes a long time to process. You need to reduce the processing time of DimCustomer. You also need to reduce the disk space required for the DimCustomer dimension table. What should you do?

• A.Set the AttributeHierarchyEnabled property of the Gender and Marital Status attributes to false.
• B.Set the ProcessingGroup property of DimCustomer to ByTable.
• C.Set the ProcessingGroup property of DimCustomer to ByAttribute.
• D.Set the AttributeHierarchyEnabled property of the Phone Number and Address attributes to false.

You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution includes a SQL
Server 2008 Analysis Services (SSAS) database.
A measure group in the database contains transaction details. The transaction details include the price,
volume of shares, trade type, and several other attributes of each transaction. You need to implement a
data mining model that will estimate the future prices based on the existing transaction data. Which algorithm should the data mining model use?

• A.the Microsoft Neural Network algorithm
• B.the Microsoft Naive Bayes algorithm
• C.the Microsoft Association algorithm
• D.the Microsoft Clustering algorithm

You design a SQL Server 2008 Analysis Services (SSAS) solution. Your solution has a measure named
Sales Amount and a dimension named Date. The Date dimension has a hierarchy named Fiscal that has
levels named Fiscal Year, Fiscal Quarter, and Fiscal Month.
You need to create a calculated member to analyze the Sales Amount share percentage at different levels
compared to the total sales for a given Fiscal Year.
Which code segment should you use?

• A.Case When [Date].[Fiscal].CurrentMember.Level.Ordinal = 0 Then 1 Else [Measures].[Sales Amount]/([Measures].[Sales Amount], [Date].[Fiscal].CurrentMember.Parent) End
• B.Case When [Date].[Fiscal].CurrentMember.Level.Ordinal = 0 Then 1 Else [Measures].[Sales Amount]/([Measures].[Sales Amount], Descendants([Date].[Fiscal].CurrentMember, [Date].[Fiscal].[Fiscal Year], SELF_AND_AFTER)) End
• C.Case When [Date].[Fiscal].CurrentMember.Level.Ordinal = 0 Then 1 Else [Measures].[Sales Amount]/([Measures].[Sales Amount], [Date].[Fiscal].[Fiscal Year].CurrentMember) End
• D.Case When [Date].[Fiscal].CurrentMember.Level.Ordinal = 0 Then 1 Else [Measures].[Sales Amount]/([Measures].[Sales Amount], Ancestor([Date].[Fiscal].CurrentMember, [Date].[Fiscal].[Fiscal Year])) End

You design a Business Intelligence (BI) solution by using SQL Server 2008. Users have no specialized
knowledge of the Transact-SQL (T-SQL) language.
You plan to create a reporting solution by using SQL Server 2008 Reporting Services (SSRS). You have
data stored in a SQL Server 2008 relational data warehouse. You need to ensure that users are able to
create the necessary reports by using data from the data warehouse.
What should you do?

• A.Create a Report Model from the data warehouse. Instruct the users to use Report Designer in Business Intelligence Development Studio (BIDS) to create the reports by using the Report Model.
• B.Create a shared data source that points to the data warehouse. Instruct the users to use Report Designer in Business Intelligence Development Studio (BIDS) to create the reports by using the shared data source.
• C.Create a Report Model from the data warehouse. Instruct the users to use Report Builder 2.0 to create the reports by using the Report Model.
• D.Create a shared data source that point to the data warehouse. Instruct the users to use Report Builder 2.0 to create the reports by using the shared data source.