WorksheetsStudy Guide Review Round 3
Total questions: 25
Worksheet time: 13mins
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 user has purchased a high-end graphics card that contains a GPU. Which of the following processes is being performed by the GPU on the graphics card?
Input
Processing
Output
Storage
A technician installs a webcam to a computer and wants to install an updated driver. In which of the following would the technician find the MOST current driver?
Installation disc that came with the driver
Internet help-desk forums
OEM website for the camera
Computer manufacturer’s website
Which of the following internal computing components has the primary function of producing visual output to a monitor or other display device?
CPU
VGA
GUI
GPU
A home user is installing a calculator program. Which of the following BEST describes where the application is loaded?
Local
Cloud
Network
Shared drive
Which of the following will a company do to update a customer’s address while using a flat file database?
Update the address in the customer address table.
Update the address field in the customer order table.
Update the address for each order the customer placed.
Update the primary key to reflect the customer’s address.
A security administrator needs to set up multi-factor authentication for a cloud application. Which of the following should the administrator use to establish an authentication process?
Receipt and logs
Database and encryption
Password and software token
Name and ID
A project manager needs to compile a lot of start and end dates for events in a project. Which of the following software types is the project manager MOST likely to use?
Presentation software
Spreadsheet software
Word processing software
Visual diagramming software
An administrator sets up a role-based access for file shares. Which of the following concepts does this address?
Authorization
Accounting
Authentication
Non-repudiation
While installing applications on a home PC, a user repeatedly encounters prompts to confirm changes being made to the computer. Which of the following OS features is this MOST likely an example of?
DLP
GPO
GUI
UAC
Which of the following storage devices each have a spinning disk?
RAM and ROM
SSD and Flash Drive
HDD and Optical Drive
NIC and HDMI
The CEO has received several emails that are missing attachments. Which of the following concerns is the CEO experiencing?
Eavesdropping
Email service outage
Man-in-the-Middle Attack
Denial-of-Service Attack
A user is logging in to a website and has to input a code sent to a mobile device. Which of the following is this an example of?
PIN
Software token
Hardware token
One-time password
Which of the following is the BEST example of structured data?
Vendor order information stored in unnamed fields
Customer information that can be stored or grouped by any field
Employee beverage preferences organized in a single text field
Manager home address stored in a flat file without fields
Which of the following is the BEST method for ensuring there is no Telnet access?
Network sniffer
Antivirus software
Host-based firewall
Intrusion detection system
Which of the following types of software is MOST effective for tracking and communicating time spent on tasks for each team member?
Spreadsheet
Project management
Collaborative workspace
Personal information management
A home user has set up a new computer but notices that the disk space reported is 70% of what was advertised. Which of the following is the MOST likely cause?
Hidden disk partition
Disk configuration error
Wrong hard drive included
Different file system required
A database administrator needs to add five tables, two functions, and a procedure to a database. Which of the following statements should the administrator use?
ALTER
CREATE
INSERT
UPDATE
Which of the following computing devices is MOST likely to have an internal wireless antenna?
NAS
Server
Workstation
Mobile phone
A database administrator has created an object that retrieves a collection of specific records in a native format. Which of the following BEST describes what the database administrator created?
Import
Report
Query
Export
Which of the following is the BEST overall storage option for a laptop?
SD card
Hard drive
Flash drive
Solid-state drive
When a user on a corporate network uses instant messaging, which of the following should be assumed?
Anyone in the city can read the messages
Anyone in the world can read the messages
Anyone in the company can read the messages
Anyone in the IT department can read the messages
Which of the following encryption types would BEST be used to protect data on a shared computer?
File
VPN
Mobile
Which of the following will allow an organization to add additional servers without expanding the physical footprint within the corporate datacenter?
Hypervisor
Load balancer
Dynamic routing
Web applications
Which of the following programming language categories would the following snippet BEST represent? SELECT * FROM Contractors.Tbl;
Compiled language
Interpreted language
Query language
Assembly language
