DS0-001

DS0-001 practice questions, page 4 of 6, with answer review and explanations.

Question 16

A database administrator set up a connection for a SQL Server instance for a new user, but the administrator is unable to connect using the user's workstation. Which of the following is the most likely cause of the issue?

  1. The SQL Server codes are performing badly.
  2. The SQL Server has not been tested properly.
  3. The SQL Server ports to the main machine are closed.
  4. The SQL Server has many concurrent users.

Question 17

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

  1. Audit access to tables with sensitive data.
  2. Remove sensitive data from tables.
  3. Mask the sensitive data.
  4. Encrypt connections to the development environment.

Question 18

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?

  1. Create a materialized view.
  2. Create indexes on those tables.
  3. Create a new database.
  4. Create a function.

Question 19

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?

  1. UNION
  2. JOIN
  3. INTERSECT
  4. CROSS JOIN

Question 20

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 be best suited for this task?

  1. MongoDB
  2. MS SQL
  3. Oracle
  4. Graph database