HOTSPOT
Your organization sells products online. You store all product information in a secure Microsoft SQL Server database. Members of the online marketing team only access the database by using an online website administration application. The organization’s sales and product development teams do not have direct access to database. Single sign-on is enabled in the environment.
You identify the following requirements for the sales and product development teams:
You must not grant teams access to the online website administration application.
The teams must be able to access product information for reporting and customer service purposes.
The teams must be able to create reports that include product information directly from theirSharePoint
Server 2016 site.
The teams must be able to export data to Microsoft Excel.
You need to provide access to the product database while leveraging out-of-the box SharePoint functionality.
Which actions should you perform in sequence? To answer, select the appropriate options in the answer area.
Hot Area:
Which actions should you perform in sequence?
HOTSPOT
Your organization sells products online. You store all product information in a secure Microsoft SQL Server database. Members of the online marketing team only access the database by using an online website administration application. The organization’s sales and product development teams do not have direct access to database. Single sign-on is enabled in the environment.
You identify the following requirements for the sales and product development teams:
You must not grant teams access to the online website administration application.
The teams must be able to access product information for reporting and customer service purposes.
The teams must be able to create reports that include product information directly from theirSharePoint
Server 2016 site.
The teams must be able to export data to Microsoft Excel.
You need to provide access to the product database while leveraging out-of-the box SharePoint functionality.
Which actions should you perform in sequence? To answer, select the appropriate options in the answer area.
Hot Area:
Step 2 = create an external content type
https://docs.microsoft.com/en-us/sharepoint/dev/general-development/external-content-types-in-sharepoint