NYC Certified IT Administrator (Database) Exam
Practice Questions And Correct Answers (Verified
Answers) Plus Rationales 2026 Q&A | Instant
Download Pdf
,NYC Certified IT Administrator (Database) Exam - Practice Test
This practice exam is designed to mirror the style and content of the NYC Certified
IT Administrator (Database) examination administered by the NYC Department of
Citywide Administrative Services (DCAS) . The test evaluates your proficiency in
enterprise database administration, including backup and recovery, security,
performance tuning, high availability, and troubleshooting.
Exam Number: 8283 (Reference)
Format: Multiple Choice / Scenario-Based
Total Questions: 100 (Sample includes 50 core questions)
Time Allocation: Approximately 2 hours and 45 minutes for full exam .
Core Competency Domains Covered:
• Relational Database Administration (SQL Server focus)
• Backup, Recovery, and Disaster Recovery Planning
• Database Security and Access Control
• Performance Monitoring and Optimization
• Replication, Clustering, and High Availability (HA)
• Cloud and Hybrid Infrastructure
• Data Integrity and Transaction Management
• Troubleshooting and Incident Response
Practice Examination Questions
Question 1: A municipal agency database administrator notices that a SQL Server
production database experiences severe blocking during payroll processing every
Friday afternoon. Investigation reveals long-running transactions holding shared
, locks on employee tables while reports are generated. Which administrative
solution would MOST effectively reduce blocking while preserving transactional
consistency?
A. Enable READ UNCOMMITTED isolation level globally
B. Implement snapshot isolation for reporting workloads
C. Disable transaction logging during payroll execution
D. Increase the database autogrowth size
Answer: B. Implement snapshot isolation for reporting workloads
Rationale: Snapshot isolation provides a versioned view of the data, allowing read
operations (reports) to proceed without acquiring shared locks, thereby bypassing
blocking caused by write operations, while still maintaining transactional
consistency for the reading session .
Question 2: The NYC Department of Environmental Protection requires that all
citizen PII (Personally Identifiable Information) stored in a SQL Server database be
encrypted at rest to comply with state data security laws. The application team
cannot modify the source code of legacy applications accessing the data. What
feature should the DBA implement?
A. Row-level security
B. Dynamic data masking
C. Transparent Data Encryption (TDE)
D. Always Encrypted
Answer: C. Transparent Data Encryption (TDE)
Rationale: Transparent Data Encryption (TDE) encrypts the database files (.mdf,
.ndf, .ldf) and backups at rest without requiring application changes. It is
transparent to client applications. Always Encrypted and Dynamic Masking are
client-side or presentation-layer features, while Row-level security controls access
to rows .
Question 3: A DBA wants to ensure that failed login attempts are centrally
monitored for possible cyberattacks. Which configuration is MOST appropriate?
Practice Questions And Correct Answers (Verified
Answers) Plus Rationales 2026 Q&A | Instant
Download Pdf
,NYC Certified IT Administrator (Database) Exam - Practice Test
This practice exam is designed to mirror the style and content of the NYC Certified
IT Administrator (Database) examination administered by the NYC Department of
Citywide Administrative Services (DCAS) . The test evaluates your proficiency in
enterprise database administration, including backup and recovery, security,
performance tuning, high availability, and troubleshooting.
Exam Number: 8283 (Reference)
Format: Multiple Choice / Scenario-Based
Total Questions: 100 (Sample includes 50 core questions)
Time Allocation: Approximately 2 hours and 45 minutes for full exam .
Core Competency Domains Covered:
• Relational Database Administration (SQL Server focus)
• Backup, Recovery, and Disaster Recovery Planning
• Database Security and Access Control
• Performance Monitoring and Optimization
• Replication, Clustering, and High Availability (HA)
• Cloud and Hybrid Infrastructure
• Data Integrity and Transaction Management
• Troubleshooting and Incident Response
Practice Examination Questions
Question 1: A municipal agency database administrator notices that a SQL Server
production database experiences severe blocking during payroll processing every
Friday afternoon. Investigation reveals long-running transactions holding shared
, locks on employee tables while reports are generated. Which administrative
solution would MOST effectively reduce blocking while preserving transactional
consistency?
A. Enable READ UNCOMMITTED isolation level globally
B. Implement snapshot isolation for reporting workloads
C. Disable transaction logging during payroll execution
D. Increase the database autogrowth size
Answer: B. Implement snapshot isolation for reporting workloads
Rationale: Snapshot isolation provides a versioned view of the data, allowing read
operations (reports) to proceed without acquiring shared locks, thereby bypassing
blocking caused by write operations, while still maintaining transactional
consistency for the reading session .
Question 2: The NYC Department of Environmental Protection requires that all
citizen PII (Personally Identifiable Information) stored in a SQL Server database be
encrypted at rest to comply with state data security laws. The application team
cannot modify the source code of legacy applications accessing the data. What
feature should the DBA implement?
A. Row-level security
B. Dynamic data masking
C. Transparent Data Encryption (TDE)
D. Always Encrypted
Answer: C. Transparent Data Encryption (TDE)
Rationale: Transparent Data Encryption (TDE) encrypts the database files (.mdf,
.ndf, .ldf) and backups at rest without requiring application changes. It is
transparent to client applications. Always Encrypted and Dynamic Masking are
client-side or presentation-layer features, while Row-level security controls access
to rows .
Question 3: A DBA wants to ensure that failed login attempts are centrally
monitored for possible cyberattacks. Which configuration is MOST appropriate?
