070-452 무료 덤프문제 온라인 액세스

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to design a dimensional modeling strategy for a new data warehouse. The data warehouse has a dimension table named Employees. The Employees dimension table contains information about the employees and their departments. Employees are moved to different departments frequently. You need to preserve the historical information of the Employees table. Which dimensional model should you use?

• A.Role-Playing Dimension
• B.Degenerated Dimension
• C.Type I Slowly Changing Dimension
• D.Type II Slowly Changing Dimension

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to transform sales data from a retail sales outlet database to a SQL Server 2008 data warehouse by using SQL Server 2008 Integration Services (SSIS). The retail sales database is an online transaction processing (OLTP) database that processes large amounts of transactions twenty-four hours a day. You need to design the structure of the SSIS packages such that the performance of the source system is minimally affected. What should you do?

• A.Load data from the source to a staging database four times a day at regular intervals of time. Then, transform the data to the data warehouse once a day.
• B.Load data from the source to a staging database once a day. Then, transform the data to the data warehouse.
• C.Load and transform data from the source directly to the data warehouse four times a day at regular intervals of time.
• D.Load and transform data from the source directly to the data warehouse once a day.

You are the administrator of your company network. You use Server 2008 to develop a Business Intelligence (BI) solution. The instance includes an SQL Server 2008 Analysis Services (SSAS) database which contains a cube named Sales. And the sales cube has a role
named roleAfrica and a dimension named locality which has a hierarchy that contains the following members: City, egion, Continent.You intend to develop the security configuration for the Sales cube. You have to enable the Read permissions for the roleAfrica role. You also have to ensure that the roleAfrica role can access only the Fact rows that are members of the Africa continent. So which Multidimensional Expressions (MDX) statement should you utilize?

• A.You should utilize ANCESTOR(GEOGRAPHY.CURRENTMEMBER) IS EUROPE
• B.You should utilize ANCESTOR(GEOGRAPHY.CURRENTMEMBER,[CONTINENT]) IS EUROPE
• C.You should utilize MEASURES.CURRENTMEMBER IS EUROPE
• D.You should utilize MEASURES.CURRENTMEMBER[CONTINENT] IS EUROPE

You administer a SQL Server 2008 Reporting Services (SSRS) environment. You restore the ReportServer and ReportServerTempDB databases to a new server. When you browse to the Report Manager Web page, you receive an error message. You are unable to view the folder structure and the reports. You need to view the folder structure and the reports. What should you do?

• A.Restore the msdb database.
• B.Restore the master database.
• C.Restore the symmetric key.
• D.Configure the IIS virtual directory.

You design a SQL Server 2008 Analysis Services (SSAS) solution. Your solution has a cube. The structure
of the cube is as shown in the exhibit. (Click the Exhibit button.)
Each branch does transactions by using the local currency of the country in which it is located. Daily
exchange rates for all local currencies are recorded against the U.S. dollar in the FactCurrencyRate
measure group.
All transactions must be reported in U.S. dollars.
You need to prepare the cube to define currency conversion.
What should you do?
Exhibit:

• A.Create a reference relationship between FactSales and Currency.
• B.Create a many-to-many relationship between FactSales and Currency.
• C.Create a reference relationship between FactCurrencyRate and Branch.
• D.Create a many-to-many relationship between FactCurrencyRate and Branch.