You create a materialized reference dimension between a dimension named Regions and a measure group named Orders.
You use a table named Customers as a bridge as shown in the exhibit. (Click the Exhibit button.)

You need to ensure that data is updated to reflect any changes in the relationship. The solution must NOT require that the entire cube be reprocessed.
What should you reprocess?

• A. The Sales partition
• B. The Regions dimension
• C. The Customers dimension
• D. The Orders partition

The Sales database includes a table named Products that contains 42 columns, and two tables that record all product sales transactions. The database does not store aggregated data. The database is continually maintained to provide optimal indexing. The database server is sized appropriately.
The Marketing department requests a delimited text file that includes seven fields containing product information from the Products table. You have the following requirements:
- Display the ProductID in the first column. Organize the remaining columns alphabetically by column heading.
---
Sort rows in ProductID order.
Aggregate product units sold.
Minimize the time required to return the results.
You create a SQL Server Integration Services (SSIS) package and add the appropriate connection managers and a Data Flow task.
You need to develop the Data Flow task.
What should you add to the Data Flow task? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. A table-based OLE DB source; a Script component and a Flat File destination.
• B. A SQL command-based OLE DB source; Aggregate and Sort transformations; and a Flat File destination.
• C. A table-based OLE DB source; Lookup, Aggregate, and Sort transformations; and a Flat File destination.
• D. Only a SQL command-based OLE DB source and a Flat File destination.

Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.
You are designing a SQL Server Analysis Services (SSAS) cube.
You need to create a measure to count unique customers.
What should you do?

• A. Create a new named calculation in the data source view to calculate a rolling sum. Add a measure that uses the Max aggregate function based on the named calculation.
• B. Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.
• C. Add a measure that uses the DistinctCount aggregate function to an existing measure group.
• D. Add a measure group that has one measure that uses the DistinctCount aggregate function.
• E. Add a measure that uses the Count aggregate function to an existing measure group.
• F. Use the Business Intelligence Wizard to define dimension intelligence.
• G. Use role playing dimensions.
• H. Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.
• I. Create a dimension with one attribute hierarchy. Set the IsAggrcgatable property to False and then set the DefaultMember property. Use a regular relationship between the dimension and measure group.
• J. Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.
• K. Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
• L. Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
• M. Create several dimensions. Add each dimension to the cube.
• N. Create a dimension. Then add a cube dimension and link it several times to the measure group.
• O. Create a dimension with one attribute hierarchy. Set the ValueColumn property, set the IsAggregatable property to False, and then set the DefaultMember property. Configure the cube dimension so that it does not have a relationship with the measure group. Add a calculated measure that uses the MemberValue attribute property.

You need to grant appropriate permissions to the SSISOwners SQL Server login. What should you do?

• A. Map the login to the SSISDB database. Assign the user to the db.ssisadmin role.
• B. Map the login to the SSISDB database. Assign the user to the db_owner role.
• C. Map the login to the SSISDB database. Assign the user to the ssis.admin role.
• D. Map the login to the msdb database. Assign the user to the ssis_admin role.
• E. Map the login to the msdb database. Assign the user to the db_ssisadmin role.
• F. Map the login to the msdb database. Assign the user to the db_owner role.