Special Offer - Enroll Now and Get 2 Course at ₹25000/- Only Explore Now!

All Courses
Sharepoint Interview Questions and Answers

Sharepoint Interview Questions and Answers

November 24th, 2018

In case you’re searching for Sharepoint  Interview Questions and answers for Experienced or Freshers, you are at the correct place. There is parcel of chances from many presumed organizations on the planet. The Sharepoint  advertise is relied upon to develop to more than $5 billion by 2021, from just $180 million, as per Sharepoint  industry gauges. In this way, despite everything you have the chance to push forward in your vocation in Sharepoint  Development. Gangboard offers Advanced Sharepoint  Interview Questions and answers that assist you in splitting your Sharepoint  interview and procure dream vocation as Sharepoint  Developer.

Best Sharepoint  Interview Questions and Answers

Do you believe that you have the right stuff to be a section in the advancement of future Sharepoint , the GangBoard is here to control you to sustain your vocation. Various fortune 1000 organizations around the world are utilizing the innovation of Sharepoint  to meet the necessities of their customers. Sharepoint  is being utilized as a part of numerous businesses. To have a great development in Sharepoint  work, our page furnishes you with nitty-gritty data as Sharepoint  prospective employee meeting questions and answers. Sharepoint  Interview Questions and answers are prepared by 10+ years experienced industry experts. Sharepoint  Interview Questions and answers are very useful to the Fresher or Experienced person who is looking for the new challenging job from the reputed company. Our Sharepoint  Questions and answers are very simple and have more examples for your better understanding.

By this Sharepoint  Interview Questions and answers, many students are got placed in many reputed companies with high package salary. So utilize our Sharepoint  Interview Questions and answers to grow in your career.
In case you are searching for Sharepoint Interview Questions and answers, then you are at the correct place. Our Sharepoint Interview Questions and answers are prepared by 10+ years exp professionals.

Q1) How to fetch ULS logs for Correlation ID in SharePoint online?

Use Get-SPOTenantLogEntry SharePoint online command

Q2) How to fetch ULS logs for Correlation ID in SharePoint on-premise?

Use Merge-SPLogfile SharePoint command
You can get logs per hourly basis, per user and also Area related logs like Search, SharePoint Foundation.

Q3) What is ULS viewer?

A windows application for viewing SharePoint ULS log files more easily. Supports filtering and easy viewing of data

Q4) How many SharePoint is old and list the versions of SharePoint?

17 Years old, Versions: SharePoint 2001, SharePoint server portal 2003, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016,sharepoint 2019 and SharePoint online

Q5) What are the notable changes in SharePoint 2016 and SharePoint 2019 from previous versions?

2016- Fast site collection creation, Main role, Hybrid search, Durable, Shortcut keys for Document library functions links; 2019- Modern view for pages, list, library, like SharePoint online has been introduced, New home page where you have the ability to create sites from the different web application

Q6) What are deprecated features in SharePoint 2016 and SharePoint 2019?

2016-SharePoint Foundation, Excel Services, Forefront Identity Management Service, stsadm.exe;2019-Infopath, Sharepoint Designer, Site Mailbox, Site Manager

Q7) What are teams?

Teams is part of office 365 which comprises skype, Sharepoint, Onenote, Conversations and SharePoint mail box. Client software is available for teams.

Q8) What is Power apps?

Power apps is an alternative to InfoPath which is used to customize SharePoint list forms.

Q9) What is Flow?

Flow is an alternative to SharePoint Designer workflow which is used to enable workflow for list items based on the available flow templates

Q10) What is Office 365 groups?

Office 365 groups are part of Office 365 which comprises conversations, SharePoint site, and Shared mailbox

Q11) What is a difference between IIS logs and ULS logs?

IIS logs have details about HTTP request made by a user. It will have user IP, computer name.
ULS logs will have details after the user is authenticated by IIS. It will have all SharePoint services, service application, what is happening inside SharePoint logs.

Q12) What is a difference between a team site and communication site?

Team site is for internal team collaboration. It is a private site for storing your project documents, working on documents as a team. Communication site is targeted on customer or the whole company, It has details about a new product, new services offered by your company or to publish some news to your organization. Teams sites can be connected to Office 365 group and Teams whereas office 365 groups can’t be connected

