2024 Dumpleader CompTIA DS0-001 Dumps and Exam Test Engine [Q10-Q26]

NEW QUESTION 10
Following a security breach, a database administrator needs to ensure users cannot change data unless a request is approved by the management team. Which of the following principles addresses this issue?

Open access

Least resistance

Elevated privilege

Least privilege

NEW QUESTION 11
Which of the following describes the purpose of a snapshot?

To create a dynamic data replication

To create a synonym

To create a

To create an image of a database

NEW QUESTION 12
Which of the following database instances are created by default when SQL Server is installed? (Choose two.)

Root

Master

Log

Model

View

Index

NEW QUESTION 13
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?

The SQL Server codes are performing badly.

The SQL Server has not been tested properly.

The SQL Server ports to the main machine are closed.

The SQL Server has many concurrent users.

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

Biometric access systems

Database control systems

Fire suppression systems

Camera systems

Key card systems

Cooling systems

NEW QUESTION 15
Which of the following is an attack in which an attacker hopes to profit from locking the database software?

Spear phishing

Ransomware

SQL injection

On-path

NEW QUESTION 16
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?

Text editor

UML editor

Word processor

SQL query

NEW QUESTION 17
Which of the following is used to write SQL queries in various programming languages?

Indexing

Object-relational mapping

Excel

Normalization

NEW QUESTION 18
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?

Audit access to tables with sensitive data.

Remove sensitive data from tables

Mask the sensitive data.

Encrypt connections to the development environment.

NEW QUESTION 19
Which of the following NoSQL database types best categorizes MongoDB?

Document

Column-oriented

Graph

Key-value stores

NEW QUESTION 20
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?

INSERT USER

ALLOW USER

CREATE USER

ALTER USER

NEW QUESTION 21
Which of the following describes a scenario in which a database administrator would use a relational database rather than a non-relational database?

An organization wants to maintain consistency among the data in the database.

An organization requires data encryption.

An organization wants to process complex data sets.

An organization wants to store a large number of videos, photos, and documents.

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

DoS

Brute-force

SQL injection

Phishing

NEW QUESTION 23
Which of the following is the deployment phase in which a DBA ensures the most recent patches are applied to the new database?

Importing

Upgrading

Provisioning

Modifying

NEW QUESTION 24
Which of the following is a result of an on-path attack on a system?

A Wi-Fi network that redirects to clones of legitimate websites

A website that has crashed and is no longer accessible

An email from an unknown source requesting bank account details

A web application that returns the addresses of its customers

NEW QUESTION 25
Which of the following is a typical instruction that is found on a Linux command-line script and represents a system shell?

/bin/bash

#/bin/shell

>/bin/sh

#!/bin/bash

NEW QUESTION 26
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?

Move all the backup files to external disks.

Delete all the backup files containing data that is rated as classified.

Delete all the backup files that are not required by the backup retention policy.

Delete all the backup files except for the most recent one.

Leave a Reply Cancel reply