CompTIA DataSys+ (DS0-001) (DS0-001) DS0-001 Questions 301–303 | Page 5/5

301

MCQhard

A production database server is running out of memory. Which setting in SQL Server limits the amount of memory the instance can consume from the OS?

A.max server memory

B.Query memory grant

C.Working set size

D.min server memory

AnswerA

max server memory caps the buffer pool and other instance allocations, preventing SQL Server from consuming all available OS memory. Setting it bounds instance consumption so the operating system retains memory for its own processes.

Why this answer

The 'max server memory' setting in SQL Server configures the upper limit of memory that the SQL Server instance can allocate from the operating system. Setting this value prevents SQL Server from consuming all available memory and starving the OS or other applications, which is critical on a production server.

Exam trap

DS0-001 often tests the confusion between 'max server memory' and 'min server memory', or between instance-level memory limits and per-query memory grants, so candidates must read carefully.

How to eliminate wrong answers

Option B is wrong because query memory grant is a per-query allocation for operations like sorts and hashes, not an instance-wide limit. Option C is wrong because working set size is the amount of physical memory currently used by the process, not a configurable limit. Option D is wrong because 'min server memory' sets the minimum memory that SQL Server will attempt to keep available, not the maximum.

Full explanation →

302

MCQmedium

To comply with CCPA, an organization must track the 'Right to Know' requests. Which component of a Data Governance Framework is most relevant?

A.Data Ingestion Pipeline

B.Data Cataloging

C.Load Balancing

D.Data Compression

AnswerB

Data cataloguing inventories data assets with metadata, lineage and classification, letting staff locate every record linked to an individual. That directly satisfies the stem's CCPA constraint: responding to Right to Know requests requires knowing which datasets hold personal data and where it flows.

Why this answer

Data Cataloging is the component of a Data Governance Framework that inventories data assets, records their location, lineage, and classification, and enables organizations to locate and track personal information subject to CCPA 'Right to Know' requests. Without a catalog, an organization cannot reliably determine what personal data it holds or where it resides.

Exam trap

DS0-001 often tests governance concepts by mixing in infrastructure components, so candidates who focus on data movement rather than data inventory incorrectly select the ingestion pipeline.

How to eliminate wrong answers

Option A is wrong because a Data Ingestion Pipeline moves and transforms data into storage; it does not provide the inventory or metadata needed to answer data-subject access requests. Option C is wrong because load balancing distributes network traffic and is unrelated to data governance or privacy compliance. Option D is wrong because data compression reduces storage size and has no bearing on tracking or locating personal data for CCPA requests.

Full explanation →

303

MCQmedium

An administrator needs to enforce password complexity on the database level. Where should this policy be configured?

A.Database Trigger

B.Backup Schedule

C.Database Authentication Policy/IAM

D.Stored Procedure

AnswerC

Configuring the database authentication policy within the IAM layer enforces complexity rules directly at the database engine, satisfying the requirement for database-level enforcement rather than relying on operating system or Microsoft Entra ID controls. This ensures every credential created or rotated inside the database must meet the defined complexity criteria before acceptance.

Why this answer

Password complexity requirements are authentication controls, so they belong in the database's authentication policy or identity and access management (IAM) layer. This is where the DBMS enforces rules such as minimum length, character classes, and expiration at login time. Configuring it there ensures the policy applies uniformly to all database users before any session is established.

Exam trap

DS0-001 often tests the misconception that triggers or stored procedures can enforce authentication policy, when password complexity must be configured at the authentication/IAM layer to apply at login.

How to eliminate wrong answers

Option A is wrong because a database trigger fires on DML events (INSERT/UPDATE/DELETE) after a session is already authenticated; it cannot enforce login-time password complexity and would be an inappropriate, fragile place to store credentials logic. Option B is wrong because a backup schedule governs data protection and recovery, not authentication policy; it has no mechanism to validate passwords. Option D is wrong because a stored procedure is application logic invoked explicitly; while it could theoretically hash or check a password, it is not the declarative authentication policy layer and would not automatically enforce complexity for all logins.

Full explanation →

CompTIA DataSys+ (DS0-001) (DS0-001) (DS0-001) — Questions 301–303