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

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 MEASURES.CURRENTMEMBER[CONTINENT] IS EUROPE
• B.You should utilize ANCESTOR(GEOGRAPHY.CURRENTMEMBER) IS EUROPE
• C.You should utilize MEASURES.CURRENTMEMBER IS EUROPE
• D.You should utilize ANCESTOR(GEOGRAPHY.CURRENTMEMBER,[CONTINENT]) IS EUROPE

You are the administrator of your company network. And you have been assigned a task to develop a SQL Server 2008 data warehousing project. An online transaction processing
(OLTP) system is the source database for the project. During business time, the OLTP system executes 4,200 transactions every minute. And it records only the date and time of insertion of a new row and not for the updates of existing rows. You intend to develop an extract, transform, and load (ETL) process for the project which populates a data warehouse from the source database. When developing the ETL process, it must be configured in the following manner:1. To run after business hours2. To capture new rows and existing rows that have been modifiedYou have to make sure that only new rows or modified rows from the database tables are processed by the ETL process. So what should you do?

• A.You should configure the data warehouse database to support the Type I Slowly Changing Dimension transformation.
• B.You should configure the Change Data Capture feature on all the source database tables that will be processed by the ETL process.
• C.You should configure the data warehouse database to support the Type II Slowly Changing Dimension transformation.
• D.You should configure the Change Data Capture feature on all the data warehouse database tables that will be processed by the ETL process.

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to design a logging strategy for a SQL Server 2008 Integration Services (SSIS) solution. The SSIS solution contains 15 packages. You want to log detailed information about each package. You need to ensure that custom events specific to each control flow task in each package are logged. What should you do?

• A.Configure logging for each control flow task in each package for the required events.
• B.Enable event handling for each control flow task in each package for the required events. Create custom code to perform the logging by using a Script component.
• C.Enable the Log Events window in Business Intelligence Development Studio (BIDS) that has the SSIS solution loaded.
• D.Create a custom assembly that writes to the log, and use the assembly in a Script task. Ensure that the Script task is connected to the appropriate control flow task by using a Failure precedence constraint.

You design a Business Intelligence (BI) solution by using SQL Server 2008. Your solution includes a data mining structure that uses SQL Server 2008 Analysis Services (SSAS) as its data source. The measure groups use 100 percent multidimensional online analytical processing (MOLAP) storage. You need to provide detailed information on the training and test data to ensure the accuracy of the mining model. You also need to minimize the time required to create the training and test data. Which two tasks should you perform? (Each correct answer presents part of the solution. Choose two.)

• A.Use a Sort Data Flow transformation.
• B.Create a new mining structure that has a holdout value.
• C.Use an ORDER BY clause in the Data Flow source query. Define a SortKeyPosition ordinal key for the appropriate output column.
• D.Perform cross-validation queries to the test and training data.
• E.Create a SQL Sever 2008 Integration Services (SSIS) package that partitions test and training datasets and merges case and nested tables.

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to transform vehicle survey data from a flat file to a data warehouse. You need to design a solution that performs the following tasks:
-Redirect data of vehicle owners to a table named DimOwner.
-Redirect data of vehicle enthusiasts to a table named DimEnthusiast.
-Log each record's key along with the data transfer date to an audit table.
What should you do?

• A.Use a Multicast component to redirect data to the audit table and to a Conditional Split component. Use the Conditional Split component to redirect the data to the DimOwner and DimEnthusiast tables.
• B.Use a Conditional Split component to redirect data to the audit table and to a second Conditional Split component. Use the second Conditional Split component to redirect the data to the DimOwner and DimEnthusiast tables.
• C.Use a Conditional Split component to redirect data to the audit table and to a Multicast component. Use the Multicast component to redirect the data to the DimOwner and DimEnthusiast tables.
• D.Use a Multicast component to redirect data to the audit table and to a second Multicast component. Use the second Multicast component to redirect the data to the DimOwner and DimEnthusiast tables.