A database administrator is new to a company and wants to create a document that illustrates the interaction between tables. Which of the following should the administrator create?
Answer : B
Which of the following can be used to protect physical database appliances from damage in a server room? (Choose two.)
Answer : CF
A database administrator needs to ensure continuous availability of a database in case the server fails. Which of the following should the administrator implement to ensure high availability of the database?
Answer : B
A database's daily backup failed. Previous backups were completed successfully. Which of the following should the database administrator examine first to troubleshoot the issue?
Answer : C
A database administrator is updating an organization's ERD. Which of the following is the best option for the database administrator to use?
Answer : C
A database administrator needs a tool to document and explain the relationships between data in an organization's database. Which of the following is the best tool to accomplish this task?
Answer : B
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?
Answer : A
Which of the following firewall types allows an administrator to control traffic and make decisions based on factors such as connection information and data flow communications?
Answer : B
A new retail store employee needs to be able to authenticate to a database. Which of the following commands should a database administrator use for this task?
Answer : C
A developer is designing a table that does not have repeated values. Which of the following indexes should the developer use to prevent duplicate values from being inserted?
Answer : A
Which of the following would a database administrator monitor to gauge server health? (Choose two.)
Answer : AB
A database administrator is concerned about transactions in case the system fails. Which of the following properties addresses this concern?
Answer : A
Which of the following is a reason to create a stored procedure?
Answer : B
An on-premises application server connects to a database in the cloud. Which of the following must be considered to ensure data integrity during transmission?
Answer : B
Which of the following statements contains an error?
Answer : B
Have any questions or issues ? Please dont hesitate to contact us