Final Exam Sample Questions

Imagine you're the IT expert at a company. You're tasked with implementing an on-premises ERP system. Which of the following is NOT a magical challenge you'll face on this epic quest?

• High initial costs

• Customization requirements

• Resistance from employees

• Lack of internet connectivity

Which of the following best defines metadata in a database?

• Data that describes other data, such as field names and data types.

• The content stored in the database tables.

• Encrypted data used for security purposes.

• Redundant data stored for backup purposes.

What is the primary purpose of supply chain execution systems?

• To predict future supply and demand trends.

• To manage the flow of products, information, and finances.

• To reduce marketing costs for retailers.

• To optimize customer-facing processes.

Which of the following best describes the role of TCP in ensuring their messages arrive safely and in order?

• Ensures reliable data transmission between devices.

• Defines the structure of IP addresses.

• Manages wireless LAN connections.

• Encodes multimedia data for faster transmission.

Imagine Olivia is managing a database for a bustling marketplace. She has two tables: Part (with Part ID as the primary key) and Supplier (with Supplier ID as the primary key). In this marketplace, a supplier can offer a variety of parts, but each part is exclusively provided by one supplier. Can you help Olivia figure out which attribute should be used as the foreign key?

• Part table, Part ID

• Supplier table, Supplier ID

• Part table, Supplier ID

• Supplier table, Part ID

BrightTech is on a mission to transfer to the cloud! If they are developing custom applications while keeping infrastructure management to a minimum, which cloud service model should they choose?

• IaaS

• PaaS

• SaaS

• DaaS

Isla, a data enthusiast, is exploring the world of retail analytics. She discovers that customers who buy bread often end up buying butter too! What magical data mining technique has Isla stumbled upon?

• Clustering

• Prediction

• Classification

• Association

Which of the following is not a popular operating system for server?

• Linux

• Window

• Unix

• MacOS

Which of the following is an example of an application program?

• Salesfore.com

• Unix

• Window

• Linux

A record is a characteristic or quality used to describe a particular entity

• True

• False