Define Operations and Sequence to Write Given Chunked Text into Delta Lake Tables in Unity Catalog GENERATIVE-AI-ENGINEER-ASSOCIATE Practice Questions (Page 4)

Questions 16–19

1. 16application · medium

   A team is preparing a dataset of customer reviews for sentiment analysis. Each review is a few sentences long. They need to store the reviews in a Delta Lake table with a chunk_id and review_id. Which chunking strategy should they use?

   • AUse a fixed-size character splitter to split each review into smaller chunks.
   • BTreat each review as a single chunk and store it with a unique chunk_id.
   • CSplit each review into individual sentences and store each sentence as a separate chunk.
   • DCombine multiple reviews into a single chunk to increase chunk size.
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   Which SQL statement correctly creates a Delta Lake table in the schema 'rag' of the catalog 'main'?

   • ACREATE TABLE rag.main.documents (id INT, chunk TEXT)
   • BCREATE TABLE documents (id INT, chunk TEXT) IN main.rag
   • CCREATE TABLE main.rag.documents (id INT, chunk TEXT)
   • DCREATE TABLE main.documents (id INT, chunk TEXT) SCHEMA rag
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   What is the correct sequence of operations when writing chunked text to a Delta Lake table in Unity Catalog?

   • AWrite to Delta table → load text → chunk text
   • BChunk text → write to Delta table → create DataFrame
   • CLoad text → chunk text → create DataFrame → write to Delta table
   • DCreate DataFrame → load text → chunk text → write to Delta table
   Reveal Solution Discussion Select an answer first
5. 19application · medium

   A data engineer is writing a DataFrame to a Delta Lake table in Unity Catalog. They receive an error that the table does not exist. They know the catalog and schema exist. What is the most likely cause?

   • AThe user does not have permission to write to the table.
   • BThe DataFrame schema does not match the table schema.
   • CThe write mode is set to 'overwrite'.
   • DThe table name is not fully qualified with the catalog and schema.
   Reveal Solution Discussion Select an answer first