Prepstellar

DP-750 · Practice set 9 of 11

Unity Catalog Naming Conventions: 10 practice questions

10 questions · Untimed · Free

10 free DP-750 practice questions on Unity Catalog Naming Conventions, with an explanation for every answer. Untimed. The full mock exam and the timed version are in the app.

Set 9 · Unity Catalog Naming Conventions · 10 questions Read the lesson
  1. Question 1 of 10

    Which primary identifier style is recommended for readable Unity Catalog object names?

    1. AUppercase words separated by forward slashes
    2. BPascalCase words separated by periods
    3. CLowercase words separated by underscores
    4. DNames containing spaces without backticks
    Show the answer

    Lowercase with underscores is readable and aligns with Unity Catalog storage behavior; periods, slashes, and spaces are prohibited in object names.

    Next → 1 / 10
  2. Question 2 of 10

    Which catalog naming pattern represents both business domain and lifecycle environment?

    1. Asales/prod
    2. Bsales_prod
    3. Csales.prod
    4. DSales Prod
    Show the answer

    The `{domain}_{environment}` pattern preserves both dimensions with a valid underscore separator; the distractors use prohibited period, slash, or space characters.

    Next → 2 / 10
  3. Question 3 of 10

    Which name most clearly signals that a catalog is intended for an external audience?

    1. Asales_final_report_v1_updated
    2. Binternal_sales_raw_data
    3. Ccustomer_analytics_shared
    4. Dtmp_import_staging
    Show the answer

    The `_shared` name communicates both the catalog's business purpose and external-sharing intent without exposing internal structure.

    Next → 3 / 10
  4. Question 4 of 10

    How does Unity Catalog handle the object names `SalesData` and `salesdata`?

    1. AIt converts each uppercase letter into an underscore
    2. BIt preserves both forms as separate case-sensitive objects
    3. CIt stores them in lowercase and resolves them as the same object name
    4. DIt rejects the lowercase form but accepts the PascalCase form
    Show the answer

    Unity Catalog stores object names in lowercase and matches them case-insensitively, so letter case cannot distinguish two objects.

    Next → 4 / 10
  5. Question 5 of 10

    Which structure provides the strongest named boundary between development and production data?

    1. AOne catalog with table names ending in `_dev` and `_prod`
    2. BOne shared catalog whose comments identify the environment
    3. CSeparate `sales_dev` and `sales_prod` catalogs
    4. DOne schema with mixed development and production objects
    Show the answer

    Separate catalogs place the lifecycle boundary at Unity Catalog's highest isolation level and support catalog-level permissions; suffixes or comments alone do not provide that boundary.

    Next → 5 / 10
  6. Keep the ones you got wrong

    In the app, every question you miss comes back exactly when you’re about to forget it.

  7. Question 6 of 10

    What do bronze, silver, and gold schema names communicate in a medallion pattern?

    1. ADevelopment, testing, and production workspaces
    2. BPublic, internal, and externally shared access levels
    3. CRaw, cleaned and validated, and aggregated business-level data
    4. DCPU, memory, and storage optimization tiers
    Show the answer

    Medallion layer names describe data-processing maturity inside an environment; environment and sharing boundaries require separate naming and permission decisions.

    Next → 6 / 10
  8. Question 7 of 10

    Which enforcement mechanism catches invalid names before automated deployment creates objects?

    1. AChanging every identifier to PascalCase
    2. BAdding version history to each object name
    3. CGranting SELECT on all catalogs
    4. DNaming validation in the CI/CD pipeline
    Show the answer

    Deployment validation can reject identifiers that violate the documented standard before creation; unrelated access grants and decorative naming do not validate conformance.

    Next → 7 / 10
  9. Question 8 of 10

    A company has sales and finance domains in development and production. It needs catalog-level permissions for each domain-environment pair and names that expose both dimensions. Which pattern best fits?

    1. A`sales_dev`, `sales_prod`, `finance_dev`, and `finance_prod`
    2. B`sales.finance` and `dev.prod` as paired catalog names
    3. C`dev`, `prod`, `sales`, and `finance` as four unrelated catalogs
    4. DOne `company_data` catalog with all four groups of objects
    Show the answer

    The combined domain-environment pattern creates an explicit catalog boundary for every required pair and enables permissions at exactly that level.

    Next → 8 / 10
  10. Question 9 of 10

    An external partner will browse a shared analytics catalog. The name must reveal its purpose and sharing status but must not expose the internal department code `d47`. Which choice is best?

    1. A`d47_customer_analytics_external`
    2. B`Customer Analytics Shared`
    3. C`internal_customer_raw_data`
    4. D`customer_analytics_shared`
    Show the answer

    The selected name is valid, business-readable, and explicit about sharing without leaking the internal code; actual access remains controlled by permissions.

    Next → 9 / 10
  11. Question 10 of 10

    Developers must never modify production data, and auditors want the environment obvious while browsing. Which design satisfies both the communication and enforcement requirements?

    1. AAdd `_prod` to table names but grant developers access to the shared catalog
    2. BUse `Dev` and `DEV` as separate catalogs with different grants
    3. CUse separate `dev` and `prod` catalogs and grant catalog permissions by role
    4. DDocument production objects in comments and keep identical permissions
    Show the answer

    Separate named catalogs make the lifecycle boundary visible, while role-based catalog permissions enforce it; naming alone cannot substitute for authorization.

    Next → 10 / 10
  12. You’ve finished this set

    That’s 10 questions on Unity Catalog Naming Conventions. In the app the ones you miss come back exactly when you’re about to forget them.

The whole course, on your phone

Lessons you can read, audio you can listen to on the way to work, and practice that remembers what you got wrong.