Managing Microsoft SharePoint Server 2016 — Question 1

During the upgrade from SharePoint 2013 to SharePoint 2016, you discover there is a missing feature. You review the logs and observe the following error message:
Message: Database [WSS_ Contoso_OR01] has reference(s) to a missing feature: Id = [4be9a980-965f-486f-9eda-074e284875d7].
Remedy: The feature with Id 4be9a980-965f-486f-9eda-074e284875d7 is referenced in the database [WSS_ Contoso_OR01], but is not installed on the current farm.
The missing feature may cause upgrade to fail. Please install any solution which contains the feature and restart upgrade if necessary.
You need to identify the page that is missing the feature.
Which of the following will identify the page?

Answer options

• A. On the SQL Server, run the following SQL syntax against WSS_Contoso_OR01: SELECT FeatureID, FullURL FROM WebsINNER JOIN FeaturesON Webs.Id = Features.WebIdWHERE FeatureID = 4be9a980-965f-486f-9eda-074e284875d7ORDER BY FeatureID
• B. On the SharePoint Server, review the Health Analyzer and find the missing dependencies.
• C. On the SharePoint Server, run the following Windows PowerShell command: Test-SPContentDatabase-Name $dbName ;-WebApplication $wa | Select Category, Message | Where {$_.Category –eq "MissingFeature"}
• D. On the SharePoint Server, run the following Windows PowerShell command: Test-SPContentDatabase-Name $dbName -WebApplication $wa | Select

Correct answer: D

Explanation

Option D is correct because it utilizes the Test-SPContentDatabase PowerShell command to identify missing features tied to content databases in SharePoint. Options A and C involve SQL queries or different PowerShell commands that do not directly provide the page information for the missing feature. Option B checks dependencies but does not specifically identify the page linked to the missing feature.