Understand How the 3-Level namespace(Catalog / Schema / Tables or Volumes) Works in the Unity Catalog. DATA-ANALYST-ASSOCIATE Practice Questions (Page 2)

Questions 6–10

1. 6application · easy

   A data analyst needs to access a collection of CSV files stored in a volume. The volume is named 'raw_data' and is located in the 'bronze' schema of the 'data_eng' catalog. What is the correct fully qualified path to reference this volume?

   • Araw_data.bronze.data_eng
   • Bdata_eng.bronze.raw_data
   • Cbronze.data_eng.raw_data
   • Ddata_eng.raw_data.bronze
   Reveal Solution Discussion Select an answer first
2. 7expert · medium

   A data analyst needs to read a CSV file that is stored in a volume. The volume is named 'landing' and is in the 'raw' schema of the 'ingest' catalog. The analyst also needs to query a table named 'cleaned' in the 'curated' schema of the same catalog. What is the correct way to reference both the volume and the table?

   • AVolume: ingest.landing.raw, Table: ingest.cleaned.curated
   • BVolume: raw.ingest.landing, Table: curated.ingest.cleaned
   • CVolume: ingest.raw.landing, Table: ingest.curated.cleaned
   • DVolume: landing.raw.ingest, Table: cleaned.curated.ingest
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   What is a key benefit of using Unity Catalog's three-level namespace for data governance?

   • AIt eliminates the need for data lineage tracking.
   • BIt allows consistent access control policies across all data assets in a catalog.
   • CIt allows data to be stored in multiple clouds simultaneously.
   • DIt automatically encrypts all data.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   How does Unity Catalog's three-level namespace enable centralized governance and access control?

   • ABy encrypting all data at rest.
   • BBy providing a hierarchical structure where permissions can be applied at catalog, schema, or asset level.
   • CBy requiring all users to have admin privileges.
   • DBy storing all data in a single flat namespace.
   Reveal Solution Discussion Select an answer first
6. 10application · easy

   A data analyst is new to Unity Catalog and is trying to understand the hierarchy. They see a catalog named 'analytics', a schema named 'sales', and a table named 'orders'. Which of the following correctly describes the relationship between these objects?

   • AThe 'orders' table is inside the 'analytics' catalog, and the 'sales' schema is inside the 'orders' table.
   • BThe 'sales' schema is inside the 'analytics' catalog, and the 'orders' table is inside the 'sales' schema.
   • CThe 'analytics' catalog, 'sales' schema, and 'orders' table are all at the same level.
   • DThe 'analytics' catalog is inside the 'sales' schema, and the 'orders' table is inside the 'analytics' catalog.
   Reveal Solution Discussion Select an answer first