- All Exams Instant Download
Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?
Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?A . MERGE INTO table_name B. COPY INTO table_name C. UPDATE table_name D. INSERT INTO OVERWRITE table_name E. INSERT IF EXISTS table_nameView AnswerAnswer: A Explanation:...
You noticed that colleague is manually copying the notebook with _bkp to store the previous versions, which of the following feature would you recommend instead.
You noticed that colleague is manually copying the notebook with _bkp to store the previous versions, which of the following feature would you recommend instead.A . Databricks notebooks support change tracking and versioning B. Databricks notebooks should be copied to a local machine and setup source control locally to version...
table("uncleanedSales")
table("uncleanedSales")View AnswerAnswer: B Explanation: The answer is
What is the purpose of a gold layer in Multi-hop architecture?
What is the purpose of a gold layer in Multi-hop architecture?A . Optimizes ETL throughput and analytic query performance B. Eliminate duplicate records C. Preserves grain of original data, without any aggregations D. Data quality checks and schema enforcement E. Powers ML applications, reporting, dashboards and adhoc reports.View AnswerAnswer: E...
Which of the following commands can be used to run one notebook from another notebook?
Which of the following commands can be used to run one notebook from another notebook?A . notebook.utils.run("full notebook path") B. execute.utils.run("full notebook path") C. dbutils.notebook.run("full notebook path") D. only job clusters can run notebook E. spark.notebook.run("full notebook path")View AnswerAnswer: C Explanation: The answer is dbutils.notebook.run(" full notebook path ") Here...
ELSE (temp C 33 ) * 5/9 5.END
ELSE (temp C 33 ) * 5/9 5.ENDView AnswerAnswer: D Explanation: The answer is
table("uncleanedSales")
table("uncleanedSales")View AnswerAnswer: B Explanation: The answer is
What is the purpose of the silver layer in a Multi hop architecture?
What is the purpose of the silver layer in a Multi hop architecture?A . Replaces a traditional data lake B. Efficient storage and querying of full, unprocessed history of data C. Eliminates duplicate data, quarantines bad data D. Refined views with aggregated data E. Optimized query performance for business-critical dataView...
How VACCUM and OPTIMIZE commands can be used to manage the DELTA lake?
How VACCUM and OPTIMIZE commands can be used to manage the DELTA lake?A . VACCUM command can be used to compact small parquet files, and the OP-TIMZE command can be used to delete parquet files that are marked for dele-tion/unused. B. VACCUM command can be used to delete empty/blank parquet...
