241. What is database infrastructure as code (IaC)?
- a) Managing database configurations through version-controlled definition files
- b) Writing stored procedures in general-purpose languages
- c) Automatically generating database code
- d) A type of NoSQL database
Answer: A - IaC tools like Terraform or Pulumi provision and configure databases declaratively.
242. What is a synthetic backup?
- a) A backup created from existing backups and transaction logs
- b) A fake backup for testing purposes
- c) A compressed backup format
- d) A backup of only schema definitions
Answer: A - Synthetic full backups combine previous full backups with incremental logs to reduce backup windows.
243. What is the purpose of a data catalog?
- a) To provide metadata management and data discovery
- b) To list all database tables
- c) To categorize backup files
- d) To organize database documentation
Answer: A - Data catalogs (e.g., Alation, Collibra) track lineage, definitions, and usage metrics across systems.
244. What is GDPR compliance in database systems?
- a) Adhering to EU data protection regulations for personal data
- b) A type of database encryption
- c) A backup retention policy
- d) A database performance standard
Answer: A - GDPR requires features like right-to-erasure, data minimization, and breach notification.
245. What is a multi-model database?
- a) A database supporting multiple data models (documents, graphs, etc.) in one engine
- b) A database with multiple schema versions
- c) A federated database system
- d) A database with replicas in different formats
Answer: A - Multi-model databases like ArangoDB or CosmosDB unify different paradigms under one query interface.
246. What is the purpose of the SQL AUTOMATION_JOB feature?
- a) To schedule and manage recurring database maintenance tasks
- b) To automate query optimization
- c) To generate automatic backups
- d) To implement self-healing databases
Answer: A - Automation jobs handle index rebuilds, statistics updates, and other routine operations.
247. What is point-in-time recovery (PITR)?
- a) Restoring a database to a specific moment using backups and logs
- b) Recovering only recent transactions
- c) A high-speed recovery method
- d) A type of incremental backup
Answer: A - PITR applies transaction logs to a backup to reach any precise recovery point.
248. What is the purpose of the SQL METADATA_COLUMN data type?
- a) To store schema information about other columns
- b) To hide sensitive metadata
- c) To compress metadata storage
- d) To version table definitions
Answer: A - Metadata columns enable dynamic schema patterns by storing attribute definitions as data.
249. What is database configuration drift?
- a) Uncontrolled changes to database settings outside of management processes
- b) Slow performance degradation
- c) A type of data corruption
- d) Schema evolution over time
Answer: A - Drift occurs when ad-hoc changes bypass version control, risking inconsistencies.
250. What is the purpose of the SQL BACKUP ENCRYPTION feature?
- a) To protect backup files from unauthorized access
- b) To compress encrypted databases
- c) To encrypt data in transit
- d) To implement blockchain backups
Answer: A - Backup encryption (e.g., using AES-256) safeguards data if backup media is compromised.
251. What is a database compliance framework?
- a) Policies and controls to meet regulatory requirements
- b) A database performance benchmark
- c) A type of database schema
- d) A backup validation system
Answer: A - Frameworks like SOC 2 or HIPAA define security, audit, and data handling standards.
252. What is the purpose of the SQL MULTI_MODEL_QUERY feature?
- a) To query across different data models (e.g., JSON and graph) in a single statement
- b) To optimize queries for multiple database versions
- c) To compare query models
- d) To federate queries across databases
Answer: A - Multi-model queries unify access like joining document collections with graph edges.
253. What is immutable backup storage?
- a) Write-once-read-many (WORM) storage that prevents tampering
- b) A backup that cannot be moved
- c) A read-only database replica
- d) A type of compression
Answer: A - Immutable backups protect against ransomware or malicious deletion by preventing changes.
254. What is the purpose of the SQL METADATA_GRAPH view?
- a) To visualize relationships between database objects
- b) To store graph database metadata
- c) To model schema evolution
- d) To track query performance
Answer: A - Metadata graphs show how tables, views, and procedures interconnect across the database.
255. What is database configuration management?
- a) Systematically tracking and applying database settings
- b) Managing database sizes
- c) A type of capacity planning
- d) Organizing connection pools
Answer: A - Tools like Ansible or Chef enforce consistent configurations across environments.
256. What is the purpose of the SQL BACKUP VALIDATION command?
- a) To verify backup integrity without full restoration
- b) To check backup permissions
- c) To validate backup schedules
- d) To test restore performance
Answer: A - Backup validation checks for corruption by reading backup files' internal structures.
257. What is a data dictionary?
- a) A centralized repository of database metadata and business definitions
- b) A list of database values
- c) A type of compression dictionary
- d) A backup catalog
Answer: A - Data dictionaries document tables, columns, relationships, and business context.
258. What is the purpose of the SQL AUTOMATIC_TUNING feature?
- a) To continuously optimize database performance without manual intervention
- b) To tune SQL queries automatically
- c) To adjust hardware settings
- d) To learn user query patterns
Answer: A - Automatic tuning (e.g., in Azure SQL) adjusts indexes, statistics, and plans based on workload.
259. What is air-gapped backup storage?
- a) Physically isolated backups with no network connectivity
- b) Compressed backup storage
- c) Cloud backup replication
- d) A type of incremental backup
Answer: A - Air-gapping protects against network-based attacks by storing backups offline.
260. What is the purpose of the SQL COMPLIANCE_AUDIT function?
- a) To generate reports for regulatory requirements
- b) To audit database performance
- c) To validate SQL standards compliance
- d) To check license compliance
Answer: A - Compliance audits document who accessed what data when, with what changes.