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

You design a Business Intelligence (BI) solution by using SQL Server 2008. You design a SQL Server 2008
Analysis Services (SSAS) solution. Customer data is stored in the tables named CustomerDetails and
CustomerContact.
The solution uses the following two data sources from two different servers:
-Contoso that accesses the CustomerDetails table
-ContosoCRM that accesses the CustomerContact table
You plan to create a dimension named DimCustomer to analyze customer data. You need to ensure that
the DimCustomer dimension represents the tables as a snowflake schema to include attributes from the
two tables.
What should you do?

• A.Create a data source view named DsvCustomer that is associated with the Contoso data source and create a named query in the data source view to select data from the CustomerDetails table.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and create a named query in the data source view to select data from the CustomerContact table.
• B.Create a data source view named DsvCustomer that is associated with the Contoso data source and add the CustomerDetails table to the data source view. Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and add the CustomerContact table to the data source view.
• C.Create a data source view named DsvContoso that is associated with the two data sources and create a named query in the data source view to merge the tables.
• D.Create a data source view named DsvContoso that is associated with the two data sources and add the tables to the data source view.

You design a Business Intelligence (BI) solution by using SQL Server 2008. You develop 10 SQL Server
2008 Integration Services (SSIS) packages. You plan to include package configuration for all the packages.
The package configuration has the following requirements:
-All configurations are stored in a single location.
-Configuration variables are easily backed up and restored.
-Indirect configuration is used.
-The database administrators will use SQL Server client tools to change the configuration values.
You need to create package configurations for the packages to meet the configuration requirements.
What should you do?

• A.Use XML configuration files for all packages. Store each XML configuration file in a common folder. Specify the XML configuration file location in an environment variable.
• B.Store all configuration information in a SQL Server table. Specify configuration database connectivity settings in the SQL Server table.
• C.Store all configuration information in a SQL Server table. Specify configuration database connectivity settings in an environment variable.
• D.Use XML configuration files for all packages. Store each XML configuration file in a common folder. Specify the XML configuration file location in the configuration settings.

You design a Business Intelligence (BI) solution by using SQL Server 2008. Employees use a Windows
Forms application based on Microsoft .NET Framework 3.5. SQL Server is not installed on the employees'
computers.
You write a report by using Report Definition Language (RDL). You need to ensure that if the employees
are disconnected from the corporate network, the application renders the report.
What should you do?

• A.Configure the application to use an SSRS Web service by using the Render method.
• B.Embed ReportViewer in the application and configure ReportViewer to render reports by using the remote processing mode.
• C.Configure the application to use an SSRS Web service by using the RenderStream method.
• D.Embed ReportViewer in the application and configure ReportViewer to render reports by using the local processing mode.

You are the administrator of your company network. And Currently you are in charge of SQL Server 2008 Analysis Services (SSAS) data mining. The customer table contains the following column names: Age Name IsBuyer Customer_key Education Level You intend to create a data mining model by using Microsoft Decision Trees algorithm for the customer table. You have to identify the data columnCmodel parameter pairs to foretell possible buyers. So which model should you choose?

• A.Option B
• B.Option D
• C.Option C
• D.Option A

You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution includes a data
warehouse that has an online transaction processing (OLTP) database as the data source.
The tables in the OLTP database do not include date or time information. On each execution, the SQL
Server 2008 Integration Services (SSIS) package that copies the data must reload and process the entire
dataset.
You plan to improve the process of loading the data warehouse. You need to ensure that the following
requirements are met:
-Only new and modified data is processed.
-All modifications of the rows caused due to insert, update, and delete activities are processed.
-The impact of the loading process on the source system is minimal.
Which action should you perform on the tables that are involved in the load process?

• A.Set up the Change Data Capture (CDC) feature.
• B.Set up the Change Tracking feature.
• C.Create Data Manipulation Language (DML) triggers.
• D.Create timestamp columns.