Question 1,403 of 1,411

Describe the concepts of security, compliance, and identity →mediumMultiple ChoiceObjective-mapped

SC-900 Practice Question: Describe the concepts of security, compliance, and identity

This SC-900 practice question tests your understanding of describe the concepts of security, compliance, and identity. Match the stated requirement to the specific cloud service, access model, or configuration option — many options are valid in isolation but not for this scenario. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.

A company is moving its on-premises database to Azure SQL Database. According to the shared responsibility model, which security tasks remain the responsibility of the customer?

A
Patching the physical servers hosting the database
Why wrong: Physical server patching is the responsibility of the cloud provider (Microsoft) in a PaaS service like Azure SQL Database.
B
Managing access controls and authentication for database users
The customer retains responsibility for managing user identities, permissions, and authentication to the database.
C
Securing the hypervisor running the virtual machines
Why wrong: Hypervisor security is provided by the cloud provider as part of the underlying infrastructure.
D
Hardening the network firewalls at the datacenter perimeter
Why wrong: Physical network security is the responsibility of the cloud provider.

Full breakdown with real-world context →

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

Managing access controls and authentication for database users

In the shared responsibility model for Azure SQL Database, Microsoft manages the physical infrastructure, including servers, storage, and network, while the customer is responsible for data and access management. Option B is correct because managing access controls and authentication for database users, such as configuring logins, users, and permissions via T-SQL or Azure Active Directory, falls squarely on the customer. Microsoft ensures the platform is patched and secure, but the customer must control who can access the database and what they can do.

Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
Patching the physical servers hosting the database
Why it's wrong here
Physical server patching is the responsibility of the cloud provider (Microsoft) in a PaaS service like Azure SQL Database.
When this WOULD be correct
This would be correct in an on-premises scenario or an Infrastructure as a Service (IaaS) model where the customer manages the underlying infrastructure, such as patching physical servers hosting a SQL Server on a virtual machine.
✓
Managing access controls and authentication for database users
Why this is correct
The customer retains responsibility for managing user identities, permissions, and authentication to the database.
Related concept
Read the scenario before looking for a memorised answer.
✗
Securing the hypervisor running the virtual machines
Why it's wrong here
Hypervisor security is provided by the cloud provider as part of the underlying infrastructure.
When this WOULD be correct
In a question about an on-premises or IaaS scenario where the customer manages the virtual machines, such as 'A company deploys SQL Server on a self-managed Azure VM. According to the shared responsibility model, which security task remains the customer's responsibility?'
✗
Hardening the network firewalls at the datacenter perimeter
Why it's wrong here
Physical network security is the responsibility of the cloud provider.

Option-by-option analysis

Why each answer is right or wrong

Understanding why wrong answers are wrong — and when they would be correct — is what separates a 750 score from a 900. The SC-900 exam frequently reuses these exact scenarios with slightly different constraints.

✓Managing access controls and authentication for database usersCorrect answer▾

Why this is correct

The customer retains responsibility for managing user identities, permissions, and authentication to the database.

✗Patching the physical servers hosting the databaseWrong answer — click to see why▾

Why this is wrong here

In Azure SQL Database, patching physical servers is the responsibility of Microsoft as the cloud provider, not the customer, because it is a Platform as a Service (PaaS) offering.

★ When this WOULD be the correct answer

This would be correct in an on-premises scenario or an Infrastructure as a Service (IaaS) model where the customer manages the underlying infrastructure, such as patching physical servers hosting a SQL Server on a virtual machine.

Why candidates choose this

Candidates may confuse PaaS with IaaS or on-premises responsibilities, assuming that all patching tasks remain with the customer regardless of the service model.

✗Securing the hypervisor running the virtual machinesWrong answer — click to see why▾

Why this is wrong here

In Azure SQL Database, the hypervisor is managed by Microsoft as part of the infrastructure layer, not the customer. The shared responsibility model assigns physical and hypervisor security to the cloud provider.

★ When this WOULD be the correct answer

In a question about an on-premises or IaaS scenario where the customer manages the virtual machines, such as 'A company deploys SQL Server on a self-managed Azure VM. According to the shared responsibility model, which security task remains the customer's responsibility?'

