ExamGecko
Login
Home / CompTIA / DS0-001 / List of questions
Ask Question

CompTIA DS0-001 Practice Test - Questions Answers, Page 5

Add to Whishlist

List of questions

Question 41

Report Export Collapse

Which of the following can be used to protect physical database appliances from damage in a server room? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 42

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 43

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 44

Report Export Collapse

A database administrator is updating an organization's ERD. Which of the following is the best option for the database administrator to use?

Become a Premium Member for full access
  Unlock Premium Member

Question 45

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 46

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 47

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 48

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 49

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 50

Report Export Collapse

Which of the following would a database administrator monitor to gauge server health? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member
Total 80 questions
Go to page: of 8
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

Which of the following is the deployment phase in which a DBA ensures the most recent patches are applied to the new database?
A database administrator would like to create a table named XYZ. Which of the following queries should the database administrator use to create the table? A) B) C) D)
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?
Which of the following is a characteristic of all non-relational databases?
A database administrator needs to aggregate data from multiple tables in a way that does not impact the original tables, and then provide this information to a department. Which of the following is the best way for the administrator to accomplish this task?
A database administrator needs to provide access to data from two different tables to multiple group users in order to facilitate ongoing reporting. However, some columns in each table are restricted, and users should not be able to see the values in these columns. Which of the following is the best action for the administrator to take?
A database is configured to use undo management with temporary undo enabled. An UPDATE is run on the table. Which of the following describes where the undo is stored?
A DBA is reviewing the following logs to determine the current data backup plan for a primary data server: Which of the following best describes this backup plan?
Which of the following is most likely to prevent tampering with server hardware that houses data?
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?