Latest [Jul 01, 2024] CompTIA DS0-001 Exam Practice Test To Gain Brilliante Result [Q13-Q33]

5/5 - (3 votes)

Latest [Jul 01, 2024] CompTIA DS0-001 Exam Practice Test To Gain Brilliante Result

Take a Leap Forward in Your Career by Earning CompTIA DS0-001

NEW QUESTION 13
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 14
Which of the following best describes the category of SQL commands required to revoke access to database objects?

DCL

IDDL

IDML

TCL

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

NEW QUESTION 16
Which of the following scripts would set the database recovery model for sys.database?

NEW QUESTION 17
A database administrator needs to ensure that a newly installed corporate business intelligence application can access the company’s transactional dat a. Which of the following tasks should the administrator perform first?

Create a new service account exclusively for the business intelligence application.

Build a separate data warehouse customized to the business intelligence application’s specifications.

Set up a nightly FTP data transfer from the database server to the business intelligence application server.

Send the business intelligence administrator the approved TNS names file to configure the data mapping.

Open a new port on the database server exclusively for the business intelligence application.

NEW QUESTION 18
A database administrator is concerned about transactions in case the system fails. Which of the following properties addresses this concern?

Durability

Isolation

Atomicity

Consistency

NEW QUESTION 19
A database administrator is conducting a stress test and providing feedback to a team that is developing an application that uses the Entity Framework. Which of the following explains the approach the administrator should use when conducting the stress test?

Capture business logic, check the performance of codes, and report findings.

Check the clustered and non-clustered indexes, and report findings.

Review application tables and columns, and report findings.

Write queries directly into the database and report findings.

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

NEW QUESTION 21
Which of the following is most likely to prevent tampering with server hardware that houses data?

Biometric locks

Strong password policy

Network firewall

Surveillance cameras

NEW QUESTION 22
Over the weekend, a company’s transaction database was moved to an upgraded server. All validations performed after the migration indicated that the database was functioning as expected. However, on Monday morning, multiple users reported that the corporate reporting application was not working.
Which of the following are the most likely causes? (Choose two.)

The access permissions for the service account used by the reporting application were not changed.

The new database server has its own reporting system, so the old one is not needed.

The reporting jobs that could not process during the database migration have locked the application.

The reporting application’s mapping to the database location was not updated.

The database server is not permitted to fulfill requests from a reporting application.

The reporting application cannot keep up with the new, faster response from the database.

NEW QUESTION 23
An on-premises application server connects to a database in the cloud. Which of the following must be considered to ensure data integrity during transmission?

Bandwidth

Encryption

Redundancy

Masking

NEW QUESTION 24
A database administrator needs to ensure database backups are occurring on a daily basis and at scheduled times. Which of the following actions should the administrator take?

Query the database to observe entries.

Check the database schema.

Review the backup media.

Review the server logs for entries.

NEW QUESTION 25
Which of the following have data manipulation and procedural scripting power? (Choose two.)

PQL

PL/SQL

Advanced

SQL

T-SQL

NEW QUESTION 26
Which of the following are the best resources for monitoring potential server issues? (Choose two.)

User connections

Firewall usage

Index usage

CPU usage

Query execution

Memory usage

NEW QUESTION 27
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 dat a. Which of the following would be best suited for this task?

MonogoDB

MS SQL

Oracle

Graph database

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

Circuit-level

Stateful

Proxy

Packet

NEW QUESTION 29
Which of the following constraints is used to enforce referential integrity?

Surrogate key

Foreign key

Unique key

Primary key

NEW QUESTION 30
Which of the following computer services associates IP network addresses with text-based names in order to facilitate identification and connectivity?

LDAP

NTP

DHCP

IDNS

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

Data loss prevention

Data retention policies

Data classification

Global regulations

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

Troubleshooting guide

Entity relationship diagram

Data dictionary

Database reference manual

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

Data security

Data masking

Data protection

Data encryption