Task 2.4: Design Data Models and Schema Evolution DEA-C01 Practice Questions (Page 5)

Questions 21–25

1. 21foundation · easy

   In DynamoDB, which component of the primary key determines the physical partition where an item is stored?

   • AGlobal secondary index
   • BPartition key
   • CSort key
   • DSecondary index key
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   In data stores, what is the primary benefit of partitioning a large table by date?

   • AQueries can scan only the relevant date partitions
   • BIt automatically compresses all data
   • CIt eliminates the need for indexes
   • DIt increases data duplication for redundancy
   Reveal Solution Discussion Select an answer first
4. 23foundation · easy

   Which AWS service provides ML Lineage Tracking to trace the relationships between datasets, jobs, and models in machine learning workflows?

   • AAWS Lake Formation
   • BAWS Glue
   • CAmazon Athena
   • DAmazon SageMaker
   Reveal Solution Discussion Select an answer first
5. 24foundation · easy

   Which partitioning strategy is most appropriate for a table that is frequently queried by a specific customer ID?

   • APartition by ingestion date
   • BPartition by data type
   • CPartition by customer ID
   • DDo not partition the table
   Reveal Solution Discussion Select an answer first
6. 25application · medium

   A mobile gaming company uses DynamoDB to store player profiles and game state. The table has player_id as the partition key and no sort key. A new feature requires querying all players who have a specific game level. The team is considering adding a Global Secondary Index (GSI) with game_level as the partition key. What is a key consideration for this GSI design?

   • AThe GSI will automatically provide strongly consistent reads for the new query.
   • BThe GSI will not incur any additional storage or write costs.
   • CThe GSI will be most efficient if the game_level values are highly selective, meaning each level has a relatively small number of players.
   • DThe GSI must include all attributes from the base table to be useful.
   Reveal Solution Discussion Select an answer first