70-448試験無料問題集（147題）「Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan 認定」

出題：1

You maintain a report in a SQL Server 2008 Reporting Services (SSRS) instancE.The report contains
query parameters that allow users to filter the contents of the report. The report queries the data source
randomly.
You configure the report to be rendered from a report execution snapshot.
You need to ensure that users can continue to use parameters to filter the report.
What should you do?

A. Remove the filters from the dataset queries. Use the parameters to filter the datasets.

B. Add a default value to all parameters.

C. Move the queries to the stored procedures. Use the stored procedures to populate and filter the datasets of the report.

D. Modify the datasets to use the Table query type.

正解：A 解答を投票する

出題：2

You are an ETL developer for a mortgage company. Your application has two tables names Vendor and Loan.
Vendor
VendorID VendorName 1 VendorA
2 VendorB
3 VendorC
4 VendorD
5 VendorE
Loan
LoanNumber VendorID LoanAmount
I-100 1 120000
I-200 1 130000
I-300 2 150000
I-400 3 155000
I-500 4 160000
I-600 4 170000
I-700 5 180000
You need to build a SQL Server 2008 Integration Services (SSIS) package that meets the following
requirements:
The package should be able to generate the Excel files dynamically. Each file should have the vendor name
as a prefix and the date as the suffix (e.g., VendorA_DDMMYYYY.xlsx).
All the vendor names should be added to a variable and loop through the variable to generate and load
separate files for each vendor dynamically.
Which property in the Excel file destination connection manager should you set with a variable?

A. Name

B. Excel File Path

C. Initial Catalog

D. Provider

正解：B 解答を投票する

出題：3

You create a SQL Server 2008 Analysis Services (SSAS) solution.
You enable proactive caching for a partition.
You need to ensure that SSAS can query relational data when multidimensional storage is being updated.
What should you do?

A. Set the ProcessingMode property for the partition to Regular.

B. Set the OnlineMode property for the partition to OnCacheComplete.

C. Set the ProcessingMode property for the partition to LazyAggregations.

D. Set the OnlineMode property for the partition to Immediate.

正解：D 解答を投票する

出題：4

You create a data mining model by using SQL Server 2008 Analysis Services (SSAS).
You create a mining structure by using the following Data Mining Extensions (DMX) code.
CREATE MINING STRUCTURE [Bike Buyer](
[Customer Key] LONG KEY,
[Age] LONG DISCRETIZED(Automatic, 10),
[Bike Buyer] LONG DISCRETE,
[Commute Distance] TEXT DISCRETE,
[Yearly Income] DOUBLE CONTINUOUS
)
You need to create a mining model that can be processed by using this mining structure. You also need to
ensure that the model uses the Microsoft Decision Trees algorithm.
Which DMX statement should you use?

A. INSERT INTO [Decision Tree] ( [Customer Key], [Age], [Bike Buyer], [Commute Distance], [Yearly Income] ) OPENQUERY([Bike Buyer], ?'Select [Customer Key], [Age], [Bike Buyer] , [Commute Distance],[Yearly Income]' )

B. SELECT * INTO [Decision Tree] USING [Microsoft_Decision_Trees] FROM [Bike Buyer]

C. CREATE MINING MODEL [Decision Tree] ( [Customer Key] LONG KEY, [Age] LONG DISCRETIZED(Automatic, 10), [Bike Buyer] LONG DISCRETE, [Commute Distance] TEXT DISCRETE, [Yearly Income] DOUBLE CONTINUOUS )?USING Microsoft_Decision_Trees

D. ALTER MINING STRUCTURE [Bike Buyer] ADD MINING MODEL [Decision Tree] ( [Customer Key],
[Age],
[Bike Buyer] PREDICT,
[Commute Distance],
[Yearly Income]
)?USING Microsoft_Decision_Trees
WITH DRILLTHROUGH

正解：D 解答を投票する

出題：5

You maintain a SQL Server 2008 Analysis Services (SSAS) instance.
You plan to update only the Products dimension while processing the cube by using an XML for Analysis
(XMLA) script.
You need to ensure that only the dimensions are updated.
What should you do?

A. Execute a processStructure command.

B. Execute a processUpdate command.

C. Execute a processIndex command.

D. Execute a processDefault command.

正解：B 解答を投票する

出題：6

You maintain a SQL Server 2008 Integration Services (SSIS) instancE.The instance stores packages in
a SQL Server 2008 instance.
You need to deploy the package of an instance of SSIS to another SSIS instance that stores its packages in
a shared directory.
What should you do?

A. Execute the dtexecui command.

B. Execute the dtutil command.

C. Execute the dtswizard command.

D. Execute the dtexec command.

正解：B 解答を投票する

出題：7

You design a report by using SQL Server 2008 Reporting Services (SSRS).
Detail information is displayed each time the users render the report.
You need to ensure that the following requirements are met:
Summary information is displayed when the report is initially rendered.
Detail information is displayed only when the users click a column header.
What should you do?

A. On the column that contains detail information, set the hidden property to TruE. Set the Visibility can be toggled by another report item property to False.

B. On the column that contains detail information, set the hidden property to FalsE. Set the Visibility can be toggled by another report item property to False.

C. On the column that contains detail information, set the hidden property to TruE. Set the Visibility can be toggled by another report item property to True.

D. On the column that contains detail information, set the hidden property to FalsE. Set the Visibility can be toggled by another report item property to True.

正解：C 解答を投票する

出題：8

You implement a SQL Server 2008 Analysis Services (SSAS) solution. You use data mining extensions
(DMX) to query a data mining model.
You write the following DMX code segment to query a Bike Buyer data mining model in a Decision Tree
data mining structure. (Line numbers are included for reference only.)
01 SELECT
02 [Decision Tree].[Bike Buyer] AS Buyer
03 FROM
04 [Decision Tree] 06 (SELECT 28 AS [Age],
07 '2-5 Miles' AS [Commute Distance],
08 '1' AS [House Owner Flag],
09 1 AS [Number Cars Owned],
10 2 AS [Total Children]) AS t
You need to ensure that the input columns automatically map to the columns in the data mining structure.
Which code fragment should you insert at line 05?

A. OPEN QUERY

B. INNER JOIN

C. PREDICTION JOIN

D. NATURAL PREDICTION JOIN

正解：D 解答を投票する

出題：9

You update a role named Managers for the Human Resources cube in your SQL Server 2008 Analysis
Services (SSAS) database. The database contains a dimension named Employee.
You plan to configure the security for the Managers role.
You need to allow the Managers role to access aggregate data based on only three or less employees.
What should you do?

A. Add the following expression to the Allow Reading property in Cell Data in the Managers role. Descendants([Employee].[Employees].CurrentMember,,LEAVES).Count <= 3

B. Add the following expression to the Allow Reading property in Cell Data in the Managers role. IIF(Descendants([Employee].[Employees].CurrentMember,,LEAVES).Count <= 3, [Employee]. [Employees].CurrentMember, null)

C. Add members of the [Employee].[Employees] hierarchy that contain three or less children to the denied set for the Managers role.

D. Add members of the [Employee].[Employees] hierarchy that contain more than three children to the allowed set for the Managers role.

正解：A 解答を投票する

70-448試験無料問題集「Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan 認定」