Question 1
When comparing Business Central online and on-premises deployments, which of the following capabilities is exclusively available to an on-premises deployment?
graph TD
subgraph BusinessCentral["Business Central Deployment"]
Online[Online / SaaS]
OnPremises[On-Premises]
end
subgraph Features
A[Automatic Updates by Microsoft]
B[Direct SQL Database Access]
C[AppSource Extensions]
D[Read Scale-Out]
end
Online --> A
Online --> C
Online --> D
OnPremises --> C
OnPremises --> B
OnPremises --> D
Answer and explanation
Correct answer: B
Only an on-premises deployment gives the customer direct read/write access to the Business Central SQL Server database. In Business Central online the database is managed by Microsoft and isn't directly accessible. Microsoft-managed updates are an online capability, AppSource apps aren't on-premises-only, and Read Scale-Out isn't exclusive to on-premises either (it's available online and on-premises with SQL Server high-availability replicas).
