WorksheetsCompTIA FC0-U61 Exam - Questions and Answers
Total questions: 100
Worksheet time: 53mins
Which of the following is a type of internet connection?
Cable
Fiber optic
Wireless network
DSL
After a patch of an enterprise server, applications were unable to load. The server administrator was able to resolve the issue. Which of the following is the next step the administrator should take?
Test the theory to determine the cause.
Document findings, actions, and outcomes.
Establish a plan of action.
Verify full system functionality.
Which of the following is the least expensive way for users at a large company to load a 2GB spreadsheet quickly?
Buy faster networking switches.
Upgrade the operating system and applications.
Move the file to a shared database.
Add more RAM to each workstation.
Which of the following is the best way to prevent malicious code from executing on a laptop based on attack signatures?
Host-based firewall
Antivirus
Patching
Network-based firewall
An administrator is preparing a workstation for deployment. Which of the following is the first step the administrator should take in this process?
Enable the host firewall.
Install OS updates.
Change the default administrator password.
Remove unnecessary software.
On which of the following distinct numbers of digits is the hexadecimal numbering system based?
2
8
10
16
A user is selecting software to visually display information in a marketing meeting. Which of the following software types should the user select?
Spreadsheet
Word processing
Web browsing
Presentation
Which of the following software types is best suited for storing large amounts of data in a way that allows for concurrent, indexed access?
Spreadsheet software
Visual diagramming software
Database software
Presentation software
Which of the following best practices can be used to mitigate password reuse?
Password length
Password complexity
Password reset
Password history
A technician is installing an MFD. After installation, all functions work except faxing. Which of the following interfaces is required to enable faxing functionality?
RJ11
RJ45
USB
Bluetooth
Which of the following is an example of multifactor authentication?
Token and one-time password
Fingerprint and retina scan
Smart card and PIN
Username and password
Which of the following would most likely be used to protect the intellectual property of printed materials?
Trademark
Cease and desist
Patent
Copyright
An engineer has been assigned the task of establishing network connectivity in a remote area where telephone lines are readily available but other infrastructure is limited. Which of the following technologies would be the best solution?
DSL
Fiber optic
Satellite
Cellular
Which of the following operating systems is best used in creating and managing virtual machines?
Mobile
Hypervisor
Embedded
Firewall
A systems administrator wants to configure a program to run each time a server reboots. Which of the following utilities is the administrator most likely to use?
Task Scheduler
Device Manager
Disk manager
Policy editor
Which of the following is an example of an interpreted programming language?
Markup language
Query language
Assembly language
Compiled language
A company is looking at locations for a new datacenter. The Chief Executive Officer (CEO) has stated that the new datacenter should be at least 500mi (805km) from the existing data center so one natural disaster will be unlikely to impact both datacenters.
Geographic diversity
Geographic separation
Which of the following is a concern when a system is not available for use?
Confidentiality concerns
Integrity concerns
Replication concerns
Availability concerns
A software developer has created a program for the accounting department. The finance department requests the same program but requires some changes to the code to meet its needs. Which of the following should be performed?
Compiling
Looping
Sequencing
Branching
A developer is writing a script to calculate a bank account balance within two decimal places. Which of the following data types should the developer select to store the balance?
Boolean
Integer
Float
Char
An accounting firm needs to allow users to update records simultaneously without errors. Which of the following best meets the firm's needs?
Flat file
Document
Database
Spreadsheet
A technician is configuring a new Windows PC and needs to choose a filesystem that supports encryption. Which of the following is the technician most likely to choose?
NTFS
FAT32
HFS
ext4
After creating a database, which of the following would a developer most likely use to put data in the database?
UPDATE
ALTER
INSERT
SELECT
Which of the following data types is used to implement a simple counter application?
Boolean
Integer
String
Floating point
A user works at a health insurance company. Which of the following is the best method for ensuring a customer’s personal information is kept confidential when it needs to be shared with another authorized employee?
Sending it as an encrypted email to the other employee
Putting it in a shared drive on the company’s network
Which of the following allows network traffic to pass through it and filters specific packets?
Switch
Access point
Modem
Firewall
Which of the following language types most likely controls the way a web page looks?
Assembly language
Markup language
Compiled language
Scripted language
Which of the following notational systems includes alpha and numeric values?
Binary
Hexadecimal
Octal
Decimal
A user opens an application that is installed locally on a PC. The application connects directly to a database that is located on a server in a data closet in the same building. Which of the following application architecture models does this describe?
One tier
Two tier
Three tier
Four tier
Which of the following units of storage would be used to measure the amount of RAM on a desktop computer?
TB
GB
MB
KB
Which of the following is an advantage of using locally saved files?
Readily shareable with others
No reliance on local backups
Immediately accessible by others on the cloud
No dependence on network connection
Which of the following is the best reason to implement a software token instead of a hardware token?
A software token can be set to a permanent number that never changes.
A software token can be encrypted.
A software token is more cost efficient than a hardware token.
A software token cannot be lost.
Which of the following would be the most cost-effective method to increase availability?
Redundant equipment
Disaster recovery site
Continuity plan
Scheduled maintenance
A hacker was able to obtain a user’s password for email, social media, and bank accounts. Which of the following should the user do to prevent this type of attack in the future?
Delete the tracking cookies.
Avoid password reuse.
Use a complex password.
Clear the browser cache.
A building has two legacy APs. A new AP was recently installed within 30ft (9m) of the legacy APs. Multiple users have been reporting intermittent internet connectivity since the new AP was installed.
WEP is enabled.
There are inference and attenuation factors.
There are speed limitations.
The passwords are not synced.
After purchasing a flash drive, the buyer notices that the packaging had already been opened. Which of the following is this an example of?
Confidentiality
Availability
Integrity
Non-repudiation
Which of the following is a reason for using a UPS?
To help with posture
To clean power
To prevent viruses
To lessen eye strain
A technician has established a plan of action. Which of the following should the technician do next?
Verify system functionality.
Identify preventive measures.
Document the findings.
Implement a solution.
Which of the following are most likely to have a GUI?
B. Windows
C. Command Prompt
D. macOS
E. Z shell
A. PowerShell
Which of the following violates password best practices?
Password reuse across sites
Password history
Password expiration
Password complexity
All confidential documents must be shredded before disposal to avoid which of the following types of attacks?
Shoulder surfing
Destruction
Dumpster diving
Social engineering
A database administrator has created a primary table and must ensure the date column in the table only accepts date values. Which of the following does the administrator need to set?
Schema
Primary key
Constraint
Permissions
Which of the following is a characteristic of both a database and a flat file?
A. Concurrent users
B. Persistence
C. Queries
D. Data definition
Which of the following should a technician do to fix stability issues on a workstation?
Install a malicious software analyzer.
Install a firewall.
Install browsing controls.
Install updates.
Which of the following is the main purpose for a MAC address to identify?
A user
A piece of hardware
An IP address
A network
A database developer needs to retrieve only the records that show customers in the state of Arizona. Which of the following statements would return those results?
SELECT * FROM Customers WHERE State IS NULL
SELECT * FROM Customers WHERE State = 'Arizona'
SELECT * FROM Customers ORDER BY 'Arizona'
SELECT State FROM Customers WHERE Region is 'Arizona'
Which of the following is a quality of solutions created by web browsers?
Proprietary
Cross-platform
Single platform
Site licensed
Multiple users need to access the same data simultaneously. Which of the following is the best place to store the data?
Database
Spreadsheet
Text file
Word processing document
Which of the following describes the ability to recover access to a specific account if a credential is forgotten?
Given the following code: 1 Dim Var as Integer 2 Set Var = 1 3 4 If Var = 6 Then Print "Done" 5 Else Set Var = Var + 1 6 Print "Not Yet" 7 Goto 3 8 EndIf 9 10 OnError Print "Error" Which of the following lines indicates the start of code branching?
1
2
4
10
Users are required to install a certificate in order to access commercial web pages through a corporate proxy server. Which of the following Windows Control Panel applets would enable users to verify the needed certificate is installed?
Network and Sharing Center
System
Programs and Features
Internet Options
Which of the following are data manipulation SQL commands?
ALTER
UPDATE
MODIFY
INSERT
DROP
Which of the following is considered a password best practice?
Updating a password on a weekly basis
Using a family member’s name as a password
Choosing an eight-character password
Changing a password at least every 90 days
Given the following pseudocode: WHILE X < 12 - print "Counting" X += 1 - If X=7, which of the following is the number of times the message will be displayed?
Five
Seven
Eleven
Twelve
Which of the following backup types is most likely to allow restoration of a fully bootable computer on new hardware?
File-level backups
Critical data backups
System backups
Database backups
Which of the following should be done first when working on a potential issue?
Implement a solution.
Escalate the issue.
Research the issue.
Gather information.
Which of the following describes a business continuity plan?
A business continuity plan keeps essential services up.
A business continuity plan is only required for large companies.
A business continuity plan is only required for smaller companies.
A business continuity plan provides full redundancy for all services.
After a user connects a laptop to a newly purchased printer, the user is unable to print. Which of the following is most likely causing the issue?
The OS updates have not been applied on the laptop.
The security software is out of date.
The printer drivers are not installed.
The firewall has not been configured.
Which of the following software types is best suited to create a table and graph using an existing data set?
Word processing
Presentation
Visual diagramming
Spreadsheet
Which of the following best protects data in transit?
Backup tapes
Encrypted flash drive
VPN connection
FTP
A technician needs to install and configure a wireless SOHO network. Which of the following should the technician configure to reduce Wi-Fi interference from other household appliances?
2.4GHz
5GHz
802.11b
802.11g
A small company has authorized an allowance for employees to purchase their own work computers. The administrator has noticed a sizable increase in network traffic following the arrival of the new computers. Which of the following is the most likely reason?
Unnecessary OEM software
Lack of antivirus present
Online gaming activity
Firewalls are not configured
When working with storage, 1,000,000MB can also be notated as:
0.01PB.
1TB.
100GB
10,000,000KB.
Which of the following database types would be best in which to place financial data?
Unstructured
Semi-structured
Structured
Spreadsheet
Which of the following is the greatest benefit of using a cloud-hosted solution?
Multiple users can have simultaneous access.
The solution has the lowest cost.
Data can be accessed from anywhere.
The fastest data transfer rate can be achieved.
A procedure to uninstall unwanted or suspicious software is called:
Software removal
Software installation
Software update
Software activation
Which of the following internal computing components is typically tasked with handling complex mathematical calculations required for realistic in-game physics?
A. RAM
B. NIC
C. GPU
D. CPU
Which of the following is secure?
.edu
FTP
HTTPS
.org
FAT32
Which of the following best describes the differences between data and information?
Data is a result of the analytical processing of information.
Information is raw unstructured or uncorrelated data.
Information can exist without data.
Data can be facts, figures, or events that can be processed to create information.
Which of the following components is most likely to have a dedicated, active cooling method to prevent it from overheating during operation?
CPU
GPU
Motherboard
Power Supply
Which of the following is the best method to remove a software application from a computer?
Deleting the folder from program files
Deleting the software using Control Panel and features
Deleting the software folder using File Explorer
Deleting the icon from the desktop
Which of the following interfaces is best for viewing database performance information?
Direct
Programmatic
Query
Utility
Which of the following defines a reusable value that can be reassigned?
Method
Variable
Constant
Function
Which of the following will best ensure a workstation is protected against attacks over unused ports?
Implement IDS.
Configure a firewall
Install an antivirus.
Disable USB.
A user is having trouble accessing an application. Which of the following should a help desk analyst do first?
Determine whether the trouble is an access or a network issue.
Check the user's permissions to ensure the user has access.
Reset the user's credentials for the application.
Document the solution and notify the user.
A flatbed scanner that is connected a laptop is used to convert photographic prints to digital images for reproduction on a color printer. Which of the following is considered the input device for this process?
Laptop hard drive
Laptop keyboard
Photographic prints
Flatbed scanner
Color printer
Which of the following actions takes place during the problem identification phase?
Documenting the findings
Duplicating the issue
Establishing a theory of probable cause
Questioning the obvious
A programmer needs to specify how to store a test score entered using a web form. Which of the following would be best to use?
Variable
Vector
Constant
Array
Which of the following is the smallest unit of measurement?
KB
TB
Bit
Byte
Which of the following is something found on a laptop but not on a tablet?
Local storage
Keyboard
Wired Ethernet connection
Display
Which of the following is most appropriate to list on a social media site about an employer?
Work email
Job title
Hire date
Customers served
Which of the following programming languages would most likely include tables and the SELECT command?
Compiled
Markup
Query
Scripting
Given the following pseudocode: INITIALIZE variable NAME to "" INITIALIZE variable TIME to "NOON" INITIALIZE variable DATE to "MONDAY" If TIME == "NOON" Set variable NAME to "foo" Else if TIME == "MIDNIGHT" Set variable NAME to "bar" If DATE == "Monday" Set variable NAME to NAME concatenated with "sad" Else if DATE == "Friday" Set variable NAME to NAME concatenated with "happy" Print NAME Which of the following would be the output of the program?
A. foohappy
B. barsad
C. foosad
D. barhappy
Which of the following would be the most effective use of a database?
To keep a list of vendors to call daily
To store visitor information at each location
To list basic employee information for distribution
To automate input of financial transactions and run daily reports
A user installs a wireless router and opens a browser to modify the settings. Which of the following installation types does this describe?
Web-based
Plug-and-play
Driver-based
Server-based
A customer is looking for a device that uses tap to pay when making purchases. Which of the following technologies should the customer use?
Wi-Fi
IR
Bluetooth
NFC
A network technician needs to ensure data on a network drive is fully backed up. Which of the following backups should the technician implement?
Full backup
Incremental backup
Differential backup
Mirror backup
A small videography business is requesting an internet connection that provides flexibility and is immune to electromagnetic interference over long distances. Which of the following is best suited for this situation?
Cable
Cellular
Satellite
Fiber optic
Which of the following notational systems uses the most characters to represent the decimal number 10?
Octal
Hexadecimal
Decimal
Binary
A company wants a group of networking professionals to have access to the server but must ensure that access is granted only to authorized users. Which of the following is best suited to ensure authorization and accounting?
Permissions
Multifactor authentication
Logs
Internet browsing history
Video
Privacy expectations on a company intranet should be limited to:
precedents.
HR policy.
word of mouth.
system usage agreements.
A technician is running two Wi-Fi networks. Both of the networks have the same network name, but they have different channels and different frequencies. During testing, the connection becomes intermittent. Which of the following should the technician do to obtain a stable connection?
Change the SSID.
Disable the captive portal
Update the Wi-Fi passwords.
Disable the network broadcast.
Given this section of code: set counter = 1 while counter < 10 do print counter if counter = 5 break counter = counter +1 Which of the following is the break command an example of?
A. Array
B. Output
C. Loop
D. Branch
Which of the following is a query language?
C++
HTML
Python
SQL
An application developer needs to test multiple operating systems on one host. Which of the following would be the best choice for the test server?
Type 1 hypervisor OS
Server OS
Embedded OS
Workstation OS
Which of the following best describes when to use an array?
The user needs to store multiple values in one object
The user needs the object to store one value and to be changeable
The user needs one object to store numbers only.
The user needs the object to store one value permanently.
A programmer chooses a database for a new application that needs to store information, including dates, times, names, and amounts. Which of the following database features is this an example of?
Concurrency
Speed
Scalability
Variety
Which of the following is required to view videos stored on a DVD?
Solid-state drive
Flash drive
Hard drive
Optical drive
A database administrator needs to add a column to an existing table? Which of the following statements should the administrator use?
CREATE
UPDATE
ALTER
DROP
An employee is on an elevator, and a stranger asks where the employee works and who the network administrator is. This is an example of:
eavesdropping
social engineering
dumpster diving
on-path attack
