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.