Q13) Difference between services in Services in farm and Services in-service.msc?

Services are logical entities installed to the farm, while service instances are server-specific aspects of the service deployed to individual servers

Q14) What happens if SharePoint Timer Service is stopped?

If it stops, all services and timer jobs controlled by the SharePoint timer service will be stopped,

Q15) What is distributed cache service?

The Distributed Cache service provides in-memory caching services to several features in SharePoint Server 2016 IT Preview.
The features  use Distributed Cache service include:

  • Newsfeeds
  • OneNote client access
  • Authentication
  • Security Trimming
  • Page load performance

Q16) What happens if the distributed cache is stopped?

If the cache Cluster is down then you will see Runtime error, unexpected error, access denied, no newsfeed, page loading slowly and so on.

Q17) How much memory is taken by Distributed cache?

When SharePoint Server is installed, it assigns the Distributed Cache service 10 percent of the total physical memory on the server

Q18) What is the main role in SharePoint 2016?

A new farm topology based on MinRole a set of predefined server roles introduced in SharePoint Server2016. SharePoint Server 2016 and 2019 has been optimized for the MinRole farm topology SharePoint will automatically configure the services on each server based on the server’s role.

Q19) What are the types of Man role?

Ans: Front-end, Application, Search, Distributed Cache, Custom

Q20) What is a zone?

SharePoint “Zones” are ways for you to create new entrances for people access your content.  They are not like additional web applications or site collections that create new locations for content.  But rather – think of your content like a house and the default zone is the front door into the house.  Adding an additional zone gives you additional “doors” into your content.
With that new door can be a new address like a new or different URL from the front door – or maybe just a new protocol which to access the date (http or https).
These zones enable you to create what are called “Alternate Access Mappings”.

Q21) What are the types of a zone?

Zones are of Five types:

  • Internet
  • Intranet
  • Extranet
  • Custom
  • Default

Q22) 1000 users, plan SharePoint deployment?

Small farm, 1WFE, 1APP,2 SQL servers clustered and Always-On

Q23) What is web jobs in Azure?

To run some script in a server, you can create web jobs from an Azure portal. It avoids the need for logging the server to perform the activity

Q24) Explain Search Architecture 2013?

You have to explain all the components

Q25) How to troubleshoot Solution Deployment issues?

First, check if a solution has properly installed and working in Dev and UAT environment. Then check if the solution is not getting deployed in any particular server. All servers should be UP and running. Check if the timer service is running in all servers. Check if any custom Timer job is stopped. Make sure you are not deploying solutions from a shared path. Try using stsadm commands if SharePoint commands are not helping.

Q26) How you will configure Software Load balancer in SharePoint?

Load balance can be 2 types. Software load balancer and Hardware load balancer.
Software load balancer- You can use windows load balancer feature to configure/ Software load Balancer SLB)

Q27) How you will configure Hardware Load balancer in SharePoint?

Hard load balancer- F5 load balancer

Q28) What is Oauth?

Oauth is open source authentication. Allow users to access third party apps in Sharepoint site.
SharePoint provides access tokens to Third party apps. Third party apps use the tokens to retrieve data from the SharePoint server for that user.
A flow of Oauth:

  • User authenticated sharepoint using claim
  • sharepoint request client context from ACS
  • ACS provide client context to sharepoint
  • Sharepoint passes client context to User
  • User posts to app passing client context
  • Client app is able to pull  refresh token out of client content and request outh from ACS
  • ACS returns oauth token to a client app
  • client app makes cson/rest api calls to sharepoint site passing oauth token
  • sharepoint returns site content to the app
  • client app returns html code to a user device

ACS- Azure access control service.

Q29) What are the types of authentication?

Classic- Windows, NTLM, Kerberos
Claims- ADFS, Form based authentication

Q30) What is ADFS authentication?

ADFS provides single sign-on and access to an external resource

Q31) What is lookup columns in SharePoint?

To use a column values in another list within site or subsite we use lookup columns

Q32) OneDrive sync issues?

OneDrive sync issues main causes
1)Space issue in local machine
2)File length issue
3) Special characters

Q33) How you will restore deleted users OneDrive?

Use Restore-Spodeletedsite command

Q34) Difference between backup/restore vs import/export?

Backup/restore is for site level whereas import/export is for a list and item level

