Create Genie Spaces by Defining Reasonable Sample Questions and Domain-Specific Instructions, Choosing SQL Warehouses, Curating Unity Catalog Datasets (tables, Views...), and Vetting Queries as Trusted Assets. DATA-ANALYST-ASSOCIATE Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   Which of the following is an example of a clear, domain-specific instruction for a Genie space used by a retail sales team?

   • AUse technical terms from the data engineering team's documentation.
   • BAlways provide the most complex answer possible.
   • CAnswer all questions using data from the sales database only.
   • DIgnore any questions about product returns.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which of the following is a best practice when curating datasets for a Genie space?

   • AInclude only tables and views that are relevant to the intended business questions
   • BUse only views, never tables, to ensure data freshness
   • CAvoid using any datasets to keep the Genie space simple
   • DInclude all tables and views in the catalog to maximize data availability
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A retail company is creating a Genie space for store managers to ask about daily sales, inventory levels, and promotions. The data team has curated a set of tables in Unity Catalog, including sales transactions, product inventory, and promotion details. They want the Genie space to guide users toward common operational questions and reduce ambiguous queries. What should the data team do when setting up the Genie space?

   • ALeave the sample questions blank and rely on the AI to infer user intent from the curated tables.
   • BAdd sample questions like 'What were yesterday's sales by store?' and 'Which products are low in stock?'
   • CCurate only the sales transactions table and exclude inventory and promotion tables.
   • DWrite instructions that tell the AI to only answer questions about promotions and ignore sales and inventory.
   Reveal Solution Discussion Select an answer first
5. 4expert · hard

   A data analyst is responsible for maintaining a Genie space for a finance team. The analyst has received several queries from the AI that are returning incorrect results due to ambiguous joins between tables. The analyst wants to ensure that only accurate and reliable queries are available for reuse. What is the best approach?

   • AAdd more sample questions to guide the AI and assume the queries will be correct.
   • BReview each AI-generated query, fix any that are incorrect, and mark the corrected ones as Trusted Assets.
   • CDisable the AI's ability to generate queries and only use manually written queries.
   • DMark all AI-generated queries as Trusted Assets without review to save time.
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   What is the role of domain-specific instructions in a Genie space?

   • ATo replace the need for sample questions by providing all necessary context
   • BTo constrain the AI's responses to the intended business context and terminology
   • CTo define the exact SQL syntax the AI must use for all queries
   • DTo automatically fix any errors in user queries before they are executed
   Reveal Solution Discussion Select an answer first