CompTIA CompTIA IT Fundamentals+ FC0-U61 Questions & Answers

• Question 31:

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

  A. biometrics

  B. multifactor authentication

  C. least privilege

  D. single-factor authentication

  Correct Answer: D

• Question 32:

  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?

  A. Text editing software

  B. Visual diagramming software

  C. Spreadsheet software

  D. Web browsing software

  Correct Answer: C

• Question 33:

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

  A. Primary keys

  B. Schemas

  C. Keys/values

  D. Tables

  Correct Answer: C

• Question 34:

  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?

  A. File backup

  B. Data restoration

  C. Fault tolerance

  D. Restoring access

  Correct Answer: C

  RAID TYPES:

  RAID 0: FAST, NO FAULT TOLERANCE, REQUIRES 2 DRIVES, STRIPING RAID 1: SLOW, HAS FAULT TOLERANCE, REQUIRES 2 DRIVES, MIRRORING RAID 5: FAST, FAULT TOLERANT, REQUIRES 3 DRIVES, STRIPING/PARODY RAID 0+1: STRIPING/MIRRORING, REQUIRES 4 DRIVES RAID 1+0: MIRRORING/STRIPING, REQIORES 4 DRIVES

  (RAID 5 is best to choose)

• Question 35:

  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?

  A. DLP

  B. ACL

  C. TLS

  D. IPS

  Correct Answer: C

• Question 36:

  Given the following pseudocode:

  

  Which of the following is the output of the code?

  A. 1

  B. 9

  C. 10

  D. 11

  Correct Answer: C

  C. 10 for count =9: count < 10 count = 9+1 = 10

  for count =10: loop does not enter

  count value ends with 10

• Question 37:

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

  A. UPDATE

  B. ALTER

  C. CREATE

  D. REPORT

  Correct Answer: C

  Data Definition Language (DDL) commands refer to SQL commands that add to or modify the structure of the database. Some examples of data definition commands are:

  CREATE—this command can be used to add a new database on the RDBMS server (CREATE DATABASE) or to add a new table within an existing database (CREATE TABLE). The primary key and foreign key can be specified as part of

  the table definition.

  ALTER TABLE—this allows you to add, remove (drop), and modify table columns (fields), change a primary key and/or foreign key, and configure other constraints. There is also an ALTER DATABASE command, used for modifying

  properties of the whole database, such as its character set.

  DROP—this is the command used to delete a table (DROP TABLE) or database (DROP DATABASE). Obviously, this also deletes any records and data stored in the object.

  CREATE INDEX-specifying that a column (or combination of columns) is indexed speeds up queries on that column. The tradeoff is that updates are slowed down slightly (if the column is not suitable for indexing, updates may be slowed

  down quite a lot.) The DROP INDEX command can be used to remove an index.

• Question 38:

  A company will begin to allow staff to work from home by means of formal request. Which of the following is the BEST way for the company to document this change?

  A. Written procedure

  B. Written policy

  C. Written email

  D. Written memo

  Correct Answer: B

  Formal = Policy

• Question 39:

  A company's team members have both old and new laptops. Which of the following connectors should be available in the conference room to ensure everyone can use the conference room projectors? (Choose two.)

  A. USB

  B. HDMI

  C. FireWire

  D. VGA

  E. Bluetooth

  F. RJ45

  Correct Answer: BD

• Question 40:

  A programmer uses DML to modify:

  A. files

  B. permissions

  C. data

  D. backups

  Correct Answer: C

  DML = data manipulation language