最新的Microsoft 070-452免費考試真題

問題1

You design a SQL Server 2008 Analysis Services (SSAS) solution. The solution has dimensions named Account and Scenario. The Scenario dimension has the keys numbered 1 and 2 for the members named Actual and Budget, respectively. The Account dimension has the key numbered 40 for the member named Income. You create a key performance indicator (KPI) named Net Income that has the following parameters: KPI Value: ( [Account].[Accounts].&[40], [Scenario].[Scenario].&[1], [Measures].[Amount] ) KPI Goal: ( [Account].[Accounts].&[40], [Scenario].[Scenario].&[2], [Measures].[Amount] ) If the net income is less than 70 percent of the budgeted value, the performance is considered as bad. If the net income is greater than or equal to 90 percent of the budgeted value, the performance is considered as good. You need to calculate the performance at a specific point in time. What should you do?

A. Set the Status expression in the KPI to the following code segment: Case When KpiGoal( "Net Income" ) / KpiValue( "Net Income" ) >= .90 Then 1 When KpiGoal( "Net Income" ) / KpiValue( "Net Income" ) < .90 And KpiGoal( "Net Income" ) / KpiValue( "Net Income" ) >= .70 Then 0 Else -1 End

B. Set the Trend expression in the KPI to the following code segment: Case When KpiGoal( "Net Income" ) / KpiValue( "Net Income" ) >= .90 Then 1 When KpiGoal( "Net Income" ) / KpiValue( "Net Income" ) < .90 And KpiGoal( "Net Income" ) / KpiValue( "Net Income" ) >= .70 Then 0 Else -1 End

C. Set the Trend expression in the KPI to the following code segment: Case When KpiValue( "Net Income" ) / KpiGoal( "Net Income" ) >= .90 Then 1 When KpiValue( "Net Income" ) / KpiGoal( "Net Income" ) < .90 And KpiValue( "Net Income" ) / KpiGoal( "Net Income" ) >= .70 Then 0 Else -1 End

D. Set the Status expression in the KPI to the following code segment: Case When KpiValue( "Net Income" ) / KpiGoal( "Net Income" ) >= .90 Then 1 When KpiValue( "Net Income" ) / KpiGoal( "Net Income" ) < .90 And KpiValue( "Net Income" ) / KpiGoal( "Net Income" ) >= .70 Then 0 Else -1 End

正確答案: D

問題2

You design a Business Intelligence (BI) solution by using SQL Server 2008. You need to load data into your online transaction processing (OLTP) database once a week by using data from a flat file. The file contains all the details about new employees who joined your company last week. The data must be loaded into the tables shown in the exhibit. (Click the Exhibit button.) Employee.EmployeeID is an identity.

A SQL Server 2008 Integration Services (SSIS) package contains one data flow for each of the destination
tables. In the Employee Data Flow, an OLE DB Command transformation executes a stored procedure that
loads the Employee record and returns the EmployeeID value.
You need to accomplish the following tasks:
-Ensure that the EmployeeID is used as a foreign key (FK) in all child tables for the correct Employee
record.
-Minimize the number of round trips to the database.
-Ensure that the package performs in the most efficient manner possible.
What should you do?

A. After the Employee table is loaded, write the data to a Flat File Destination and use the flat file as a source for each of the subsequent Data Flows.

B. After the Employee table is loaded, write the data to a Raw File Destination and use the raw file as a source for each of the subsequent Data Flows.

C. Use a Lookup Transformation in each of the child table data flows to find the EmployeeID based on first name and last name.

D. Store the EmployeeID values in SSIS variables and use the variables to populate the FK columns in each of the child tables.

正確答案: B

問題3

You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution includes a SQL Server 2008 Analysis Services (SSAS) database. The database contains a data mining structure that uses a SQL Server 2008 table as a data source. A table named OrderDetails contains detailed information on product sales. The OrderDetails table includes a column named Markup. You build a data mining model by using the Microsoft Decision Trees algorithm. You classify Markup as discretized content. The algorithm produces a large number of branches for Markup and results in low confidence ratings on predictable columns. You need to verify whether the Markup values include inaccurate data. What should you do?

A. Modify the content type of Markup as Continuous.

B. Create a data mining dimension in the SSAS database from OrderDetails.

C. Create a cube in SSAS. Use OrderDetails as a measure group. Recreate the data mining structure and mining model from the cube data.

D. Create a data profile by using SQL Server 2008 Integration Services (SSIS).

正確答案: D

問題4