Q35) How you will provide access to Gmail account to your SharePoint online site?

Make sure external sharing is enabled in the site. Once it is enabled add the user in the site. User will receive the invitation in his Gmail. He should accept the invitation to login the site.

Q36) access install account have on SQL?

security admin and db creator

Q37) What is a farm account?

Account which is running SharePoint timer service is farm account

Q38) What is a standalone installation?

Installing SharePoint and SQL in the same server

Q39) Difference between contribute Vs Edit and Read Vs Edit?

Contribute- Add/edit/delete list items
Edit-Contribute+ Manage Lists ie able to add new list/library and manage
Read- Able to view and download documents
View-Able to view documents
Design-Edit+ Approve list items, Customize pages

List Permission Contribute Edit
Manage Lists  NO YES
Override List Behaviours  NO  NO
Add Items  YES  YES
Edit Items  YES YES
Delete Items YES YES
View Items YES YES
Approve Items NO  NO
Open Items YES YES
View Versions YES YES
Delete Versions YES YES
Create Alerts YES YES
View Application Pages YES YES

Q40) Command to mount Content Database?

Mount-SPContentDatabase –Name (Name of Content DB) –Databaseserver (DB server name) –WebApplication (web app url)

Q41) How to add a new search server?

Before you add search components to the server, first start search server instance. It will start both search windows service
$<host n > = Get-SPEnterpriseSearchServiceInstance -Identity “<Server name>”
Start-SPEnterpriseSearchServiceInstance -Identity $<host n >
Run Get-SPEnterpriseSearchServiceInstance to check both the service is running.
Get Active Search topology and clone it then add the component
$ssa = Get-SPEnterpriseSearchServiceApplication
$active = Get-SPEnterpriseSearchTopology -SearchApplication $ssa -Active
Get-SPEnterpriseSearchComponent -SearchTopology $active
$ssa = Get-SPEnterpriseSearchServiceApplication
$active = Get-SPEnterpriseSearchTopology -SearchApplication $ssa -Active
$clone = New-SPEnterpriseSearchTopology -SearchApplication $ssa -Clone -SearchTopology $active

  • New-SPEnterpriseSearchAdminComponent
  • New-SPEnterpriseSearchAnalyticsProcessingComponent
  • New-SPEnterpriseSearchContentProcessingComponent
  • New-SPEnterpriseSearchCrawlComponent
  • New-SPEnterpriseSearchQueryProcessingComponent

Q42) Request Management service?

Request Management feature in SharePoint 2013 manages incoming requests by evaluating logic rules against the user requests in order to determine what/which action to take, and which machine or machines in the farm should handle the requests

Q43) How many days SharePoint online sites are backed up?

14 days

Q44) What does remove-spouser do?

It removes use completely from the site

Q45) List the Migration Tools?

Sharegate
Avepoint
Metalogic

Q46) What is GAC?

Global Assembly Cache (or just, GAC) is an extraordinary organizer in Windows intended for putting away .NET global DLLs. At the point when SharePoint cultivate arrangements are sent the DLL’s are spared in GAC organizer.

Q47) What is the minimum hardware requirement for SharePoint 2013?

For Single server with a built-in database it is recommended to use
RAM : 8 GB
Processor : 64-bit, 4 cores
Hard disk: 80 GB for system drive
For Web server or application server in a three-tier farm, it is recommended to use
RAM : 12 GB
Processor : 64-bit, 4 cores
Hard disk : 80 GB for system drive

Q48) What is the Power shell command to install farm solution package?

Install-SPsolution -literalpath “sharepointfarmsolution.wsp”  -GACD eployment

Q49) What is SharePoint?

SharePoint is a web-based business collaborative platform integrated with Microsoft office. Its primarily used  as a secure place to store, organize, share, and access information.

  •  Provides business services
  •  Supports Extensibility
  •  Enables integration with external sites/services

 Q50) Name some of the additional features in Sharepoint:

  •  SharePoint Apps
  •  BCS
  •  SharePoint 2013 Work
  •  Managed Metadata
  •  Enterprise Search

Q51) What is the max number of  web applications created in a farm?

It is recommended to create only 20 web applications per farm.

Q52) What is a web application?

