Microsoft 365 Teamwork Administrator Certification Transition - MS-302 Exam Practice Test
You need to meet the technical requirements for OneDrive mobile users.
Which settings should you configure from the OneDrive admin center?
Which settings should you configure from the OneDrive admin center?
Correct Answer: D
Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).
You have Microsoft 365 tenant.
You need to present data from a Microsoft Azure SQL database to a Microsoft SharePoint Online list.
Which four 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 you select.

You need to present data from a Microsoft Azure SQL database to a Microsoft SharePoint Online list.
Which four 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 you select.

Correct Answer:

Explanation

Step 1: Create a Business Connectivity
Create Back End Azure SQL DB For SharePoint Online Business Connectivity Services Step 2: Create a Secure Store Target Application Secure Store target Application- Secure store in SharePoint will hold the credentials which will be used by SharePoint to connect to Azure SQL DB.
Step 3: Create Azure SQL DB External Content Type
Step 4: Create External List
Create External List from SharePoint Online
We create an external list, which is based on the content type that connects to Azure SQL DB.
References:
https://social.technet.microsoft.com/wiki/contents/articles/39170.integrate-azure-sQl-db-with-sharepoint-online-a
You have a SharePoint Server farm and a Microsoft 365 subscription.
You plan to deploy the On-premises data gateway.
Which three cloud services can use the gateway to access SharePoint data? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
You plan to deploy the On-premises data gateway.
Which three cloud services can use the gateway to access SharePoint data? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Correct Answer: A,B,E
You have a SharePoint Server 2019 farm and a SharePoint Online subscription.
You configure hybrid Microsoft OneDrive.
You need to ensure that hybrid users can follow documents in the farm by using Microsoft Delve.
What should you implement?
You configure hybrid Microsoft OneDrive.
You need to ensure that hybrid users can follow documents in the farm by using Microsoft Delve.
What should you implement?
Correct Answer: C
You have a SharePoint Server farm.
You have the following three types of document libraries: expense reports, purchase orders, and invoices.
Each document in the libraries has an associated project code and cost center.
You need to ensure that when users check in expense reports, purchase orders, and invoices, the documents are associated to a project code and a cost center. The project code and cost center must be in a consistent format across all the document libraries. The solution must minimize administrative effort.
What should you include in the solution?
You have the following three types of document libraries: expense reports, purchase orders, and invoices.
Each document in the libraries has an associated project code and cost center.
You need to ensure that when users check in expense reports, purchase orders, and invoices, the documents are associated to a project code and a cost center. The project code and cost center must be in a consistent format across all the document libraries. The solution must minimize administrative effort.
What should you include in the solution?
Correct Answer: A
You have a Microsoft 365 subscription.
You need to prevent only users in the research department from deleting chat messages.
What should you do first from the Microsoft Teams & Skype for Business Admin Center?
You need to prevent only users in the research department from deleting chat messages.
What should you do first from the Microsoft Teams & Skype for Business Admin Center?
Correct Answer: C
Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).
You have a SharePoint server farm.
You have document libraries that contain multiple content types.
You need to replicate the content types to SharePoint Online.
Which PowerShell cmdlet should you run?
You have document libraries that contain multiple content types.
You need to replicate the content types to SharePoint Online.
Which PowerShell cmdlet should you run?
Correct Answer: B
Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).
You plan to deploy Microsoft SharePoint Online sites.
You need to recommend a solution that provides consistent global navigation across multiple site collections.
Which navigation approach should you include in the recommendation?
You need to recommend a solution that provides consistent global navigation across multiple site collections.
Which navigation approach should you include in the recommendation?
Correct Answer: C
Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).
Note: This Question is part of a series of Questions that present the same scenario. Each Question in the series contains a uniQue solution that might meet the stated goals. Some Question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a Question in this section, you will NOT be able to return to it. As a result, these Questions will not appear in the review screen.
Your company has a Microsoft SharePoint Online subscription.
The company purchases a new add-in for Microsoft Excel.
You need to deploy the add-in to all users.
Solution: From the App Catalog, you upload the add-in to the Microsoft Office Add-ins Does this meet this goal?
After you answer a Question in this section, you will NOT be able to return to it. As a result, these Questions will not appear in the review screen.
Your company has a Microsoft SharePoint Online subscription.
The company purchases a new add-in for Microsoft Excel.
You need to deploy the add-in to all users.
Solution: From the App Catalog, you upload the add-in to the Microsoft Office Add-ins Does this meet this goal?
Correct Answer: B
Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).