You are the administrator of your company network. You use SQL Server 2008 to develop a Business Intelligence (BI) solution. You intend to create a SQL Server 2008 Reporting Services (SSRS) solution. Developers generate random reports against a data source that contains 180 tables. Power users generate random reports against five of the 180 tables. You have to design a strategy for the SSRS solution to satisfy the following requirements: Use as little development effort as possible.Supply the developers group and the power users group with two sets of tables in SSRS.So which strategy will you use?

A. You should create a Report Builder model by using all the tables and create a perspective within the model to use only the five frequently used tables.

B. You should create a Report Builder model by using all the tables. Create two folders. Place the five frequently used tables in the first folder and the remaining

C. You should create two Data Source Views. Include all the tables in one Data Source View and the five frequently used tables in the other Data Source View.

D. You should create two Report Builder models. Include the five frequently used tables in the first model and include all the tables in the second model.

正確答案: A

問題5

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008
Analysis Services (SSAS) solution. The solution contains a cube that has a measure named SalesAmount.
The measure contains customer sales data for the last six months. The cube has a single partition that has
the storage property set to real-time hybrid online analytical processing (HOLAP).
Queries against the cube must return current sales data that is entered one hour before cube processing.
The partition takes two hours to process and the response time for the queries is slow. You need to
improve the cube processing and query response time.
What should you do?

A. Create a partition for every month. Set the storage setting of the partition for the current month to low-latency multidimensional online analytical processing (MOLAP) and that of the other partitions to MOLAP.

B. Change the storage setting of the partition to real-time relational online analytical processing (ROLAP).

C. Create a partition for each customer. Set the storage setting of every partition to low-latency multidimensional online analytical processing (MOLAP).

D. Change the storage setting of the partition to multidimensional online analytical processing (MOLAP).

正確答案: A

問題6

You administer a server that runs SQL Server 2008 Integration Services (SSIS) packages.
The packages are stored on the file system.
You need to integrate the backup and restore processes for the SSIS packages along with the regular SQL
Server backup process.
What should you do?

A. In the ProtectionLevel package property, select the DontSaveSensitive option.

B. In the ProtectionLevel package property, select the ServerStorage option.

C. Deploy the packages to SQL Server 2008 and back up the master system database.

D. Deploy the packages to SQL Server 2008 and back up the msdb system database.

正確答案: D

問題7

You are the administrator of your company network. You use SQL Server 2008 to develop a Business Intelligence (BI) solution. You intend to configure a SQL Server 2008Analysis Services (SSAS) cube which reads from a remote data source and increases several measure groups by 1 million rows everyday. The cube includes 110 million Fact rows and 600 dimension attributes. You intend to increase the number of users by 200 percent for the cube. During cube processing, you must capture the baseline performance on the overall system. So what should you do?

A. You should monitor cube processing events by using the sp_trace_setfilter system stored procedure.

B. You should configure the data collector to collect Performance Counters statistics during cube processing.

C. You should configure the data collector to collect Query Activity statistics during cube processing.

D. You should monitor cube processing events by using the sp_monitor system stored procedure.

正確答案: C

問題8

You design a SQL Server 2008 Analysis Services (SSAS) solution. The data source view has tables as shown in the exhibit. (Click the Exhibit button.)

The FactInternetSales measure will be queried frequently based on the city and country of the customer.
You need to design a cube that will provide optimal performance for queries.
Which design should you choose?

A. Create a dimension named Customer by joining the DimGeography and DimCustomer tables. Add an attribute relationship from CustomerKey to City and from City to Country. Create a regular relationship in the cube between the Customer dimension and the FactInternetSales measure.

B. Create two dimensions named Customer and Geography from the DimCustomer table and the DimGeography table, respectively. Create an unmaterialized reference relationship between the Geography dimension and the FactInternetSales measure by using the Customer dimension as an intermediate dimension.

C. Create a dimension named Customer by joining the DimGeography and DimCustomer tables. Add an attribute relationship from CustomerKey to City and from CustomerKey to Country. Create a regular relationship in the cube between the Customer dimension and the FactInternetSales measure.

D. Create two dimensions named Customer and Geography from the DimCustomer table and the DimGeography table, respectively. Create a materialized reference relationship between the Geography dimension and the FactInternetSales measure by using the Customer dimension as an intermediate dimension.

正確答案: A

問題9

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. Store all configuration information in a SQL Server table. Specify configuration database connectivity settings 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. 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.

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.

正確答案: A

問題10

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 native server mode.

B. Deploy SSRS on the primary node of the cluster.

C. Deploy SSRS in a scale-out deployment on the Web farm.

D. Configure SSRS for integrated server mode.

正確答案: C

最新的Microsoft PRO:MS SQL Server 2008, Designing a Business Intelligence - 070-452免費考試真題

聯系我們

站內鏈接

最新更新