Final Exam Sample Questions

Imagine you're the IT wizard at a company, and Kai, Hannah, and Benjamin are your trusty sidekicks. 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

Hey there, database detectives! Can you help Abigail, Harper, and Mia figure out 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.

Hey there, supply chain detectives! Can you help James and Ava figure out 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.

Imagine Aria and David are trying to send secret messages to each other over the internet. 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.

Susan, the CRM wizard, is on a mission to boost repeat purchases by tracking customer interactions across multiple channels. If her goal is to enchant customers into coming back for more, which magical CRM functionality should she focus on?

• Marketing campaign automation

• Customer service management

• Supply chain integration

• Financial reporting

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 conquer the cloud! If Sophia and Jackson are tasked with 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

Imagine you're running a digital-first retail company, just like Pinduoduo, and you're on a mission to conquer the social media universe for customer acquisition. Which of the following strategies would make Ethan, Michael, and Grace cheer for your business savvy?

• Investing heavily in traditional advertising campaigns

• Focusing on a high-end, luxury product line

• Investing in large warehouses and building their own logistics

• Offering group-buying discounts through social networks

Imagine you're in a startup run by Charlotte and Michael, where all customer orders and payments are handled through a snazzy mobile app, just like Luckin Coffee. What's the coolest perk of this tech-savvy approach?

• Streamlined data collection for customer behavior analysis

• Lower hardware costs for supply chain operations

• Enhanced in-store shopping experience

• Reduced need for marketing expenditures