Explanation
Configuring prompting before downloading content will help prevent infections caused by Internet browsing.
Prompting before downloading content is a browser setting that asks the user for confirmation or permission before downloading any file or program from a website. This setting can help prevent malware infections by allowing the user to check the source, type, and size of the file or program before downloading it. Prompting before downloading content can also help the user avoid unwanted or unnecessary downloads that may consume bandwidth or storage space. References : The Official CompTIA IT Fundamentals (ITF+) Study Guide (FC0-U61), page 202.

The most likely cause of the device being accessible via the LAN but not remotely is firewall settings. A firewall is a software or hardware device that filters incoming and outgoing network traffic based on rules and policies. A firewall can block or allow traffic based on factors such as source and destination IP addresses, ports, protocols, and applications. If the firewall settings are too restrictive or misconfigured, they may prevent remote access to the device from outside the LAN. Improper switch configuration is unlikely to cause this issue, as switches are devices that forward packets within the same network segment based on MAC addresses. Switches do not block or filter traffic based on IP addresses or ports. Incorrect IP address is unlikely to cause this issue either, as an incorrect IP address would prevent the device from communicating with any other device on the network, not just remotely. Misconfigured access point is also unlikely to cause this issue, as access points are devices that provide wireless connectivity to the network. If the device is connected via a wired network, the access point is irrelevant. Reference: CompTIA IT Fundamentals (ITF+) Study Guide: Exam FC0-U61, Second Edition, Chapter 3: Infrastructure, page 95

Explanation
The SELECT statement is used to query a database and retrieve a subset of data that matches the specified criteria. For example, SELECT * FROM Customers WHERE City = 'London' will return all the records from the Customers table where the City column is equal to 'London'. The SELECT statement can also be used to join multiple tables, perform calculations, sort and group data, and apply filters and functions. The SELECT statement is one of the most commonly used SQL commands and is essential for manipulating and analyzing data in a database.

IMPORT is the action that should be used to populate a database with large amounts of data from an external source. IMPORT is a command or function that allows a database to read and load data from an external file or source into a table or structure within the database. IMPORT can help a database administrator to transfer or migrate data from one database to another or from a different format to a database format. IMPORT can also help a database administrator to backup or restore data from a file or source. References : The Official CompTIA IT Fundamentals (ITF+) Study Guide (FC0-U61), page 143.

Explanation
A hard drive, also known as a hard disk drive (HDD), is a type of storage device that uses one or more rotating platters coated with magnetic material to store data. The platters are accessed by read/write heads that move across the surface of the platters as they spin. The data is stored as tiny magnetic regions on the platters, which can be changed or read by the heads. Hard drives are non-volatile, meaning they retain data even when power is off. Hard drives offer large storage capacity, low cost per gigabyte, and fast data transfer rates compared to other storage types. However, they are also prone to mechanical failures, noise, heat, and physical damage