Databricks Databricks-Certified-Data-Engineer-Associate Dumps Questions Answers

from pyspark.sql import SparkSession

spark = SparkSession.builder.getOrCreate()

df = spark.sql("SELECT * FROM sales")

print(df.count())

https://www.databricks.com/glossary/medallion-architecture

In the context described, creating a "Table" is the most suitable choice. Tables in SQL are data entities that exist independently of any session and are saved in a physical location. They can be accessed and manipulated by other data engineers in different sessions, which aligns with the requirements stated. A "Database" is a collection of tables, views, and other database objects. A "Function" is a stored procedure that performs an operation. A "View" is a virtual table based on the result-set of an SQL statement, but it is not stored physically. A "Temporary view" is a feature that allows you to store the result of a query as a view that disappears once your session with the database is closed.