exam questions

Exam 70-767 All Questions

View all questions & answers for the 70-767 exam

Exam 70-767 topic 1 question 112 discussion

Actual exam question from Microsoft's 70-767
Question #: 112
Topic #: 1
[All 70-767 Questions]

DRAG DROP -
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,
, and City levels. Subscription views exist for all entities. The subscription views have the same name as the entity on which they are based.

State -
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 add a top level to the Geography hierarchy to navigate from manager to CountryRegion.
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.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer: Explanation
Derived hierarchies come from the relationships between entities in a model. These are domain-based attribute relationships.
A domain-based attribute contains values that are populated by members from an entity and can be used as attribute values for other entities.
References:
https://docs.microsoft.com/en-us/sql/master-data-services/master-data-services-overview-mds

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
m8rvil
Highly Voted 5 years, 3 months ago
1. Add the Manager as the first level of the Geography attribute 2. Add a new entity ManagerCountryRegion based on the ManagerCountryRegion table 3.Create a domain based attr on the Manager entity referencing the ManagerCountryRegion entity
upvoted 10 times
...
Caleb092
Highly Voted 5 years, 5 months ago
I don't quite understand this solution.
upvoted 5 times
...
Slava_bcd81
Most Recent 4 years, 8 months ago
-add City attribute to Manager entity, so manager can be in the Manager-City-CountryRegion hierarchy -change the Geography hierarchy - add Manager
upvoted 1 times
...
bilel
4 years, 10 months ago
I think that the third action should be : create two domain-based attributes on the ManagercountryRegion , one referencing the manager entity and another referencing country region entity
upvoted 3 times
Anette
4 years, 9 months ago
I agree. Here is the full question: https://www.certbus.com/online-pdf/70-767.pdf
upvoted 2 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...