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

You design a Business Intelligence (BI) solution by using SQL Server 2008. You develop a SQL Server 2008 Integration Services (SSIS) package to perform an extract, transform, and load (ETL) process from a Microsoft Access database to a SQL Server 2008 data warehouse. The package is developed on a computer that runs a 32-bit operating system. You deploy the package to a server that runs a 64-bit operating system. You create a SQL Server Agent job to run the package. The package fails to run when the job starts. You need to ensure that the package runs successfully. What should you do?

• A.Modify the project of the package by setting the Run64BitRuntime property to TRUE . Rebuild and redeploy the package to the server.
• B.Rebuild the package on a computer that runs a 64-bit operating system. Redeploy the package to the server.
• C.Enable the Use 32 bit runtime option in the job step of the SQL Server Agent job.
• D.Redeploy the package to the Program Files (x86) folder.

You design a Business Intelligence solution by using SQL Server 2008. The solution includes a SQL Server
2008 Analysis Services (SSAS) database. You design a data mining structure. The structure is used by a
data mining model that predicts the expected growth for a particular market location. The model also
populates a data mining dimension named Market Location.
The database includes a cube that contains a calculated member named Predicted Revenue. The
calculated member uses predictions from the data mining model.
You have the following business requirements:
The view shown in the following exhibit must be displayed to consultants. (Click the Exhibit button.)

*The view shown in the following exhibit must be displayed to managers. (Click the Exhibit button.)

You need to design a solution that meets the business requirements. What should you do?

• A.Implement cell-level security on the cube.
• B.Implement dimension-level security on the Market Location dimension.
• C.Create a new reference dimension that joins Windows user names and their allowed market locations. Implement dimension-level security on the new reference dimension.
• D.Implement drillthrough security on the cube.

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Analysis Services (SSAS) solution by using SQL Server 2008. The solution contains a dimension named DimCustomer that represents customers. The solution provides a list of top 10 customers based on the sales amount. End users of the solution analyze data by using filters in Microsoft Excel worksheet. You need to ensure that the list is updated when the filters are applied. Which named set expression should you use?

• A.CREATE DYNAMIC SET CURRENTCUBE.[Top 10 Customer] AS TOPCOUNT([DimCustomer].[Customer].MEMBERS,10,[Measures].[SalesAmount])
• B.CREATE SESSION SET CURRENTCUBE.[Top 10 Customer] AS TOPCOUNT([DimCustomer].[Customer].MEMBERS,10,[Measures].[SalesAmount])
• C.CREATE HIDDEN SET CURRENTCUBE.[Top 10 Customer] AS TOPCOUNT([DimCustomer].[Customer].MEMBERS,10,[Measures].[SalesAmount])
• D.CREATE SET CURRENTCUBE.[Top 10 Customer] AS TOPCOUNT([DimCustomer].[Customer].MEMBERS,10,[Measures].[SalesAmount])

You design a Business Intelligence (BI) solution by using SQL Server 2008. You are building an extract,
transform, and load (ETL) process by using SQL Server 2008 Integration Services (SSIS).
You stage data in a SQL Server 2008 database. You load a data warehouse that has 15 dimension tables
and 3 fact tables.
You need to design a control flow that meets the following requirements:
-Each table must be loaded with its own SSIS package. All packages must be controlled from a master
package.
-Dimension tables must have no interdependencies.
-Dimension tables must load without error before the Fact tables are loaded.
-Master package parallelism must be maximized.
What should you do?

• A.Place the dimension packages in a sequence container. Use a precedence constraint set to Success to connect another sequence container holding the Fact packages. Set the FailParentOnFailure property to True for each dimension package.
• B.Place the dimension packages in a sequence container and connect them by using a precedence constraint set to Success. Use a precedence constraint set to Success to connect another sequence container holding the Fact packages.
• C.Connect the dimension packages by using a precedence constraint set to Success. Connect the Fact packages to the end of the dimension packages by using a precedence constraint set to Success. Set the FailPackageOnFailure property to True for each dimension package.
• D.Place an Execute Package task inside a Foreach Loop container and change the connection string for the Execute Package task on each iteration. Connect the Fact packages to the end of the Foreach Loop container by using a precedence constraint set to Success. Set the FailPackageOnFailure property to True for the Foreach Loop container.

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 master database.
• B.Restore the symmetric key.
• C.Restore the msdb database.
• D.Configure the IIS virtual directory.