Online Access Free MS-302 Practice Test

You have a SharePoint Server farm and a SharePoint Online subscription.
The farm contains the lists shown in the following table.

Which two lists can you migrate to SharePoint Online by using the SharePoint Migration Tool? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

• A.List3
• B.List1
• C.List5
• D.List4
• E.List2

Your company has a SharePoint Server farm.
Each department at the company has an associated Active Directory group.
You plan to deploy a Business Connectivity Services (BCS) solution for all the users in the human resources (HR) department. BCS will connect to a Microsoft SQL Server named SQL1. SQL1 uses SQL Server Authentication.
You need to ensure that BCS can access SQL1. Authentication credentials and connection information must be encrypted.
What should you do?

• A.Create a target application that uses a Target Application Type of Group Ticket.
  Add a new field named ConnectionString and set the field type to PIN.
  Set the credentials for the target application.
• B.Create a target application that uses a Target Application Type of Individual Ticket.
  Add a new field named ConnectionString and set the field type to
  Set the credentials for the target application.
• C.Create a target application that uses a Target Application Type of Individual.
  Add a new field named ConnectionString and set the field type to
  Set the credentials for the target application.
• D.Create a target application that uses a Target Application Type of Group.
  Add a new field named ConnectionString and set the field type to .
  Set the credentials for the target application.

You have a SharePoint Server farm and a SharePoint Online subscription.
You plan to implement hybrid search.
You need to ensure that a SharePoint administrator named Admin1 can create a Search Service Application.
The solution must use the principle of least privilege.
Which two Microsoft SQL Server roles should you assign to Admin1? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.processadmin
• B.dbcreator
• C.serveradmin
• D.setupadmin
• E.securityadmin

You have a Microsoft 365 subscription.
You use Microsoft Stream to upload internal videos.
You need to add the videos to a Microsoft Teams channel.
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: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

Correct Answer:

Explanation

Make it easy for your team to collaborate using video by adding a Microsoft Stream channel or video as a tab in Microsoft Teams.
1. In Stream, select the channel or video URL directly from the address bar or your browser on the channel or video page.Or, click the Share icon Share icon on the desired video, click Share, and copy the URL.
2. Open Microsoft Teams.
3. Select the plus icon on the tab bar of your Team channel.

4. Select the Microsoft Stream tab.

5. Paste the URL into the direct link section and then click Save.
References:
https://docs.microsoft.com/en-us/stream/embed-video-microsoft-teams

You have a SharePoint Server farm.
You configure the farm to support custom tiles, and you add an item to the custom files list.
You discover that the new item appears at the bottom of the list in the app launcher.
You need to ensure that the new item appears first on the list.
Solution: You run the Add-PnpNavigationNode cmdlet and specify the -first parameter.
Does this meet the goal?

• A.No
• B.Yes