70-452 試験問題を無料オンラインアクセス

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to design a report that
uses data obtained from a SQL Server 2008 Analysis Services (SSAS) instance.
The SSAS cube contains five parentchild key performance indicators (KPIs). Each KPI has nine children.
You need to create an executive dashboard in Microsoft Office SharePoint Server (MOSS) that displays
the KPIs and depicts the parentchild relationship.
Which technology should you use?

• A.Microsoft Office Excel
• B.MOSS KPI Library
• C.Microsoft Office PerformancePoint Server
• D.MOSS Business Data Catalog

You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution includes a SQL
Server 2008 Analysis Services (SSAS) application that resides on a single server.
Data in the SSAS database grows every month.
You need to provide a scalability strategy that meets the following requirements:
-Maximizes the end-user throughput.
-Minimizes daily downtime window due to processing.
-Accommodates an unexpected increase in the number of users.
What should you do?

• A.Scale out the solution by adding more computers and use the Read-Only Database functionality.
• B.Use proactive caching on the server.
• C.Use the multidimensional online analytical processing (MOLAP)enabled write-back capabilities of the Analysis Services.
• D.Add an additional server and use remote partitions.

You are the administrator of your company network. You use SQL Server 2008 to develop a Business Intelligence (BI) solution. The SQL Server 2008 instance hosts a database which is scheduled for a full backup on a monthly basis. The 4-terabyte database contains 3.5 terabyte of data in a read-only filegroup and uses the bulk-logged recovery model. You have to back up the database changes to a tape drive every night while using as little storage space and time as possible. So which backup strategy should you use?

• A.You should use differential backup
• B.You should use Partial backup
• C.You should use file backup
• D.You should use differential Partial backup

You design a SQL Server 2008 Reporting Services (SSRS) solution. The solution contains a report. The
report includes information that is grouped into hierarchical levels. You need to ensure that the solution
meets the following requirements:
When you click each level, the next level of information must be displayed. When you click the last level,
detailed information must be displayed. When the report is exported to a Microsoft Excel spreadsheet, all
the levels and all detailed information must be available in the spreadsheet.
Which feature should the report use?

• A.filter
• B.a document map
• C.drillthrough
• D.drilldown

You are creating a SQL Server 2008 Reporting Services (SSRS) solution for a company that has offices in
different countries. The company has a data server for each country. Sales data for each country is
persisted in the respective data server for the country. Report developers have only Read access to all data
servers. All data servers have the same schema for the database.
You design an SSRS solution to view sales data.
You need to ensure that users are able to easily switch between sales data for different countries.
What should you do?

• A.Implement multiple shared data sources.
• B.Implement an embedded data source that has an expression-based connection string.
• C.Implement an embedded data source that has a static connection string.
• D.Implement a single shared data source.