A web application is he highest level component in the logical architecture of SharePoint. It  is composed of an Internet Information Services (IIS) web site that acts as a logical unit for the site collections.Web applications have their own “application pools”.

Q53) What is Secure Store service?

The Secure Store Service is an authorization service which provides a database that is used to store credentials. They usually consist of a user identity and password, but can also contain other fields.

Q54) What are the advantages of application pool?

Application pool separates sets of IIS worker processes that share the same configuration and application boundaries Provides better security, reliability, availability and performance Each can run without impacting one another Web applications can share application pools.

Q55) What is the maximum number of content database per farm?

A farm can have a maximum of 500 content databases.

Q56) Explain the types of Managed Path

A wildcard inclusion allows us to append multiple site collections to the path that we specify. An explicit inclusion allows us to create a single site collection with the specified address.

Q57) Is it recommended to disable loop back check in production environment?

No, Its not recommended to disable loop back check in production environment. The recommended way is to add the host name or the host names for the sites in Back Connection Host Names registry key

Q58) What is Incremental Crawl and Continuous Crawl?

Steady Crawls are look crawlers that accumulate the progressions made since the last creep. Gradual Crawls and Full Crawls can’t be kept running in parallel. They assume responsibility and hoard the entire crawler asset. This likewise makes it conceivable to have extremely obsolete indexed lists. A steady slither may not get changes that occur while the gradual creep is running. Constant Crawl settles this issue. It might produce a few sessions in 15 minute interims, that will get the progressions and additionally the progressions made amid the Continuous Crawl. It will amplify the freshness of your pursuit content.

Q59) What is Full crawl?

All the content specified by the content source is crawled even if the content already exists in the search index.

Q60) What is the threshold limit for sharepoint online list view and how it can be handled?

5000 is the threshold for list view and it can be handled by creating folders and moving the items or by filtering to display the latest items.

Q61) What is the difference between SharePoint 2013 and 2016?

In 2016, O365 applications are fully integrated and hybrid search is wizard-driven instead of powershell scripts as in 2013

Q62) What is a timer job?

A Timer Job is an occasionally executed assignment inside SharePoint Server. It can do different errands inside the SharePoint condition on a planned time occasion premise.

Q63) Role of content source in sharepoint.

At the point when a Search benefit application is made, a substance source named “Neighborhood SharePoint destinations” is naturally made and designed for slithering all SharePoint Server destinations in the nearby server cultivate. We can make extra substance sources to determine other substance to creep and how the framework should slither that content.

Q64) What are sandbox and farm solutions?

Farm solutions run on W3WP.exe and farm solutions run on SPUC Worker Process.exe.Application pool is recycled while deploying farm solutions.

Q65) What is the role of Managed Metadata Service?

Managed metadata is a hierarchical collection of centrally managed terms that we can define and then use as attributes for items in sharepoint server 2013.

Q66) What are the ways of backing up and restoring site collection?

Using power shell commands or in the central administration.

Q67) What is Managed account and where it is used?

Managed accounts are service accounts managed by sharepoint.They are used for creation of service applications and web applications.

Q68) What is the powershell command to move site collection between content database?

Get-SPSite -ContentDatabase <SourceContentDb> | Move-SPSite -DestinationDatabase <DestinationContentDb>

Q69) How to make a sharepoint site public?

It can be made public by enabling “Anonymous access” in web app settings.

Q70) What are most commonly used applications by SharePoint Administrator?

  •  Sharepoint Designer
  •  Infopath Designer
  •  ULS viewer
  •  Powershell

Q71) What is a site column?

A site column is a reusable column definition, or template, that one can assign to multiple lists across multiple SharePoint sites. Site columns are useful if an organization wants to establish some consistent settings across lists and libraries.

Q72) What is a content type?

A substance type is a reusable gathering of metadata (segments), work process, conduct, and different settings for a classification of things or archives in a SharePoint Server rundown or report library. Content sorts empower you to deal with the settings for a classification of data in a concentrated, reusable manner .

Q73) How auditing is done in Sharepoint?

Under site settings audit logs will be available from there it can be generated and analysed for organisation use.

Q74) What is the difference between sharepoint online and sharepoint 2013?

Sharepoint online is hosted in cloud and 2013 is hosted in onprem environment.Sharepoint admins have full control over the farm where as in sharepoint online its limited.