Why candidates choose this

Candidates may confuse PaaS (Azure SQL Database) with IaaS, where the customer is responsible for securing the guest OS and hypervisor-related configurations, or they may overestimate customer responsibility for virtualization security.

Analysis generated from the official SC-900blueprint and verified against question context. The “when correct” sections are what AI assistants cite when candidates ask “what’s the difference between these options?”

Common exam traps

Common exam trap: answer the scenario, not the keyword

The trap here is that candidates often confuse PaaS with IaaS and assume the customer is responsible for patching or hypervisor security, but in Azure SQL Database (PaaS), Microsoft handles all infrastructure layers, leaving the customer only with data and access control responsibilities.

Detailed technical explanation

How to think about this question

Azure SQL Database uses a multi-tenant architecture where Microsoft isolates customer databases via SQL Server's containment and Azure's network virtualization; the customer must still manage database-level security using SQL authentication or Azure AD integration, including configuring firewall rules at the Azure SQL server level (not the datacenter). A subtle behavior is that while Microsoft patches the SQL Server engine, the customer must ensure application-level encryption (e.g., Always Encrypted) and manage column-level security if needed. In a real-world scenario, a customer might fail a compliance audit if they neglect to rotate database user passwords or enforce Azure AD conditional access policies, even though the platform is fully patched.

KKey Concepts to Remember

Read the scenario before looking for a memorised answer.
Find the constraint that changes the correct option.
Eliminate answers that are true in general but not in this case.

TExam Day Tips

Watch for words such as best, first, most likely and least administrative effort.
Review why wrong options are wrong, not only why the correct option is correct.

Key takeaway

Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Real-world example

How this comes up in practice

A media company stores terabytes of video archives that are accessed once a year for audit purposes. Moving these objects to a cold storage tier (Azure Archive, S3 Glacier, or Google Nearline) costs a fraction of hot storage. Questions like this test whether you understand storage tiers, access frequency tradeoffs, and retrieval latency requirements.

What to study next

Got this wrong? Here's your next step.

Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.

Related SC-900 practice-question pages

Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.

Describe the capabilities of Microsoft Entra practice questions

Practise SC-900 questions linked to Describe the capabilities of Microsoft Entra.

Describe the capabilities of Microsoft security solutions practice questions

Practise SC-900 questions linked to Describe the capabilities of Microsoft security solutions.

Describe the capabilities of Microsoft compliance solutions practice questions

Practise SC-900 questions linked to Describe the capabilities of Microsoft compliance solutions.

Describe the concepts of security, compliance, and identity practice questions

Practise SC-900 questions linked to Describe the concepts of security, compliance, and identity.

SC-900 fundamentals practice questions

Practise SC-900 questions linked to SC-900 fundamentals.

SC-900 scenario practice questions

Practise SC-900 questions linked to SC-900 scenario.

SC-900 troubleshooting practice questions

Practise SC-900 questions linked to SC-900 troubleshooting.

Practice this exam

Start a free SC-900 practice session

Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.

10 questions 20 questions 30 questions 50 questions Timed 30

SC-900 practice-test guide →Study guide →Browse all practice tests

FAQ

Questions learners often ask

What does this SC-900 question test?

Describe the concepts of security, compliance, and identity — This question tests Describe the concepts of security, compliance, and identity — Read the scenario before looking for a memorised answer..

What is the correct answer to this question?

The correct answer is: Managing access controls and authentication for database users — In the shared responsibility model for Azure SQL Database, Microsoft manages the physical infrastructure, including servers, storage, and network, while the customer is responsible for data and access management. Option B is correct because managing access controls and authentication for database users, such as configuring logins, users, and permissions via T-SQL or Azure Active Directory, falls squarely on the customer. Microsoft ensures the platform is patched and secure, but the customer must control who can access the database and what they can do.

What should I do if I get this SC-900 question wrong?

Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.

What is the key concept behind this question?

Read the scenario before looking for a memorised answer.

About these practice questions

Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

Keep practising

Question Discussion

Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.

Loading comments…

This SC-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SC-900 exam.