ITF+ Study Quiz 3

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

• UPDATE

• ALTER

• CREATE

• REPORT

Answer explanation

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

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

• Primary keys

• Schemas

• Keys/values

• Tables

Answer explanation

NoSQL databases use 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?

• File backup

• Data restoration

• Fault tolerance

• Restoring access

Answer explanation

The concept of fault tolerance is demonstrated by RAID technology, where data is stored redundantly across multiple drives to prevent data loss if one drive fails.

A user needs to enter text and numbers to produce charts that demonstrate sales figures. Which of the following types of software would BEST complete this task?

• Text editing software

• Visual diagramming software

• Spreadsheet software

• Web browsing software

Answer explanation

Spreadsheet software is the best choice as it allows users to input text and numbers to create charts, making it ideal for demonstrating sales figures.

Which of the following BEST describes the physical location of the data in the database?

• Table

• Column

• RAM

• HDD

Answer explanation

The physical location of the data in the database is best described by a 'Table', as data is organized and stored in tables within a database.

A user logs into a laptop using a username and complex password. This is an example of:

• biometrics

• multifactor authentication

• least privilege

• single-factor authentication

Answer explanation

Logging in with a username and password is an example of single-factor authentication, as it only requires one form of verification.

To establish a theory of probable cause, one technician investigates network issues in the server room while another technician troubleshoots the user's workstation. Which of the following troubleshooting methodologies is being performed?

• Question the obvious

• Divide and conquer

• Duplicate the problem

• Research the knowledge base

Answer explanation

Divide and conquer methodology is being performed as the technicians are splitting the troubleshooting tasks to identify the root cause more efficiently.

A remote user, who is working from home, requires significant bandwidth to connect to the corporate systems. Which of the following types of Internet service connections would BEST meet the user's needs?

• T1 line

• Satellite

• Fiber optic

• DSL

Answer explanation

Fiber optic connection would best meet the user's needs as it provides high bandwidth, making it suitable for remote work accessing corporate systems.

Which of the following types of encryption would BEST protect a laptop computer in the event of theft?

• Disk

• Email

• VPN

• HTTPS

Answer explanation

Disk encryption would BEST protect a laptop computer in the event of theft by securing the data on the disk, making it inaccessible without the encryption key.

Which of the following tasks is typically performed during the identification phase of the troubleshooting methodology?

• Question users.

• Verify functionality.

• Divide and conquer.

• Implement the solution.

Answer explanation

Questioning users is typically performed during the identification phase of the troubleshooting methodology to gather information about the issue.