Which of the followingbestdescribes a collection of data that shares the same properties or attributes?
A. Relation set
B. ER model
C. Entity set
D. Tuples
Which of the following describes the purpose of a snapshot?
A. To create a dynamic data replication
B. To create a synonym
C. To create a
D. To create an image of a database
Which of the following should a company develop to ensure preparedness for a fire in a data center?
A. Deployment plan
B. Backup plan
C. Data retention policy
D. Disaster recovery plan
Which of the following have data manipulation and procedural scripting power? (Choose two.)
A. PQL
B. PL/SQL
C. Advanced
D. SQL
E. SQL
F. T-SQL
Which of the following can be used to protect physical database appliances from damage in a server room? (Choose two.)
A. Biometric access systems
B. Database control systems
C. Fire suppression systems
D. Camera systems
E. Key card systems
F. Cooling systems
Which of the following NoSQL database typesbestcategorizes MongoDB?
A. Document
B. Column-oriented
C. Graph
D. Key-value stores
A database administrator has been asked to assign a user the ability to view a data set. Which of the following practices best describes this request?
A. Access control
B. Security audit
C. Database audit
D. Password policy implementation
Which of the following ismostlikely to prevent tampering with server hardware that houses data?
A. Biometric locks
B. Strong password policy
C. Network firewall
D. Surveillance cameras
A database administrator is updating an organization's ERD. Which of the following is thebestoption for the database administrator to use?
A. Word processor
B. Spreadsheet
C. UML tool
D. HTML editor
A company is launching a proof-of-concept, cloud-based application. One of the requirements is to select a database engine that will allow administrators to perform quick and simple queries on unstructured data.Which of the following would bebestsuited for this task?
A. MonogoDB
B. MS SQL
C. Oracle
D. Graph database