Create and Organize Objects in Unity Catalog DP-750 Practice Questions (Page 8)

Questions 36–40

1. 36foundation · easy

   What is the difference between a managed table and an external table in Unity Catalog?

   • AManaged tables are stored in a schema, while external tables are stored in a volume.
   • BManaged tables store data in the cloud storage location managed by Unity Catalog, while external tables reference data in a user-specified location.
   • CManaged tables are always in Delta format, while external tables are always in Parquet format.
   • DManaged tables can only be created by administrators, while external tables can be created by any user.
   Reveal Solution Discussion Select an answer first
2. 37expert · hard

   You have an external table in Unity Catalog that points to a cloud storage path. The underlying data files have been replaced with a new schema that includes an additional column. You need to update the table to reflect the new schema without losing any existing permissions. What should you do?

   • ARun ALTER TABLE ADD COLUMN to add the new column.
   • BDrop and recreate the table with the new schema.
   • CRun REFRESH TABLE to update the schema.
   • DCreate a new external table with the same location and new schema.
   Reveal Solution Discussion Select an answer first
4. 38foundation · easy

   What is the primary use case for a volume in Unity Catalog?

   • ATo store unstructured and semi-structured data files, such as JSON, images, or CSV files.
   • BTo store database connection strings and credentials.
   • CTo store SQL scripts and notebooks.
   • DTo store structured tabular data for SQL queries.
   Reveal Solution Discussion Select an answer first
5. 39foundation · easy

   Which command is used to create a foreign catalog in Unity Catalog?

   • ACREATE CATALOG catalog_name WITH CONNECTION connection_name;
   • BCREATE FOREIGN CATALOG catalog_name USING CONNECTION connection_name;
   • CCREATE CATALOG catalog_name FROM CONNECTION connection_name;
   • DCREATE EXTERNAL CATALOG catalog_name CONNECTION connection_name;
   Reveal Solution Discussion Select an answer first
6. 40expert · hard

   You are configuring AI/BI Genie for a catalog that contains multiple schemas with similar table names (e.g., sales.orders and marketing.orders). Users often ask about 'orders' without specifying a schema. What should you include in the Genie instructions to reduce ambiguity?

   • ARename all tables to be unique across schemas.
   • BGrant Genie access to only one schema.
   • CSpecify the default schema for common terms like 'orders' and explain the difference between schemas.
   • DCreate a view that unions both orders tables.
   Reveal Solution Discussion Select an answer first