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 2)

Questions 6–10

1. 6expert · hard

   A data architect is setting up a Genie space for a healthcare organization. The data is stored in Unity Catalog, but some tables contain PHI (protected health information) that should not be accessible via the Genie space. The architect wants to provide a comprehensive data foundation for clinical analysts while ensuring PHI is not exposed. What is the best approach?

   • ACreate views that only include non-PHI columns from the relevant tables and grant the Genie space access to those views.
   • BCreate a new table that copies all data, including PHI, and use that table in the Genie space.
   • CUse only tables that do not contain any PHI, even if they are incomplete.
   • DAdd all tables, including those with PHI, to the Genie space and rely on the AI to avoid PHI.
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A data analyst has created a Genie space for a sales team. After reviewing the AI-generated queries, the analyst notices that one query consistently returns accurate results and is frequently used by the team. The analyst wants to make this query easily accessible and reliable for reuse. What should the analyst do?

   • AAdd the query as a sample question in the Genie space.
   • BCreate a new table that contains the query results.
   • CMark the query as a Trusted Asset in the Genie space.
   • DShare the query with the team via a notebook.
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A marketing team wants to create a Genie space to analyze campaign performance. The data is spread across multiple tables in Unity Catalog, including campaign spend, click-through rates, and conversion data. The team wants to simplify the data foundation for the Genie space. What is the best approach?

   • ACreate a new table that copies all data from the three tables into one wide table.
   • BAdd all three tables individually to the Genie space and let the AI figure out the joins.
   • CCreate a view that joins the campaign spend, click-through, and conversion tables, and use that view in the Genie space.
   • DUse only the campaign spend table and ignore the other tables.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   What is the purpose of curating Unity Catalog datasets for a Genie space?

   • ATo delete unused tables and views from Unity Catalog
   • BTo grant all users access to all datasets in the catalog
   • CTo create new tables and views from scratch for the Genie space
   • DTo select and organize the tables and views that the AI can use to answer questions
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   What is the purpose of marking a query as a Trusted Asset in a Genie space?

   • ATo indicate that the query has been reviewed and approved for reliable reuse
   • BTo delete the query from the Genie space after it is used once
   • CTo automatically optimize the query for faster execution
   • DTo restrict access to the query to only data analysts
   Reveal Solution Discussion Select an answer first