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

Questions 21–25

1. 21application · medium

   Your team needs to store unstructured JSON files and image files for a machine learning project. These files will be accessed by notebooks and also used to train models. What should you create in Unity Catalog?

   • ACreate a table with a binary column to store the files.
   • BCreate a volume in the project schema to store the files.
   • CCreate a view that reads the files from cloud storage.
   • DCreate an external table pointing to the files in cloud storage.
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   What is the purpose of configuring AI/BI Genie instructions in Unity Catalog?

   • ATo automatically generate SQL queries for common analytics tasks.
   • BTo provide natural language descriptions and guidance that help users discover and understand data assets.
   • CTo enforce data access policies on tables and views.
   • DTo create materialized views that improve query performance.
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   Your organization wants to enable business users to ask questions about data using natural language in Databricks AI/BI Genie. The data is organized in a catalog with many schemas and tables. What should you configure to help Genie generate accurate responses?

   • ACreate materialized views for all tables.
   • BRename all tables to be shorter.
   • CWrite clear Genie instructions that describe the data model, key tables, and common business terms.
   • DGrant all business users SELECT permission on all tables.
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   A retail company is setting up Unity Catalog for a new analytics platform. They have three teams: sales, marketing, and finance. Each team needs its own schema to organize tables, but all teams should be able to read a shared set of reference tables. The company also requires that any new table created by a team is automatically governed by that team's permissions. What should the data architect do?

   • ACreate one schema per team and put shared tables in the default schema.
   • BCreate three separate catalogs (sales, marketing, finance) and one shared catalog, then grant each team CREATE on their catalog.
   • CCreate a single catalog named retail, create schemas sales, marketing, finance, and shared, and grant each team USAGE on the catalog and CREATE on their own schema.
   • DCreate one catalog named retail, create schemas sales, marketing, finance, and grant all teams CREATE on the catalog.
   Reveal Solution Discussion Select an answer first
6. 25expert · hard

   A data science team needs to access a large set of image files stored in ADLS Gen2. The files are in a directory that also contains CSV metadata files. The team wants to use Unity Catalog to manage access. The security team requires that the data science team can read the images but not the CSV files. What should the administrator do?

   • ACreate a view that filters out the CSV files.
   • BCreate one volume for the parent directory and grant READ VOLUME to the data science team.
   • CCreate an external table for the CSV files and a volume for the images.
   • DCreate two volumes: one for the image directory and one for the CSV directory, and grant READ VOLUME only on the image volume.
   Reveal Solution Discussion Select an answer first