NoSQL DATA-SCIENCE-OPTIMIZE Practice Questions (Page 5)

Questions 21–25

1. 21application · medium

   A company uses Apache HBase to store real-time transaction data. They need to run complex analytical queries, such as aggregations and joins, over this data. The analytics team is familiar with SQL. Which approach best integrates HBase with the Hadoop ecosystem for this purpose?

   • AUse Apache Hive to query HBase directly via the Hive-HBase integration
   • BUse Apache Phoenix to provide a SQL layer on top of HBase
   • CExport HBase data to HDFS and run Hive queries
   • DUse Apache Spark to read from HBase and run SQL queries via Spark SQL
   Reveal Solution Discussion Select an answer first
2. 22expert · hard

   A company uses Apache Hive for batch processing and wants to add a NoSQL database for real-time serving. They are considering using Apache Phoenix on top of HBase to provide SQL access. What is the primary benefit of this approach?

   • AIt allows the team to use SQL for both batch and real-time queries, reducing the learning curve
   • BIt provides strong consistency, which Hive lacks
   • CIt eliminates the need for HDFS, simplifying the architecture
   • DIt automatically replicates data to Hive for batch processing
   Reveal Solution Discussion Select an answer first
4. 23foundation · easy

   Which scenario is most appropriate for a NoSQL database with eventual consistency?

   • AManaging inventory levels where overselling must be prevented at all times.
   • BStoring medical records where immediate accuracy is critical for patient safety.
   • CProcessing financial transactions where every read must reflect the latest balance.
   • DServing a social media feed where a slight delay in post visibility is acceptable.
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   A logistics company needs to model a delivery network where packages move between warehouses and delivery hubs. The team wants to answer queries like 'find the shortest route from warehouse A to hub B' and 'which hubs are directly connected to warehouse A?'. The data is highly connected and relationships are the primary focus. Which NoSQL data model is most appropriate?

   • ADocument store with each warehouse storing an array of connected hubs
   • BGraph database with nodes for warehouses and hubs and edges for delivery routes
   • CKey-value store with route IDs as keys and route details as values
   • DColumn-family store with a column family for routes and row keys as warehouse IDs
   Reveal Solution Discussion Select an answer first
6. 25application · medium

   An IoT platform ingests sensor readings from millions of devices. Each device sends a reading every second, and the platform needs to store these readings for time-series analysis. Queries typically retrieve all readings for a specific device over a time range. Which NoSQL data model is most suitable?

   • AColumn-family store with device ID as the row key and timestamp as the column qualifier
   • BKey-value store with a unique key for each reading
   • CGraph database with devices and readings as nodes
   • DDocument store with each device as a document containing an array of readings
   Reveal Solution Discussion Select an answer first