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

You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution will support a
Microsoft ASP.NET application that is deployed to a Web farm. Reports will be deployed to a SQL Server
2008 Reporting Services (SSRS) instance. The databases for the SSRS instance will be deployed to a two-
node failover cluster that hosts a single instance of SQL Server 2008.
You need to ensure that the SSRS instance remains available even when one of the servers fails.
What should you do?

• A.Configure SSRS for integrated server mode.
• B.Configure SSRS for native server mode.
• C.Deploy SSRS in a scale-out deployment on the Web farm.
• D.Deploy SSRS on the primary node of the cluster.

You are the administrator of your company network. You use SQL Server 2008 to develop a Business Intelligence (BI) solution. And you develop a SQL Server 2008 Reporting Services (SSRS) solution. You use Microsoft Visual Studio .NET 2008 to create reports. The manager of your company asks to create 60 SSRS reports. You mustmake sure that the company logo and the company name are included in the page header of all the reports. So what should you do?

• A.You should create an SSRS report and include the required page header in the report. And use the report as a template for all the reports.
• B.You should create a SSRS report and include the required page header in the report. Copy the report definition to an XML file and add the XML file as a data
• C.You should create a SSRS report and include the required page header in the report. Create a class library that includes the report and add the class library as an
• D.You should create an SSRS report and include the required page header in the report and create a subreport that refers to the report. Include the subreport to all

You design a Business Intelligence (BI) solution by using SQL Server 2008. Your company processes all
transaction data in a Point of Sale (POS) application. Based on the transaction data, you design a solution
to predict the type of products a customer tends to purchase on a single visit.
You need to identify the appropriate algorithm to design the solution.
Which algorithm should you use?

• A.Naive Bayes
• B.Association Rules
• C.Time Series
• D.Clustering

You design a Business Intelligence (BI) solution by using SQL Server 2008. You have a SQL Server 2008 Integration Services (SSIS) package that runs against a SQL Server 2008 data source. The package contains an opening Execute SQL task that runs the BEGIN TRANSACTION command. This is followed by a Sequence task that contains additional Execute SQL tasks, each with the FailParentOnFailure property set to TRUE . There are two Execute SQL tasks. The first task is connected to a Success precedence constraint that runs the COMMIT TRANSACTION command. The next task is connected to a Failure precedence constraint that runs the ROLLBACK TRANSACTION command. The package fails but the transaction is not rolled back. You need to ensure that the transaction is successfully rolled back if the package fails. What should you do?

• A.Modify the TransactionOption property as Required for each Execute SQL task.
• B.Modify the RetainSameConnection property as True for the Connection Object.
• C.Modify the IsolationLevel property as ReadCommitted for each Execute SQL task.
• D.Modify the TransactionOption property as Required for the Sequence Container.

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 dimension-level security on the Market Location dimension.
• B.Create a new reference dimension that joins Windows user names and their allowed market locations. Implement dimension-level security on the new reference dimension.
• C.Implement drillthrough security on the cube.
• D.Implement cell-level security on the cube.