NYC CERTIFIED IT ADMINISTRATOR
(DATABASE) EXAM COMPLETE
QUESTIONS AND DETAILED SOLUTIONS
LATEST UPDATE THIS YEAR-JUST
RELEASED
The NYC Certified IT Administrator (Database)
examination is a civil service examination administered by
the New York City Department of Citywide
Administrative Services for candidates seeking database
administration positions within New York City agencies.
The examination evaluates advanced knowledge of
database administration, database design, installation,
configuration, troubleshooting, security, performance
optimization, disaster recovery, data modeling, auditing,
and database support functions. Current examination
notices indicate responsibilities involving complex
enterprise database systems, security management,
technical support, and supervisory functions.
Exam Coverage
Database architecture and administration
, SQL development and optimization
Relational database design
Data modeling techniques
Database security management
Backup and recovery planning
High availability and disaster recovery
Performance tuning and monitoring
Database installation and configuration
Cloud database administration
Database migration projects
Data governance principles
Replication technologies
Database troubleshooting
Transaction management
Concurrency control
Capacity planning
Indexing strategies
Storage management
ETL concepts
Data warehousing fundamentals
, Auditing and compliance
Access control management
Database networking
Change management
Incident response procedures
Monitoring and alerting systems
Automation and scripting
Business continuity planning
Technical documentation
1.
A city agency database experiences severe locking conflicts
during payroll processing, causing multiple critical
transactions to fail unexpectedly. Which administrative
action most effectively reduces transaction contention
while preserving data integrity?
A. Disable transaction logging permanently
B. Implement appropriate isolation levels and optimize
transaction duration
C. Remove primary keys from affected tables
D. Disable user authentication
Answer: B
, Rationale: Proper isolation configuration and shorter
transactions reduce blocking while maintaining
consistency.
2.
A database administrator notices increasing query
response times despite sufficient CPU availability. Which
investigation should be prioritized first?
A. Network cable replacement
B. Index fragmentation and execution plans analysis
C. Printer driver updates
D. User password resets
Answer: B
Rationale: Query performance problems commonly
originate from indexing and execution plan inefficiencies.
3.
During a disaster recovery exercise, the primary database
server becomes unavailable unexpectedly. What should be
the administrator’s immediate objective?
A. Delete backup files
B. Restore service using documented recovery procedures
(DATABASE) EXAM COMPLETE
QUESTIONS AND DETAILED SOLUTIONS
LATEST UPDATE THIS YEAR-JUST
RELEASED
The NYC Certified IT Administrator (Database)
examination is a civil service examination administered by
the New York City Department of Citywide
Administrative Services for candidates seeking database
administration positions within New York City agencies.
The examination evaluates advanced knowledge of
database administration, database design, installation,
configuration, troubleshooting, security, performance
optimization, disaster recovery, data modeling, auditing,
and database support functions. Current examination
notices indicate responsibilities involving complex
enterprise database systems, security management,
technical support, and supervisory functions.
Exam Coverage
Database architecture and administration
, SQL development and optimization
Relational database design
Data modeling techniques
Database security management
Backup and recovery planning
High availability and disaster recovery
Performance tuning and monitoring
Database installation and configuration
Cloud database administration
Database migration projects
Data governance principles
Replication technologies
Database troubleshooting
Transaction management
Concurrency control
Capacity planning
Indexing strategies
Storage management
ETL concepts
Data warehousing fundamentals
, Auditing and compliance
Access control management
Database networking
Change management
Incident response procedures
Monitoring and alerting systems
Automation and scripting
Business continuity planning
Technical documentation
1.
A city agency database experiences severe locking conflicts
during payroll processing, causing multiple critical
transactions to fail unexpectedly. Which administrative
action most effectively reduces transaction contention
while preserving data integrity?
A. Disable transaction logging permanently
B. Implement appropriate isolation levels and optimize
transaction duration
C. Remove primary keys from affected tables
D. Disable user authentication
Answer: B
, Rationale: Proper isolation configuration and shorter
transactions reduce blocking while maintaining
consistency.
2.
A database administrator notices increasing query
response times despite sufficient CPU availability. Which
investigation should be prioritized first?
A. Network cable replacement
B. Index fragmentation and execution plans analysis
C. Printer driver updates
D. User password resets
Answer: B
Rationale: Query performance problems commonly
originate from indexing and execution plan inefficiencies.
3.
During a disaster recovery exercise, the primary database
server becomes unavailable unexpectedly. What should be
the administrator’s immediate objective?
A. Delete backup files
B. Restore service using documented recovery procedures
