默认题库 - MCITP(70-446)

单选题

You need to meet the requirements of the accounts team. What should you do?（）

A. Set the Dimension type to Currency.
B. Set the Currency member name as a unique attribute.
C. Hide non-leaf data within the Currency dimension key attribute.
Disable the All member of the Currency dimension key attribute.

查看答案

单选题

You need to record package and task outcome in the ETLAudit table. Which components of SSIS should you use?（）

A. Custom event handlers
B. Data flow error output
C. SSIS log provider for SQL Server
D. Execute SQL tasks with failure precedence constraint

查看答案

单选题

You need to identify the data mining algorithm that meets the requirements of the credit department. Which algorithm should you use?（）

A. Microsoft Clustering
B. Microsoft Decision Tree
C. Microsoft Nave Bayes
D. Microsoft Associatio

查看答案

单选题

You need to meet the business requirements of the packaging department. What should you do?（）

Add the ProductSize data table and the ProductSizeDescriptor column to the Product dimension. Set the order of the ProductSKU attribute to the ProductSizeDescriptor column.
B. Add the ProductSize data table as a dimension and then add this dimension to the cube as a Referenced dimension. Set the order of the key attribute of the ProductSize dimension to the ProductSizeDescriptor column.
C. Add the ProductSize data table and the ProductSizeDescriptor column to the Product dimension. Create a user-defined hierarchy that has ProductSKU as the top-level attribute and ProductSizeDescriptor as the bottom-level attribute.
D. Add the ProductSize data table as a dimension and then add this dimension to the cube as a Referenced dimension. Create a user-defined hierarchy within the ProductSize dimension. Set the ProductSizeDescriptor attribute as the top-level attribute.

查看答案

单选题

You need to maintain the partitions on the ProductOrderStatus measure group. What should you do?（）

A. Create a Microsoft SQL Server 2005 Integration Services （SSIS） package that alters the partition queries and processes aggregated partitions every evening.
B. Enable proactive caching on the partitions. Set the cache to update periodically with a latency of 24 hours.
C. Set the rebuild interval of the partitions to 36 hours. Create a Microsoft SQL Server 2005 Integration Services （SSIS） package that processes aggregated partitions every evening.
D. Enable proactive caching on the ProductOrderStatus measure group. Set scheduled polling that re-processes the measure group whenever the system dates change.

查看答案

单选题

You need to ensure that the new sales manager is able to view clients within only the North and South regions. What should you do?（）

Add a Denied member set for the West clients to NorthRole.
B. Add an Allowed member set for the South clients to NorthRole.
Create a new role for the sales manager and add a Denied member set for the South clients.
D. Create a new role for the sales manager and add an Allowed member set for the South clients. Remove the sales manager from SouthAndWestRole.

查看答案

单选题

You need to ensure the Order Control team is able to track the number of orders that reach the production department. What should you do?（）

A. Create a new Time dimension based on the Holiday table. Use derived columns for the month and the year.
B. Create a Server Time dimension. Within this dimension， enable the time periods year， month， and date. Select the Additional Manufacturing calendar option.
Create a new Time dimension based on the date values within the ProductOrderStatus table. Flag those days on which no orders were received as Holiday.
D. Create a new Time dimension based on a data source view named query. Derive the data for this data source view from unique dates within the ProductOrderStatus table. Use a subquery to identify the holidays and derived columns for the month and the year.

查看答案

单选题

You need to resolve the double counting of transactions issue in the existing reports. What should you do?（）

Apply a many-to-many relationship between the Transaction measure group and the Person dimension in the WoodgroveSSAS database.
B. Apply a Conditional Split transformation in the Transaction data in the SSIS package.
C. Delete the AccountHolder table in the WoodgroveDW database.
D. Apply a foreign key relationship between the Person table and the Transaction table in the WoodgroveDW database.

查看答案

单选题

You need to meet the fraud detection requirements. What should you do?（）

A. Use Percentage Sampling in SSI
B. Use a Neural Network Data mining algorithm.
Create an SSAS Key Performance Indicator for each account.
D. Monitor transactions by using SQL Server Profiler.

查看答案