070-448無料問題集「Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan」

質問 1

You build and deploy a SQL Server 2008 Integration Service (SSIS) package.
During package development, the XML configuration is not specified.
You need to apply the configuration file to the deployed package stored in files system.
Which parameter should you set in the DTEXEC command line utility?

（A）/Set

（B）/L

（C）/conf

（D）/CheckF

正解：C 解答を投票する

質問 2

You implement a SQL Server 2008 Integration Services (SSIS) package. The package contains the following components: A data flow task contained in a For Loop container A Flat File destination component that uses a Flat File connection manager An OnError event handler When an error occurs in the package, you plan to write diagnostic information from an expression that includes the version of the package to a text file.
You need to ensure that the required information is written to the text file. What should you do?

（A）Use the ExecutionGUID variable.

（B）Use the TaskID variable.

（C）Use the SourceID variable.

（D）Use the VersionGUID variable.

正解：D 解答を投票する

質問 3

You create a SQL Server 2008 Analysis Services (SSAS) solution.
The cube structure is as shown in the following exhibit. (Click the Exhibit button.)
You need to ensure that the Amount measure can be aggregated for the DimCustomer dimension.
What should you do?

（A）Create a many-to-many relationship between DimCustomer and FactCustomerAccount. Set FactTransaction as an intermediate measure group.

（B）Create a referenced relationship between DimCustomer and FactCustomerAccount. Set DimAccount as an intermediate dimension.

（C）Create a regular relationship between DimCustomer and FactTransaction.

（D）Create a many-to-many relationship between DimCustomer and FactTransaction. Set FactCustomerAccount as an intermediate measure group.

正解：D 解答を投票する

質問 4

You maintain a SQL Server 2008 Analysis Services (SSAS) database that contains a Product dimension.
The dimension contains the Category and Subcategory attributes.
The attributes have a Rigid relationship typE.The data source for the Product dimension changes the
relationship between the Category and Subcategory values.
You need to execute an XML for Analysis (XMLA) command to process the dimension to successfully
reflect the changE.What should you do?

（A）Use the ProcessUpdate command.

（B）Use the ProcessIndexes command.

（C）Use the ProcessAdd command.

（D）Use the ProcessClear and the ProcessDefault commands.

正解：D 解答を投票する

質問 5

You create a SQL Server 2008 Analysis Services (SSAS) solution. You have a dimension named Account and a time dimension named Time. You have a fact table that contains a column named CurrentBalance. CurrentBalance contains the current account balance. You need to create a measure named AccountBalance from the CurrentBalance column to display the closing account balance for a time period. What should you do?

（A）Set the AggregationFunction property of AccountBalance to ByAccount.

（B）Set the AggregationFunction property of AccountBalance to Sum.

（C）Set the AggregationFunction property of AccountBalance to LastNonEmpty.

（D）Set the AggregationFunction property of AccountBalance to FirstNonEmpty.

正解：C 解答を投票する

質問 6

You maintain a SQL Server 2008 Analysis Services (SSAS) database on a default instancE.You plan to
document the Analysis Services performance information.
You need to collect information related to the temporary file usage when the database is processed.
Which object should you use?

（A）MSAS 2008: Proc Aggregations

（B）MSAS 2008: Cache

（C）MSAS 2008: Memory

（D）MSAS 2008: Storage Engine Query

正解：A 解答を投票する

質問 7

You create a SQL Server 2008 Analysis Services (SSAS) solution. You have a table named Orders that contains the following columns: OrderKey Shipper OrderAmount You create a dimension named DimOrders from the Orders table. You set the OrderKey as a key column and the Shipper column as an attribute. You create a measure group named FactOrders from the Orders table. You need to create a dimension relationship to ensure that the OrderAmount column can be aggregated by the Shipper column. What should you do?

（A）Create a regular dimension relationship between the DimOrders dimension and the FactOrders measure group. Set the Granularity attribute to OrderKey and the measure group columns to OrderAmount.

（B）Create a fact dimension relationship between the DimOrders dimension and the FactOrders measure group.

（C）Set the relationship between the DimOrders dimension and the FactOrders measure group to No Relationship.

（D）Create a regular dimension relationship between the DimOrders dimension and the FactOrders measure group. Set the Granularity attribute to Shipper and the measure group columns to OrderAmount.

正解：B 解答を投票する

質問 8

You design a report by using SQL Server 2008 Reporting Services (SSRS).
The report will be included in a Windows Forms application that is distributed to remote users. These users have access to the report server.
You need to ensure that the application renders the report correctly. What should you do?

（A）Use the ReportViewer control along with the RemoteReport property.

（B）Deploy the report to the report server with a shared dataset.

（C）Use the ReportViewer control along with the LocalReport property.

（D）Deploy the report to the report server after adding an assembly creating a connection to the Windows form application.

正解：A 解答を投票する

質問 9

Note: This question is part of a series of questions that use the same of similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You maintain the SQL Server 2008 Integration Services (SSIS) instance for a healthcare device manufacturing company.
You develop a package named Memberinformation.dtsx with Windows authentication. You deploy it to SQL Server.
You need to validate Memberinformation.dtsx packages without package execution.
Which command syntax should you use?

（A）dtutil /FILE c:\SSISpackages\Memberinformation.dtsx /COPY FILE;W: \ProdSSISpackages\ Memberinformation_Prod.dtsx

（B）dtexec /sq Memberinformation /ser productionServer / va

（C）dtutil /SQL Memberinformation /COPY DTS;c:\SSISpackages\Memberinformation

（D）dtexec /f " Z:\ Memberinformation.dtsx " /conf "
Z: \Memberinformationconfig,cfg "

（E）dtexec /sq Memberinformation / verify (a400e860-38d5-11c5-11ce-ae62-08002b2b79ef)

（F）dtexec /f "c: \ Memberinformation .dtsx" /1 " DTS.LogProviderTextFile;Y:\Loginformation.txt"

（G）dtutil /FILE c:\ SSISpackages|Memberinformation.dstx /COPY SQL; Memberinformation.dtsx

（H）dtutil /FILE c:\ SSISpackages|Memberinformation.dstx /DestServer DBPROD /COPY SQL; Memberinformation.dtsx

正解：B 解答を投票する

質問 10

You have a SQL Server 2008 R2 Analysis Services (SSAS) solution.
You add a new Data Source View (DSV) to the solution. The DSV includes a SalesOrder table with columns for OrderTotal and CostTotal.
You need to derive the profit for each order without modifying the underlying data.
What should you do?

（A）Add a Named Query to the DSV, using Select * from SalesOrder as the expression.

（B）Add a Named Calculation to the SalesOrder table, using OrderTotal + CostTotal as the expression.

（C）Add a Named Calculation to the SalesOrder table, using OrderTotal,CostTotal as the expression.

（D）Create a view, SalesProfit, as Select *, OrderTotal CostTotal as Profit from SalesOrder.

（E）Add a Named Query to the DSV, using Select *,OrderTotal CostTotal from SalesOrder as the expression.

（F）Add a Named Calculation to the SalesOrder table, using OrderTotal CostTotal as the expression.

（G）Create a view, SalesProfit, as Select * from SalesOrder.

（H）Add a Named Query to the DSV and then ass a Named Calculation to that query, using OrderTotal -CostTotal as the expression.

正解：E、F 解答を投票する

070-448 無料問題集「Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan」

弊社を連絡する

関連リンク

トップ試験