Font size
WorksheetsITF+ Study Quiz 3
Total questions: 51
Worksheet time: 2hrs 42mins
A developer needs to add a table to a database. Which of the following database activities should the user perform?
UPDATE
ALTER
CREATE
REPORT
Which of the following does a NoSQL database use to organize data?
Primary keys
Schemas
Keys/values
Tables
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
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
Which of the following BEST describes the physical location of the data in the database?
Table
Column
RAM
HDD
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
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
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
Which of the following types of encryption would BEST protect a laptop computer in the event of theft?
Disk
VPN
HTTPS
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.
A technician overhears a systems administrator mention the term 'IOPS'. To which of the following operating system functions would the term BEST apply?
Disk management
Process management
Application management
Service management
Which of the following is the BEST option for a developer to use when storing the months of a year and when performance is a key consideration?
Array
Vector
List
String
A company wants an application to be accessed by concurrent users and store company information securely. Which of the following would be the BEST option for storing the information?
Word processing document
Flat file
Database
Spreadsheet
Which of the following would MOST likely use an ARM processor?
Laptop
Tablet
Workstation
Server
A systems administrator wants to run a script at a certain time every day. Which of the following is the BEST way to achieve this?
Perform process management
Perform task scheduling
Set the system date and time
Set a reminder to run the script
Which of the following would indicate the FASTEST processor speed?
3.6GHz
3.6Mhz
3.6Mbps
3.6Gbps
A gaming console needs to allow for inbound connectivity on a home network to facilitate chat functions. Which of the following devices is a user MOST likely to configure to allow this?
Cable modem
Wireless router
Access point
Network switch
The computer language that is closest to machine code is:
query language
scripting language
markup language
assembly language
Employee information is stored in a database. Which of the following BEST describes where all of an employee's information is stored?
Record
Report
Column
Procedure
Which of the following is an example of an interpreted language?
C++
Java
Python
Go
An employee's laptop does not connect to the Internet when it is used in a coffee shop. Which of the following is the MOST likely cause?
Script blocker
Proxy settings
Private browsing
Full browser cache
Which of the following filesystems would a Linux computer MOST likely use?
HFS
NTFS
FAT32
ext4
Which of the following concerns does installing cross-platform software address?
Subscription
Licensing
Product key
Compatibility
Which of the following requires the MOST frequent updating to remain effective?
Antivirus
Host firewall
Web browser
Device drivers
Which of the following BEST explains the use of float over integer to store monetary values?
It accepts negative values.
It stores symbols
It accommodates larger values.
It supports decimals.
An IP address is 32 bits long. If converted to bytes, it would be:
4 bytes
8 bytes
16 bytes
64 bytes
Which of the following BEST describes the purpose of a vector in programming?
Storing a collection of data
Repeating a similar operation
Capturing user input
Performing mathematical calculations
Which of the following WiFi security options would create the MOST need for a VPN connection on the client device?
Open
WEP
WPA
WPA2
Which of the following BEST describes a technology that allows multiple users to create and edit reports at the same time?
Text file on a shared drive
Managed relational database
Informational intranet page
Locally installed productivity software
A company has installed an application that only requires a workstation to function. Which of the following architecture types is this application using?
One-tier
Two-tier
Three-tier
n-tier
A global variable called 'age' will be created in a program and incremented through the use of a function. Which of the following data types should be defined with the age variable?
Integer
Float
Double
String
Meaningful and accurate reporting is essential to retailers in making business decisions while managing inventory. Which of the following offers the BEST assistance in generating reports?
Data capture and collections
Asset inventory inputs
Sales statistics
Average loss output
A business would like to create an employee portal that employees will have access to when they are at work. The employees will not be able to connect to the portal from home without a VPN connection. Which of the following types of application does this describe?
Local application
Intranet application
Extranet application
Internet application
A computer technician receives a ticket to install a laptop for a new employee. Due to the workspace layout, the employee requests that the laptop be installed with the lid closed. Which of the following would be necessary to fulfill this request? (Choose two).
External hard drive
Mouse
Webcam
Monitor
Printer
A company wants its employee to use an email client that downloads and deletes messages from the email server. Which of the following protocols should be configured on the email client to facilitate this?
POP3
IMAP
ICMP
SMTP
Consider the following statements: if userin = "commander" then clearance = "topsecret" else if userin = "analyst" then clearance = "restricted" else clearance = "normal" Given the input (userin) of 'analyst', which of the following would the clearance variable be set to?
topsecret
normal
analyst
restricted
Which of the following is a reason why complex passwords are required?
To encourage password variety
To prevent someone from guessing them
To make them harder to remember
To reduce social engineering attacks
A technician is troubleshooting an error message and tests the same program on a separate, identical machine. Which of the following troubleshooting methodology steps is this an example of?
Duplicate the problem
Gather information
Question users
Divide and conquer
Which of the following storage types is MOST vulnerable to magnetic damage?
Flash
SSD
Optical
HDD
When developing a game, a developer creates a boss object that has the ability to jump. Which of the following programming concepts does jump represent?
Method
Object
Property
Attribute
Concerned with vulnerabilities on a home network, an administrator replaces the wireless router with a recently released new device. After configuring the new device utilizing the old SSID and key, some light switches are no longer communicating. Which of the following is the MOST likely cause?
The light switches do not support WPA2.
The router is operating on a different channel.
The key does not meet password complexity requirements.
The SSID is not being broadcast.
Given the following pseudocode: For each apple in the basket, eat two oranges unless it is the last apple, then eat three oranges. If there are seven apples in the basket, which of the following would be the number of oranges a person eats?
10
14
15
17
Which of the following are the primary functions of an operating system? (Choose two.)
Provide system resources.
Provide peer-to-peer networking capability.
Provide user data encryption.
Provide protection against malware and viruses.
Provide structure for file and data management.
SQL databases use primary and foreign keys to enable which of the following?
Rows
Fields
Schemas
Relationships
Which of the following is a logical structure for storing files?
Folder
Extension
Permissions
Shortcut
Which of the following is both an input and output device?
Microphone
Speaker
Touch-screen monitor
Keyboard
A technician has successfully verified full system functionality after implementing the solution to a problem. Which of the following is the NEXT troubleshooting step the technician should do?
Determine if anything has changed.
Document lessons learned.
Establish a theory of probable cause.
Duplicate the problem, if possible.
A large payment website was breached recently. A user is concerned that the breach will affect account security on other sites. Which of the following password best practices would mitigate this risk?
Password history
Password reuse
Password expiration
Password age
Which of the following can be used to increase database availability?
Backups
Prioritization
Indexes
Failover
Which of the following would MOST likely identify the issue when a user is warned that a website may not be secure?
Checking the proxy settings
Checking that caching is enabled
Checking browser add-ons
Checking certificate validity
Which of the following describes where the user should verify the port is open for remote desktop on a PC?
Antivirus
Anti-malware
Device Manager
Host firewall
