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

Questions 31–33

1. 31foundation · easy

   What is the primary purpose of vectorization in the context of Amazon Bedrock knowledge bases?

   • ATo enable semantic search by converting text into embeddings
   • BTo increase the storage capacity of the knowledge base
   • CTo convert audio files to text
   • DTo replace the need for a vector database
   Reveal Solution Discussion Select an answer first
2. 32expert · hard

   A company runs a reporting workload on Amazon Redshift. The workload involves a complex query that joins several tables and aggregates data. The query is run frequently, but the underlying data only changes once a day. The query currently takes several minutes to complete, and users are complaining about the performance. The team wants to improve query performance without changing the underlying data model. Which optimization technique is most appropriate?

   • AAdd more nodes to the Redshift cluster to increase compute capacity.
   • BConvert the tables to use a columnar compression encoding.
   • CUse a different distribution style for the tables involved in the join.
   • DCreate a materialized view that pre-computes the results of the complex query.
   Reveal Solution Discussion Select an answer first
3. 33foundation · easy

   Which indexing best practice is most effective for accelerating queries that filter on a specific column in a large table?

   • AStore the column as a JSON document
   • BRemove all indexes to reduce overhead
   • CCreate an index on that column
   • DUse a wildcard prefix in queries
   Reveal Solution Discussion Select an answer first