IT 423 Module Seven Lab: Connecting IoT Device
to Database| 2026 Update | Questions 1-150 with
Complete Solutions
Section 1: Introduction & Architecture Overview (Questions 1-30)
Question 1
Which architectural pattern is primarily used to connect IoT devices to databases in the
IT 423 Module Seven Lab?
A) Request-response pattern
B) Publish-subscribe pattern
C) Peer-to-peer pattern
D) Client-server pattern only
Answer: B) Publish-subscribe pattern
*Rationale: * The publish-subscribe pattern involves publishers (IoT devices) sending
messages to topics without knowing who receives them, while subscribers (database
connectors) receive messages without knowing who published them. A message broker
manages this distribution, decoupling devices from data storage .
,Question 2
What is the primary role of a message broker in an IoT-to-database pipeline?
A) To store sensor data permanently
B) To act as an intermediary that decouples IoT devices from database connectors
C) To execute SQL queries
D) To generate sensor data
Answer: B) To act as an intermediary that decouples IoT devices from database
connectors
*Rationale: * The message broker mediates between data producers and consumers,
allowing IoT devices to publish data even when the database is temporarily unavailable.
The MQTT broker stores messages (depending on QoS) until subscribers retrieve them .
Question 3
Which of the following is a valid IoT device-to-database architecture pattern covered in
the IT 423 course?
A) Device → Direct SQL connection → Database
B) Device → MQTT Broker → Connector → Database
C) Device → Email → Database
D) Device → FTP → CSV → Database
Answer: B) Device → MQTT Broker → Connector → Database
*Rationale: * The standard architecture uses an MQTT broker as an intermediary and a
connector service to bridge from MQTT to the database. Direct SQL connections from
constrained IoT devices are impractical, and email/FTP are not suitable for real-time data .
Question 4
,What is a "Device Shadow" in IoT database architectures?
A) A physical backup of the device
B) A virtual representation of the device's state synchronized in the cloud
C) A security feature that masks the device's IP address
D) A shadow copy of the device's firmware
Answer: B) A virtual representation of the device's state synchronized in the cloud
*Rationale: * A Device Shadow is a JSON document that stores the current state of an IoT
device, even when the device is offline. Applications can read or write to the Shadow, and
the service synchronizes changes when the device reconnects. This is common in AWS IoT
Core and similar platforms .
Question 5
Which of the following is typically required when setting up an IoT device connection to
a database?
A) The device's MAC address only
B) Connection string, authentication credentials, and topic configuration
C) The device's GPS coordinates
D) A static IP address for the device
Answer: B) Connection string, authentication credentials, and topic configuration
*Rationale: * Connecting an IoT device to a database requires a connection string
(database location), authentication (username/password or API key), and topic/channel
configuration (where to publish or subscribe) .
Question 6
, Which attributes are typically collected when registering a new IoT device in a university
database?
A) Device ID, assigned user (Teacher/Student ID), and Department name
B) CPU speed and RAM capacity
C) Purchase price and vendor contact information
D) Default gateway and subnet mask
Answer: A) Device ID, assigned user (Teacher/Student ID), and Department name
*Rationale: * The IT 423 course materials specify that the IoT Devices entity includes:
Device ID, Teacher ID, Student ID, Department name, and Department location. These
attributes support tracking device assignments and organizational context .
Question 7
In a publish-subscribe architecture, what happens if the database connector is
temporarily offline?
A) Sensor data is permanently lost
B) The MQTT broker stores messages in its queue or topic buffer until the connector
reconnects
C) The IoT device stops sending data
D) The broker automatically deletes all queued messages
Answer: B) The MQTT broker stores messages in its queue or topic buffer until the
connector reconnects
*Rationale: * The MQTT broker acts as an intermediary, receiving messages and storing
them temporarily (depending on QoS settings) until subscribers retrieve them. This
decoupling allows devices to publish even when database connectors are unavailable .
Question 8
to Database| 2026 Update | Questions 1-150 with
Complete Solutions
Section 1: Introduction & Architecture Overview (Questions 1-30)
Question 1
Which architectural pattern is primarily used to connect IoT devices to databases in the
IT 423 Module Seven Lab?
A) Request-response pattern
B) Publish-subscribe pattern
C) Peer-to-peer pattern
D) Client-server pattern only
Answer: B) Publish-subscribe pattern
*Rationale: * The publish-subscribe pattern involves publishers (IoT devices) sending
messages to topics without knowing who receives them, while subscribers (database
connectors) receive messages without knowing who published them. A message broker
manages this distribution, decoupling devices from data storage .
,Question 2
What is the primary role of a message broker in an IoT-to-database pipeline?
A) To store sensor data permanently
B) To act as an intermediary that decouples IoT devices from database connectors
C) To execute SQL queries
D) To generate sensor data
Answer: B) To act as an intermediary that decouples IoT devices from database
connectors
*Rationale: * The message broker mediates between data producers and consumers,
allowing IoT devices to publish data even when the database is temporarily unavailable.
The MQTT broker stores messages (depending on QoS) until subscribers retrieve them .
Question 3
Which of the following is a valid IoT device-to-database architecture pattern covered in
the IT 423 course?
A) Device → Direct SQL connection → Database
B) Device → MQTT Broker → Connector → Database
C) Device → Email → Database
D) Device → FTP → CSV → Database
Answer: B) Device → MQTT Broker → Connector → Database
*Rationale: * The standard architecture uses an MQTT broker as an intermediary and a
connector service to bridge from MQTT to the database. Direct SQL connections from
constrained IoT devices are impractical, and email/FTP are not suitable for real-time data .
Question 4
,What is a "Device Shadow" in IoT database architectures?
A) A physical backup of the device
B) A virtual representation of the device's state synchronized in the cloud
C) A security feature that masks the device's IP address
D) A shadow copy of the device's firmware
Answer: B) A virtual representation of the device's state synchronized in the cloud
*Rationale: * A Device Shadow is a JSON document that stores the current state of an IoT
device, even when the device is offline. Applications can read or write to the Shadow, and
the service synchronizes changes when the device reconnects. This is common in AWS IoT
Core and similar platforms .
Question 5
Which of the following is typically required when setting up an IoT device connection to
a database?
A) The device's MAC address only
B) Connection string, authentication credentials, and topic configuration
C) The device's GPS coordinates
D) A static IP address for the device
Answer: B) Connection string, authentication credentials, and topic configuration
*Rationale: * Connecting an IoT device to a database requires a connection string
(database location), authentication (username/password or API key), and topic/channel
configuration (where to publish or subscribe) .
Question 6
, Which attributes are typically collected when registering a new IoT device in a university
database?
A) Device ID, assigned user (Teacher/Student ID), and Department name
B) CPU speed and RAM capacity
C) Purchase price and vendor contact information
D) Default gateway and subnet mask
Answer: A) Device ID, assigned user (Teacher/Student ID), and Department name
*Rationale: * The IT 423 course materials specify that the IoT Devices entity includes:
Device ID, Teacher ID, Student ID, Department name, and Department location. These
attributes support tracking device assignments and organizational context .
Question 7
In a publish-subscribe architecture, what happens if the database connector is
temporarily offline?
A) Sensor data is permanently lost
B) The MQTT broker stores messages in its queue or topic buffer until the connector
reconnects
C) The IoT device stops sending data
D) The broker automatically deletes all queued messages
Answer: B) The MQTT broker stores messages in its queue or topic buffer until the
connector reconnects
*Rationale: * The MQTT broker acts as an intermediary, receiving messages and storing
them temporarily (depending on QoS settings) until subscribers retrieve them. This
decoupling allows devices to publish even when database connectors are unavailable .
Question 8
