DS0-001 Self-Study Guide for Becoming an CompTIA DataSys+ Certification Exam Expert [Q44-Q68]

NO.44 A database administrator is creating a table, which will contain customer data, for an online business. Which of the following SQL syntaxes should the administrator use to create an object?

NO.45 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?

NO.46 Which of the following indexes stores records in a tabular format?

NO.47 Which of the following is a potential issue raised by enterprise database users?

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

NO.49 Which of the following services is responsible for assigning, managing, and reclaiming IP addresses on a TCP/IP-based network?

NO.50 A DBA left the company, and the DBA’s account was removed from the system. Soon after, scheduled jobs began failing.
Which of the following would have most likely prevented this issue?

NO.51 Which of the following is part of logical database infrastructure security?

NO.52 Which of the following constraints is used to enforce referential integrity?

NO.53 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?

NO.54 Which of the following is most likely to prevent tampering with server hardware that houses data?

NO.55 A company needs information about the performance of users in the sales department. Which of the following commands should a database administrator use for this task?

NO.56 A database administrator wants to remove inactive customers from a database. Which of the following statements should the administrator use?

NO.57 An automated script is using common passwords to gain access to a remote system. Which of the following attacks is being performed?

NO.58 A database administrator manages a database server that is running low on disk space. A lot of backup files are stored on the server’s disks.
Which of the following is the best action for the administrator to take?

NO.59 Which of the following is used to hide data in a database so the data can only be read by a user who has a key?

NO.60 Which of the following concepts applies to situations that require court files to be scanned for permanent reference and original documents be stored for ten years before they can be discarded?

NO.61 Which of the following cloud storage options provides users with endpoints to retrieve data via REST API?

NO.62 A programmer wants to configure a database to only allow read or write access when requests are coming from specific IP addresses. Which of the following can be used to configure IP addresses to allow access to the database?

NO.63 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?

NO.64 A group of developers needs access to a database in a development environment, but the database contains sensitive dat a. Which of the following should the database administrator do before giving the developers access to the environment?

NO.65 Which of the following best describes the category of SQL commands required to revoke access to database objects?

NO.66 Which of the following NoSQL database types best categorizes MongoDB?

NO.67 Which of the following is a characteristic of all non-relational databases?

NO.68 Which of the following is a typical instruction that is found on a Linux command-line script and represents a system shell?