Microsoft 070-767 Value Pack (Frequently Bought Together)

You have a fact table in a data warehouse that stores financial data. The table contains eight column configured as shown in the following table.

You need to identify a column that can be aggregated across all dimensions.
Which column should you identify?

• A. StockID
• B. MarketID
• C. NumberOfTrades
• D. OpeningPrice

Note: This question is part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenarios is exactly the same in each question in this series.
You are developing a Master Data Management (MDM) solution for a company by using Microsoft SQL Server Integration Services (SSIS), SQL Server Master Data Services (MDS), and SQL Server Data Quality Services (DQS).
You have an MDS model named Geography that contains the entities described in the following table.

You define a domain-based attribute in the State entity that references the CountryRegion entity. You define another domain-based attribute in the city entity that references the State and CountryRegion entities. A single derived hierarchy named Geography supports navigation between the CountryRegion, State, and City levels.
Subscription views exist for all entities. The subscription views have the same name as the entity on which they are based.
You initialize each entity member. New City entity members are imported daily based on customer city values in a Customer Relationship Management (CRM) database. The CRM database is a SQL Server relational database. When new cities are imported from the CRM database, the state codes must be standardized to those already defined in the State entity.
In the CRM database, sales managers and assigned to countries/regions. A sales manager may be assigned to one or more countries/regions. A country/region may have one or more assigned sales managers. The CRM database contains a table named ManagerCountryRegion that stores a row for each manager-country/region relationship.
You create the following MDS users and map each user to an Active Directory Domain Services (AD DS) user account: User1, User2, and User3. Both User1 and User2 belong to the Explorer functional area.
Users must be able to complete the tasks described in the following table.

You need to perform the initial data loading process of the DQS knowledge base, based on the CountryRegion Entity in the MDS model.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Note: This question is part of a series of questions that use the same or 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 are implementing a Microsoft SQL Server data warehouse with a multi-dimensional data model. You are optimizing the data model across multiple cubes.
You examine the existing data model and observe that each cube contains multiple date dimension tables.
You need to optimize the data model in and across cubes without changing the overall table structure.
What should you use?

• A. slowly changing dimension (SCD)
• B. dimension table reference relationship
• C. semi-additive measure
• D. non-additive measure
• E. snowflake schema
• F. conformed dimension
• G. star schema
• H. fact table

You manage a data warehouse. You have a source table named dbo.Table1.
You need to implement Change Data Capture (CDC) for the queries.

Which CDC object should you use for each query? To answer, drag the appropriate objects to the correct queries. Each object may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

You have a data quality project that focuses on the Products catalog for the company. The data includes a product reference number.
The product reference should use the following format: Two letters followed by an asterisk and then four or five numbers. An example of a valid number is XX*55522. Any reference number that does not conform to the format must be rejected during the data cleansing.
You need to add a Data Quality Services (DQS) domain rule in the Products domain.
Which rule should you use?

• A. value matches regular expression AZ[*]1234[5]
• B. value matches pattern ZA*9876[5]
• C. value matches pattern [a-zA-Z][a-zA-Z]*[0-9][0-9] [0-9][0-9] [0-9]?
• D. value matches pattern AZ[*]1234[5]