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

Questions 6–10

1. 6application · medium

   A company has enabled AI/BI Genie for its Unity Catalog. Business users are struggling to find the right tables because the catalog contains many similarly named schemas and tables. The data governance team wants to improve the discoverability of the most important tables. What should they configure in AI/BI Genie?

   • ARename all tables to include a prefix that indicates their business domain.
   • BWrite clear instructions that describe the purpose of key schemas and tables and how to use them.
   • CDisable AI/BI Genie for users who are not data engineers.
   • DCreate additional schemas to separate tables by department.
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   Your team needs to store raw sensor logs as files for a data pipeline. The files will be processed by Spark jobs and then deleted after processing. What should you create to store these files in Unity Catalog?

   • ACreate a view that reads the log files.
   • BCreate a volume and use it to store the sensor log files.
   • CCreate an external table pointing to the log files.
   • DCreate a table with a string column for each log line.
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   What is the primary difference between a view and a materialized view in Unity Catalog?

   • AA view is stored in a schema, while a materialized view is stored in a catalog.
   • BA view stores the query results physically, while a materialized view runs the query each time it is accessed.
   • CA view can be created only on tables, while a materialized view can be created on tables and views.
   • DA view runs the query each time it is accessed, while a materialized view stores the query results and refreshes them periodically.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   What is required to create a foreign catalog in Unity Catalog?

   • AA dedicated cluster for querying the external data.
   • BA materialized view that caches the external data.
   • CA volume that stores the external data files.
   • DA connection to an external data source, such as a PostgreSQL database or a cloud storage service.
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A business analyst needs to query a pre-aggregated sales summary that is updated hourly. The underlying sales table is large and the aggregation is expensive. What should you create to provide the analyst with fast, fresh data?

   • AA materialized view that refreshes hourly.
   • BAn external table pointing to the sales table.
   • CA regular view that performs the aggregation on each query.
   • DA table that is manually updated by a notebook.
   Reveal Solution Discussion Select an answer first