Exam MS-100 All Questions

View all questions & answers for the MS-100 exam

Exam MS-100 topic 2 question 61 discussion

Actual exam question from Microsoft's MS-100

Question #: 61
Topic #: 2

HOTSPOT -
You have a Microsoft 365 E5 subscription that contains an Azure Active Directory (Azure AD) tenant named contoso.com. The tenant contains a Microsoft
SharePoint Online site named Site1 and the accounts shown in the following table.

You have an on-premises server named Server1 that contains a folder named Folder1. Folder1 contains the files shown in the following table.

The User1, User2, and Group1 accounts have the security identifiers (SIDs) shown in the following table.

You use the SharePoint Migration Tool to migrate Folder1 to Site1. You preserve the file share permissions and use the following user mapping file.
S-1-5-21-4534338-1127018997-2609994386-1304, [email protected], FALSE
S-1-5-21-4534338-1127018997-2609994386-1228, [email protected], FALSE
S-1-5-21-4534338-1127018997-2609994386-1106, GroupA, TRUE
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point
Hot Area:

Show Suggested Answer

Suggested Answer:

by dngd at April 12, 2021, 7:18 a.m.

Comments

Submit Cancel

dngd

Highly Voted 4 years, 2 months ago

Correct, You don't specify owner in User mapping file: Column A: From the source location, enter the log in name of the user. Required. Column B: On the destination site, enter the principal username. Required. Column C: If the principal username on the destination site is an Active Directory (AD) group, enter TRUE. If it's not an AD group, enter FALSE. Required. https://docs.microsoft.com/en-us/sharepointmigration/mm-user-mapping-file

upvoted 21 times

NHaikes

2 years, 11 months ago

This is also relevant: https://docs.microsoft.com/en-us/sharepointmigration/understanding-permissions-when-migrating No ownership is given, only full-control, which may be interpreted as ownership.

upvoted 4 times

cscorrupt

2 years, 8 months ago

Correct. It says "For Full control permission, the file will be migrated as Full control in SPO". So noone is owner of anything, thus NNN.

upvoted 3 times

Storm

2 years, 1 month ago

Super - Good to know

upvoted 1 times

...

lucidgreen

4 years, 2 months ago

Besides that, it doesn't indicate anywhere that the users were owners in the first place! If I didn't know any better, that would be the first thing I look for. Dumb, dumb question...

upvoted 20 times

tf444

3 years, 6 months ago

Agreed %100.

upvoted 5 times

...

bLINDmONKEY

Highly Voted 3 years, 9 months ago

Sure is a tricky question if you haven't done an SPMT before. The mapping file is correct and will give the Full Control users and groups owner permissions. The mapping file maps the onprem users and groups to the AAD users and groups. To do this is maps the SIDs stored in the file/folder properties to the AAD users or groups appropriately. So User1 is mapped to UserA etc. If you have DirSync\AD Connect then you don't have to worry about the mapping if you have everything synced nicely. So the answer is actually YNY - User B is just a member thanks to the modify permissions. Tell me otherwise.

upvoted 16 times

Durden871

3 years, 3 months ago

What if there are more than one member with Full Control?

upvoted 2 times

...

Archie_Bunker

3 years, 8 months ago

Agree with bLINDmONKEY. The TRUE/FALSE in the User Mapping File is for declaring if it's a group or not, and users with Full Control rights in Sharepoint are listed as Owners. Answer is YNY

upvoted 3 times

jinxie

3 years, 7 months ago

I disagree, as far as I can tell it's false for all. The user's current rights will be migrated but I do not see anything of owner there. user1 and group1 will just receive full control on the file. and user 2 will indeed be a member but nowhere does it specify file owner.

upvoted 2 times

Storm

3 years, 3 months ago

Why not test before answering? Full Control translates to owner in sharepoint

upvoted 3 times

...

Paolo2022

2 years, 7 months ago

I don't find any evidence for what you write. https://learn.microsoft.com/en-us/sharepointmigration/understanding-permissions-when-migrating#what-happens-to-the-permissions-on-a-file-when-it-is-migrated This source says: "There are three types of permissions that will be migrated: Read, Write, and Full control. If a file has Write permission for user1, then the file will be set to Contribute for user1 in SPO. If a file has Read permission for user1, then the file will be set to Read for user1 in SPO. For Full control permission, the file will be migrated as Full control in SPO." Ownership - and especially the "translation" of Full Control to ownership - that you talk about - isn't mentioned. I don't have a way to test this - as everyone else commenting here. But my approach to the answers provided is that you need good reason to go against them. I don't see that in this case.

upvoted 1 times

...

ijarosova

Most Recent 2 years, 3 months ago

I vote Y|N|N

upvoted 1 times

...

Monk16

2 years, 9 months ago

Answer YNY --You have the Full Control permission level -- If you can change the content and the settings on the site you belong to the Owners group which has the Full Control permission level. https://support.microsoft.com/en-gb/office/understand-groups-and-permissions-on-a-sharepoint-site-258e5f33-1b5a-4766-a503-d86655cf950d

upvoted 1 times

...

forummj

3 years, 1 month ago

