Answer: Run SQL command DESCRIBE SCHEMA EXTENDED schema_name

The correct method to find the location of an existing schema in Delta Lake is by running the SQL command `DESCRIBE SCHEMA EXTENDED schema_name`. This command provides detailed information about the schema, including its location, which is either the managed location in the metastore or the external location if specified. The output includes a `Location` property indicating the storage path of the schema. - **Option A (Use Data explorer)**: The Data Explorer focuses on the details of tables within a schema and may not directly show the schema's storage location. - **Option C (Check unity catalog UI)**: While the Unity Catalog UI allows browsing and managing data objects, it primarily displays the location of tables within a schema, not the schema itself. - **Option D (Run SQL command SHOW LOCATION schema_name)**: There is no standard SQL command named `SHOW LOCATION` for schemas in Databricks SQL or Apache Spark SQL. - **Option E (Schemas are internally in-store external hive meta stores like MySQL or SQL Server)**: This is incorrect. The metadata about schemas is stored in the metastore, but the actual data resides in cloud storage, not within the metastore database.

Author: LeetQuiz Editorial Team