AWS Exams GCP Exams Azure Exams GitHub Exams Jira Exams ISC2 Exams

Video: A team of data engineers started a project databricks video

Question 1
« Back   Next databricks data-engineer-professional Question »

Full Certification Question

A team of data engineers started a project seven years ago. Two tables were created with the following SQL statements: CREATE TABLE flights ( flight_number STRING , source STRING , destination STRING ) using DELTA ; CREATE TABLE airports ( airport_id STRING , city STRING , country STRING ) USING PARQUET LOCATION 'dbfs:/airports/data/' ; The DBFS location dbfs:/airports/data/ contains static data for the airports while the data in the flights table is updated on a daily basis. After the creation of the tables, the definition of the tables was not altered. A junior data engineer joins the team and runs the following SQL statements. DROP TABLE flights ; DROP TABLE airports ; Which of the following statements is true about the data present in the tables? Assume that the UNDROP command, recently launched by Databricks, cannot be used.