Q75) Can multiple SharePoint installs point to the same DB?

Multiple SharePoint introduces can utilize a similar database server. Not actually a similar database on that server. That server should be SQL Server 2000 / SQL Server 2005. It can’t be Oracle or another merchant.

Q76) What are different permission types in Sharepoint?

Limited access,View Only,Read,Contribute,Edit,Design,Full control.

Q77) What is the difference between edit and cotribute permissions?

Contribute- Add/edit/delete list items
Edit-Contribute and Manage Lists i.e able to add new list or library and manage

Q78) What is the powershell command to return sitecollection along with all the subsites?

Get-SP Web Application http://site | Get-SPSite -Limit All | Get-SPWeb -Limit All | Select Title, URL

Q79) What are alternate access mapping?

Alternate access mappings guide clients to the right URLs amid their cooperation with SharePoint Server 2013 (while perusing to the landing page of a SharePoint Server 2013 site, for instance). Alternate access mappings empower SharePoint Server to delineate solicitations to the right web applications and locales, and they empower SharePoint Server to serve the right substance back to the client.

Q80) What are the types of authentication?

Classic- Windows, NTLM, Kerberos
Claims- ADFS, Form based authentication

Q81)What is the difference between backup/restore and export/import commands?

Backup/restore will restore items with new GUID.Backup/restore will restore workflows and customs solutions but in export/import they can be restored.

Q82) What are differences Between auto Hosted, Provider Hosted and SharePoint Hosted?

  • Autohosted apps for SharePoint are cloud-hosted apps.
  • Provide hosted apps include components that are deployed and hosted outside the SharePoint farm.
  • SharePoint hosted apps are hosted either on an on-premises or Office 365 SharePoint farm.

Q83)What are differences between Application Pages and Site Pages?

Application These are the typical pages conveyed in SharePoint ,the greater part of them are found under _Layouts organizer which can be sent at ranch level or application level. Site pages will be pages that are made, altered, and tweaked by end clients. They are essentially utilized for the substance in a site. Website pages come in two kinds—a standard page and a Web Parts page.

Q84) How many days the deleted content will be available in Recycle Bin?

The erased article will remain in the Recycle Bin for 30 days as a matter of course.

Q85) What is master page and use of it?

Master page gives designs to set of pages. Ace Pages are a layout that different pages can acquire from to keep steady usefulness. The pages that acquire from Master Pages are alluded to as substance pages.

Q86) What is Page Layout?

Page design manages the general look and feel of a site page. A page design depends on a substance type to decide the sort of substance that can be put away on pages. Page design contains field controls and web part.

Q87) What is a SharePoint Feature? What files are used to define a feature?

SharePoint Feature is a practical segment that can be initiated and deactivate at different extensions all through a SharePoint occurrences, extent of which are characterized as

  • Farm
  • Web Application
  • Site
  • Web

Q88)What is Authentication and Authorization?

A verification framework is the manner by which you recognize yourself to the PC. The objective behind a validation framework is to check that the client is really who they state they are.When the framework knows who the client is through validation, approval is the means by which the framework chooses what the client can do.

Q89) Explain how channels in Teams is related to SharePoint?

Whenever we are creating channel in Teams, folders will be created in Sharepoint Document Library. Each folders stores respective channel files.

Q90) How to delete Sharepoint site linked to Teams?

You can use Remove-SPOsite command or you can use new admin center to delete Office 365 group site.

Q91) How to delete Teams completely?

You can delete in Teams by clicking on your Team->Delete or you can use Remove-Team –Group ID
https://docs.microsoft.com/en-us/powershell/module/teams/remove-team?view=teams-ps
You should have Teams module installed in powershell.

Q92) How to install teams module in powershell?

Install-Module MicrosoftTeams. Use Connect-MicrosoftTeams to connect/login to the Teams.

Q93) List some of the commands in Teams module?

  • New-Team,
  • New-Teamchannel
  • Set-Team
  • Set-Teamchannel
  • Disconnect-MicrosoftTeams

Q94) List some of the commands in Powerapps module?

  • Get-PowerAppEnvironment
  • Get-Flowenvironment
  • Get-Flow
  • Enable-Flow
  • Disable-Flow

https://powerapps.microsoft.com/en-us/blog/gdpr-admin-powershell-cmdlets/