Based on https://docs.microsoft.com/en-us/sharepointmigration/understanding-permissions-when-migrating I'm going to go for an answer of YNY - Specifically, the "Permissions conditions and results" portion of the link above. My reasoning is that Full Control permissions are only provided to those users in the Owners Group of a document library, and because Full Control on-prem AD is translated to Full Control on SP, it stands to reason that User1 will be made an Owner of that file/library. Likewise, User2 will not due to only having the Modify on-prem permission, which will translate to Edit, Members group in SP. GroupA will be migrated to a new group that has Full Control permission. Although they won't be in a named group of Owners, they will still have the same effective permissions. Hell, I'm probably wrong, but the logic appears sound to me.

upvoted 1 times

...

joergsi

3 years, 5 months ago

Checking this out: https://docs.microsoft.com/en-us/sharepointmigration/understanding-permissions-when-migrating You find the following about migration of user rights: There are three types of permissions that will be migrated: Read, Write, and Full control. - If a file has Write permission for user1, then the file will be set to Contribute for user1 in SPO. - If a file has Read permission for user1, then the file will be set to Read for user1 in SPO. - For Full control permission, the file will be migrated as Full control in SPO. => Call me a nitpicker, transfer of ownership is not mentioned here at all!

upvoted 3 times

...

joergsi

3 years, 5 months ago

User Mapping File information: https://docs.microsoft.com/en-us/sharepointmigration/create-a-user-mapping-file-for-data-content-migration

upvoted 2 times

...

LillyLiver

3 years, 5 months ago

I haven't ever user the SPMT. So this question was not super easy for me. Since there is a lot of back-and-forth in the discussions on this question, I setup my tenant to match the conditions of this question to get the actual answer. I also matched my on-prem user accounts and the files to migrate. Same user permissions on the files, same permission preservation on the files in SPMT, and same User Mapping file. The answers are: UserA is the owner: Yes UserB is the owner: No GroupA is the owner: Yes It looks like it really comes down to that Full Control perm on the file share. If a user has that level permission, then they will also be an owner in the SPO site after migration. So I 2/3's don't agree with the given answer to this question. It's possible I f'ed this practical test up somehow, but the SPMT is pretty straight forward and there isn't a lot of ambiguity in the use. So I am confident with my results.

upvoted 9 times

...

kanag1

3 years, 5 months ago

The Given Answer is correct. Please refer the link attached below. If a file has Write permission for user1, then the file will be set to Contribute for user1 in SPO. If a file has Read permission for user1, then the file will be set to Read for user1 in SPO. For Full control permission, the file will be migrated as Full control in SPO. ##Nothing mentioned about converting a Full control to owner## Reference: https://docs.microsoft.com/en-us/sharepointmigration/understanding-permissions-when-migrating

upvoted 2 times

...

PDR

3 years, 6 months ago

I think these doc pages are key to reference for the answer for this: https://docs.microsoft.com/en-us/sharepointmigration/understanding-permissions-when-migrating https://docs.microsoft.com/en-us/sharepoint/understanding-permission-levels Problem here is that whilst it states that Full Control permissions will get mapped it doesnt state that user with full control will be migrated and given OWNER .... but the owner role is the only one that has Full Control permissions when using the Permissions settings in a Sharepoint site, so logically you would assume that a user given Full Control must be an OWNER. Need to test to be sure though as something being logical and it actually being the case isnt a given!

upvoted 1 times

PDR

3 years, 6 months ago

tested this with a migration: User1 with Full Control on file1 is given OWNER permission on the file when migrated to Sharepoint Online site User2 with modify on file1 is given 'Can Edit' permission on the file when migrated to Sharepoint Online site but not Owner. Whilst not relevant to the question it is worth noting that the migrated users do not get any Sharepoint Site level permissions so dont actually have permission to access the document library and would have to access using a direct link.

upvoted 1 times

...

TimurKazan

3 years, 8 months ago

YNY just read the links and articles if you are not familiar with SPMT

upvoted 3 times

...

melatocaroca

4 years ago

S-1-5-21-4534338-1127018997-2609994386-1304, [email protected], FALSE S-1-5-21-4534338-1127018997-2609994386-1228, [email protected], FALSE S-1-5-21-4534338-1127018997-2609994386-1106, GroupA, TRUE So, user 1 and 2 FALSE, will not be migrated, trick in group name also, Group1 in mapping csv field typo error GroupA so Will not match, group1 will not have any permission

upvoted 7 times

melatocaroca

4 years ago

Also csv does not contain all the required fields CSV file format for migration needs six columns. o The first three are source values that detail where your data is currently located. o The remaining three columns indicate o the site, o document library, o optional subfolder o where you're migrating your data to. All six columns must be accounted for in the file, even if you don't need a value for a given field. https://docs.microsoft.com/en-us/sharepointmigration/mm-user-mapping-file

upvoted 2 times

...

jinxie

3 years, 7 months ago

The TRUE FALSE flag here is to indicate if the entity is an AD group or not. it has nothing to do with the migration. as per MS article on https://docs.microsoft.com/en-us/sharepointmigration/mm-user-mapping-file The following example uses Excel to create the CSV file. Start Excel. Enter the values for your user-mapping. Column A: From the source location, enter the log in name of the user. Required. Column B: On the destination site, enter the principal username. Required. Column C: If the principal username on the destination site is an Active Directory (AD) group, enter TRUE. If it's not an AD group, enter FALSE. Required. Close and save as a comma-delimited (*.csv) file.

upvoted 3 times

...