CompTIA CompTIA DataSys+ DS0-001 Questions & Answers

• Question 1:

  A database administrator would like for users to be able to access resources remotely from home. Which of the following best describes how the administrator can enable this access without compromising the security of the stored data?

  A. Implement a virtual private network.

  B. Implement strong passwords polices.

  C. Configure and deploy a firewall.

  D. Implement a parameter network for internet-facing database applications.

  Correct Answer: A

• Question 2:

  A database administrator wants to create a database that does not have a predefined schema. Which of the following tools should the administrator use to create this type of database? (Choose two.)

  A. PostgreSQL

  B. MariaDB

  C. MySQL

  D. SQL Server

  E. MongoDB

  F. Cosmos

  Correct Answer: EF

• Question 3:

  A. Table

  B. View

  C. Function

  D. Stored procedure

  Correct Answer: B

• Question 4:

  Which of the following is a tool for preventing data loss?

  A. Gateway

  B. IP configuration

  C. Encryption

  D. Scripts

  Correct Answer: C

• Question 5:

  Which of the following transactions is allowed in a shared lock?

  A. Read

  B. Update

  C. Delete

  D. Insert

  Correct Answer: A

• Question 6:

  A database administrator would like to extract a sales performance report from more than one database instance. Which of the following keywords should the database administrator use?

  A. UNION ON

  B. UNION AND

  C. JOIN ON

  D. WITH

  Correct Answer: C

• Question 7:

  Given the following value from a VARCHAR column that is used to store integer values:

  12A

  Which of the following is the best way for a DBA to increase the data quality for this column?

  A. Keep the value and change the column to integer.

  B. Correct the value and change it to integer.

  C. Add a check constraint to the column and change it to int.

  D. Keep the column as VARCHAR and correct the value.

  Correct Answer: C

• Question 8:

  A database administrator is migrating the information in a legacy table to a newer table. Both tables contain the same columns, and some of the data may overlap. Which of the following SQL commands should the administrator use to ensure that records from the two tables are not duplicated?

  A. UNION

  B. JOIN

  C. IINTERSECT

  D. CROSS JOIN

  Correct Answer: A

  The SQL command that the administrator should use to ensure that records from the two tables are not duplicated is option A. This command uses the UNION clause to combine the records from the legacy table and the newer table into a

  single result set. The UNION clause also eliminates any duplicate records that may exist in both tables, and sorts the result by default. The other options either do not produce the desired result or have syntax errors. For example, option B

  would join the records from the two tables based on a common column, but not remove any duplicates; option C would return only the records that are common to both tables, but not the ones that are unique to each table; option D would

  produce a Cartesian product of the records from the two tables, which would increase the number of duplicates. References: CompTIA DataSys+ Course Outline, Domain 1.0 Database Fundamentals, Objective 1.2 Given a scenario, execute

  database tasks using scripting and programming languages.

• Question 9:

  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. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: B

  The query that the administrator should use to create the table is option B. This query uses the CREATE TABLE statement to define a new table named XYZ with three columns: ID, Name, and Age. Each column has a data type and a constraint, such as NOT NULL, PRIMARY KEY, or CHECK. The other options either have syntax errors, use incorrect keywords, or do not specify the table name or columns correctly. References: CompTIA DataSys+ Course Outline, Domain

  1.0 Database Fundamentals, Objective 1.1 Given a scenario, identify and apply database structure types.

• Question 10:

  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?

  A. ETL

  B. Replication

  C. Database dumping

  D. Backup and restore

  Correct Answer: B

  The option that the administrator should implement to ensure high availability of the database is replication. Replication is a process that copies and synchronizes data from one database server (the primary or source) to one or more database servers (the secondary or target). Replication helps ensure high availability of the database by providing redundancy, fault tolerance, and load balancing. If the primary server fails, the secondary server can take over and continue to serve the data without interruption or data loss. The other options are either not related or not suitable for this purpose. For example, ETL is a process that extracts, transforms, and loads data from one source to another for analysis or reporting purposes; database dumping is a process that exports the entire content of a database to a file for backup or migration purposes; backup and restore is a process that copies and recovers data from a backup device or media in case of a disaster or corruption. References: CompTIA DataSys+ Course Outline, Domain 5.0 Business Continuity, Objective 5.3 Given a scenario, implement replication of database management systems.