Q95) How to use Flow commands in PowerShell?

Use same commands which is used to connect Powerapps. You will get flow commands.

Q96) Explain about Sharepoint Migration tool?

It is open source tool by Microsoft. You can migrate document library in on premise and online using the tool. It doesn’t have much functionality like Avepoint, Sharegate.

Q97) How to import Sharepoint Migration Module in PowerShell?

Import-Module Microsoft.SharePoint.MigrationTool.PowerShell.

Q98) What is the file size boundary limit in Sharepoint online?

15GB. This is same for SharePoint 2019 as well.

Q99) What is the maximum size of content database in Sharepoint 2016 and 2019?

It is recommended to keep site collection maximum size of 100GB. If content DB is more than 100GB, it is recommended to move the sites it to different content database.

Q100) How to move sites to different content database?

We have to use PowerShell command-move-spite.

Q101)  How to increase SharePoint site quota?

We have 2 options, Option 1 is using SharePoint admin center
Option 2 is to PowerShell command- Set-sposite –identity “url” –quota “In MB”

Q102) How to increase size for OneDrive personal site of user?

Use PowerShell command Set-sposite

Q103) OneDrive sync supported number of documents in document library?

300000

Q104) How to renew ADFS certificate in Sharepoint On-premise environment?

First the certificate should be updated in ADFS, then AD team should provide the certificate to SharePoint team. Once you have received the certificate, please run the below command.
$cert= New-Object System.Security.Cryptography.X509Certificates.X509Certificate2(“C:\Host\ADFS Signing v1.cer“)
$sts = Get-SPTrustedIdentityTokenIssuer
$sts | Set-SPTrustedIdentityTokenIssuer -ImportTrustCertificate $cert

Q105) List some of the activity which can be tracked in Audit logs for SharePoint in Security and compliance center?

Accessed File
Modified file
Renamed file
Deleted site
Downloaded site
Access request expired

Q106) How to connect to SharePoint site using CSOM PowerShell

$weburl= ‘https://tenant.sharepoint.com/sites/team’
$ctx = New-Object Microsoft.SharePoint.Client.ClientContext ($webUrl)
$username= “Provide username”
$password=”Provide password”
$ctx.credentials=New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials ($admin, $password)

Q107) How to connect to Sharepoint site using CSOM C#?

ClientContext context = new ClientContext(“http://SiteUrl”);

Q108) How to add and remove site admin using PowerShell in SharePoint online?

Adding site admin- Set-spouser –site “Site url” –loginname “User name” –issitecollectionadmin $true
Remove site admin- Set-spouser –site “Site url” –loginname “User name” –issitecollectionadmin $false

Q109) Is it is possible to connect single SharePoint site using SPO commands?

No, it is not possible, You can use CSOM or PNP

Q110) How to connect SharePoint site using pnp powershell?

You have to use connect-pnponline command, Make sure pnp sharepoint module is installed

Q111) List some of the sharepoint online powershell commands?

  • get-sposite
  • Set-sposite
  • Get-spouser
  • Set-spouser
  • Remove-spouser

Q112) Explain one of major issue you have fixed?

  • Site down due to server
  • Site down due to patching issue
  • Site down due to deployment issue
  • Office web app issue
  • Certificate issue

You should clearly explain one of the issue

Q113) Office 365 is IAAS or SAAS or PAAS

SAAS

Q114) Explain one of the major PowerShell script which you have written?

You should be able to explain one of the script clearly
Example: Server monitoring, Sharepoint site monitoring, Fetching site owners, Fetching all users from sharepoint site, Fetching all sites in a sharepoint tenant with quota

Q115) Name few sharepoint site monitoring tools?

  •  Appdynamics
  •  Application Insights
  •  SCOM
  •  OfficeMon

 Q116) How custom timer jobs can be run in sharepoint online site?

You can use Azure web jobs or Azure functions to accomplish it

Q117) Fetch Sharepoint Admin details of all sites in Sharepoint online tenant and keep it in sharepoint list?

You can use Microsoft Flow with Azure function. You should keep the GetSPOAdministrator.ps1 script in Azure function

Fetch Shareponit Admin

Q118) List some of the Microsoft Flow template related to sharepoint?

  •  Start Approval when New item is added
  •  Send a customized email when a new sharepoint list item is added
  •  Record Form responses in Sharepoint
  •  Send customized email when new file is added in sharepoint document library
  •  Request manager approval for selected item

