Explanation
The answer is, Use dynamic view functions.
Here is an example that limits access to rows based on the user being part managers group, in the below view if a user is not a part of the manager's group you can only see rows where the total amount is <= 1000000 Dynamic view function to filter rows
1.CREATE VIEW sales_redacted AS
2.SELECT user_id, country, product, total
3.FROM sales_raw
4.WHERE CASE WHEN is_member('managers') THEN TRUE ELSE total <= 1000000 END; Dynamic view function to hide a column data based on user's access,
1.CREATE VIEW sales_redacted AS
2.SELECT user_id,
3. CASE WHEN is_member('auditors') THEN email ELSE 'REDACTED' END AS email,
4. country,
5. product,
6. total
7.FROM sales_raw
Please review below for more details
https://docs.microsoft.com/en-us/azure/databricks/security/access-control/table-acls/object-privileges#dynamic-v

Explanation
The answer is,
1.CREATE TABLE users_jdbc
2.USING org.apache.spark.sql.jdbc
3.OPTIONS (
4. url = "jdbc:sqlite:/sqmple_db",
5. dbtable = "users"
6.)
Databricks runtime currently supports connecting to a few flavors of SQL Database including SQL Server, My SQL, SQL Lite and Snowflake using JDBC.
1.CREATE TABLE <jdbcTable>
2.USING org.apache.spark.sql.jdbc or JDBC
3.OPTIONS (
4. url = "jdbc:<databaseServerType>://<jdbcHostname>:<jdbcPort>",
5. dbtable " = <jdbcDatabase>.atable",
6. user = "<jdbcUsername>",
7. password = "<jdbcPassword>"
8.)
For more detailed documentation
SQL databases using JDBC - Azure Databricks | Microsoft Docs

Explanation
The answer is, copy of raw data, easy to query and ingest data for downstream processes, Medallion Architecture - Databricks Here are the typical role of Bronze Layer in a medallion architecture.
Bronze Layer:
1. Raw copy of ingested data
2. Replaces traditional data lake
3. Provides efficient storage and querying of full, unprocessed history of data
4. No schema is applied at this layer
Exam focus: Please review the below image and understand the role of each layer(bronze, silver, gold) in medallion architecture, you will see varying questions targeting each layer and its purpose.
Sorry I had to add the watermark some people in Udemy are copying my content.

Explanation
Here is an example of how it looks
Graphical user interface, text, application, email Description automatically generated