Explain Data Concepts DA0-001 Practice Questions (Page 2)

Questions 6–10

1. 6foundation · easy

   In which of the following scenarios would a non-relational (NoSQL) database be the most appropriate choice?

   • AEnsuring data integrity through foreign key constraints
   • BStoring a catalog of products where each product may have a different set of attributes
   • CGenerating a report that requires aggregating data from five different tables
   • DManaging financial transactions that require strict ACID compliance and complex joins
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   Which of the following is a common limitation of using a flat file structure for data storage?

   • AIt is not human-readable
   • BIt cannot store numeric data
   • CIt is difficult to represent relationships between different sets of data
   • DIt requires a database management system to access the data
   Reveal Solution Discussion Select an answer first
4. 8expert · medium

   A multinational corporation is restructuring its reporting hierarchy. Currently, each employee reports to exactly one manager (a tree structure). The new structure will allow employees to report to multiple managers (e.g., a functional manager and a project manager). The HR system needs to support queries like 'find all managers of a given employee' and 'find all employees managed by a given manager.' Which data structure change is required?

   • AKeep the hierarchical structure but add a new level for project managers.
   • BUse a flat file with one line per employee listing all their managers.
   • CChange from a hierarchical tree to a network graph structure.
   • DUse a relational database with a self-referencing table.
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   An e-commerce company stores product information in a relational database. Each product has a unique product ID, a name, a price (decimal), and a category ID that references a separate categories table. The company wants to ensure that every product is assigned to a valid category. What is the most appropriate way to enforce this rule?

   • AUse a NoSQL document store to avoid the need for constraints.
   • BStore the category name directly in the product table instead of a category ID.
   • CDefine a foreign key constraint on the category ID column referencing the categories table.
   • DAdd a check constraint that the category ID is not null.
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   What is the primary purpose of using a primary key in a relational database table?

   • ATo uniquely identify each record in the table
   • BTo store large amounts of unstructured text data
   • CTo define the data type of each column in the table
   • DTo establish a relationship between two different tables
   Reveal Solution Discussion Select an answer first