Q119) How to fetch usage report for a sharepoint site?

you can use popularity trends to fetch the report.

Q120) How to enable audit log settings for SharePoint online site?

Go to Site->Site settings->Audit log settings->Select the box which is required.

Q121) How to remove external user completely in SharePoint tenant?

Remove it from SharePoint site using command or manually. Then remove it in Office 365 ->Active Users.

Q122) Explain Hybrid Search?

Hydrid search allows you to search on-prem and online site

Q123) What are the ways to export the list to excel?

You can use export to excel in ribbon or you can use PowerShell/pnp script

Q124) What are the ways to copy/move the SharePoint documents from one document library to another?

You can use copy or move option available in modern view.
You can download the file and upload it in destination library

Q125) Which version of Excel supports co-authoring?

Excel 2016

Q126) When user click on OneDrive, it goes to delve page? How you will troubleshoot?

OneDrive site has not been created for user, you have to check if SharePoint online license is assigned to user or not

Q127) How to enable MFA for user in Azure?

You have to go to Azure Active directory, click on the user and enable MFA

Q128) What is -no sitelock attribute during backup of the site?

If we don’t put no site lock site will go into read only mode during the backup process.

Q129) What is the permission required for User Profile Service application on active directory server ?

We need to provide “replicate directory Changes” permission to User profile service account
on the Active Directory server And if the permission is not granted it will not perform user profile synchronisation from AD to
Sharepoint means user attributes like Name, last name , email address etc will not get sync on SharePoint.

Q130)  Why we need a new domain for Apps in SharePoint 2013 ?

SharePoint apps work on Unique URL domain and that’s why we add CName record on the
domain like *.microsoft.com

Q131) Why the threshold limit for list or library is 5000 and what happens if we increase the limit.

And: Threshold limit for SharePoint list or library is 5000 it means at a time when we click/ open a
document library or list it will display 5000 items. If we increase the limit it will display more but it
will impact on the performance. List or library will take more time to display since it gets the data
from the SQL query from SQL Server.

Q132) What is content access account in Search Service application ?

when Crawler crawls SharePoint web application , site collection or sites it uses content access
account to crawl/read web application, site collection or sites. This account should have permission
on the web application , sites it site collection else crawler will not crawl.

Q133) SharePoint search is not working check why ?

First, go the Search Service application and check the page is loading fine or not. Pl
It will show all topology active.
Check Admin component is up and running.
Check URL is there in content source.
Check crawl status.

Q134) Why office web apps is required SharePoint 2013 ?

To open office documents in browser need to configure office web apps, need to follow steps
to configure office web apps. Install office web webs and Create New-offficeWebApps using
powershell commands.

Q135) What are authentication in SharePoint ?

Classic and claims based authentication in SharePoint 2010
Classic authentication is deprecated in SharePoint.
Claims based authentication use claims based token created by STS.
Claims means user attributes.

Q136) What is NTLM authentication ?

Network line manager authentication works as follow
Whenever user browse the site, SharePoint check which authentication and if it is NTLM windows
authentication then IIS authenticate using current Windows authentication with AD , once username and password matches with AD, SharePoint check permission on the site and display the
site.
Forms based authentication are two types
FBA SQL : In this a database is created default name aspnetdb and user credentials are stored in the
database. Membership roles and Member providers are configured and added on web config file on
Central Admin , STS and web application.
When a user browse FBA web application it shows, IIS check authentication and forn FBA render a
form for username and password. User enter username and password and IIS authenticate credentials with SQL database aspnetdb and then authenticate and render the site.

Q137) FBA authentication ?

Forms based authentication are two types
FBA SQL : In this a database is created default name aspnetdb and user credentials are stored in the
database. Membership roles and Member providers are configured and added on web config file on
Central Admin , STS and web application.
When a user browse FBA web application it shows, IIS check authentication and forn FBA render a
form for username and password. User enter username and password and IIS authenticate
credentials with SQL database aspnetdb and then authenticate and render the site.
Create a library and enable use of external content type.
Will gets column and data from external database on the site.

Q138) What is the threshold limit of subsites in site in SharePoint 2016 and 2019?

2000