- All Exams Instant Download
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 versioningB . Databricks notebooks should be copied to a local machine and setup source control locally to version...
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 lakeB . Efficient storage and querying of full, unprocessed history of dataC . Eliminates duplicate data, quarantines bad dataD . Refined views with aggregated dataE . Optimized query performance for business-critical dataView...
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_nameB . COPY INTO table_nameC . UPDATE table_nameD . INSERT INTO OVERWRITE table_nameE . INSERT IF EXISTS table_nameView AnswerAnswer: A Explanation:...
You are asked to write a python function that can read data from a delta table and return the Data-Frame, which of the following is correct?
You are asked to write a python function that can read data from a delta table and return the Data-Frame, which of the following is correct?A . Python function cannot return a DataFrameB . Write SQL UDF to return a DataFrameC . Write SQL UDF that can return tabular dataD...
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_nameB . COPY INTO table_nameC . UPDATE table_nameD . INSERT INTO OVERWRITE table_nameE . INSERT IF EXISTS table_nameView AnswerAnswer: A Explanation:...
table("uncleanedSales")
table("uncleanedSales")View AnswerAnswer: B Explanation: The answer is
table(table_name))
table(table_name))A . format, checkpointlocation, schemalocation, overwriteB . cloudfiles.format, checkpointlocation, cloudfiles.schemalocation, overwriteC . cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, mergeSchemaD . cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, overwriteE . cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, appendView AnswerAnswer: C Explanation: The answer is cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, mergeSchema. Here is the end to end syntax of streaming ELT, below link contains complete...
Which of the following approaches can enable the data engineering team to be notified if the ELT job has not been run in an hour?
A data engineer is using a Databricks SQL query to monitor the performance of an ELT job. The ELT job is triggered by a specific number of input records being ready to process. The Databricks SQL query returns the number of minutes since the job’s most recent runtime. Which of...
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 performanceB . Eliminate duplicate recordsC . Preserves grain of original data, without any aggregationsD . Data quality checks and schema enforcementE . Powers ML applications, reporting, dashboards and adhoc reports.View AnswerAnswer: E...
