For a disaster recovery exercise, a company wants to ensure customer data is recovered before operational data. This is an example of:

• prioritization

• redundancy

• replication

• fault tolerance.

Answer explanation

For a disaster recovery exercise, prioritizing customer data recovery before operational data ensures critical information is restored first, making it an example of prioritization.

When transferring a file across the network, which of the following would be the FASTEST transfer rate?

• 1.22Gbps

• 1001Kbps

• 110Mbps

• 123Mbps

Answer explanation

The FASTEST transfer rate would be 1.22Gbps, as it has the highest value among the given options.

A company requires several reports that analyze related information from sales, inventory, marketing, and compensation data. Which of the following is the BEST place to store this data?

• Database

• Flat file

• Word processor

• Network share

Answer explanation

A database is the best place to store related information from sales, inventory, marketing, and compensation data as it allows for structured storage, efficient querying, and data relationships.

Which of the following should have the HIGHEST expectation of privacy?

• A locally stored word processing document

• A picture posted to a social media website

• A presentation saved to a corporate file server

• A spreadsheet emailed to a business client

Answer explanation

A locally stored word processing document should have the HIGHEST expectation of privacy because it is not shared online or on a corporate server, reducing the risk of unauthorized access.

Which of the following authorization techniques is used to assign permissions and authorize a user based on job title or function?

• Role-based access control

• Rule-based access control

• Mandatory access control

• Discretionary access control

Answer explanation

Role-based access control is used to assign permissions and authorize a user based on job title or function.

A programmer uses DML to modify:

• Data

• Files

• Permissions

• Backups

Answer explanation

A programmer uses DML to modify data, not files, permissions, or backups. DML stands for Data Manipulation Language.

A technician is concerned that sensitive data transmitted over the Internet can be intercepted and viewed during a MITM attack. Which of the following should the technician enable to reduce the risk?

• TLS

• DLP

• ACL

• IPS

Answer explanation

To reduce the risk of sensitive data interception during a MITM attack, the technician should enable TLS to encrypt the transmitted data.

A developer needs to add a table to a database. Which of the following database activities should the user perform?

• CREATE

• UPDATE

• ALTER

• REPORT

Answer explanation

To add a table to a database, the user should perform the CREATE activity. This operation is used to create new tables in a database.

Which of the following does a NoSQL database use to organize data?

• Keys/values

• Primary keys

• Schemas

• Tables

Answer explanation

A NoSQL database uses keys/values to organize data, allowing for flexible and schema-less data structures.

A systems administrator is setting up a new server using RAID technology. If one hard drive in the array fails, the data is stored on another drive, preventing data loss. Which of the following business continuity concepts does this explain?

• Fault tolerance

• File backup

• Data restoration

• Restoring access

Answer explanation

RAID technology provides fault tolerance by storing data redundantly across multiple drives, ensuring data integrity in case of a drive failure.