- All Exams Instant Download
If you create a database sample_db with the statement CREATE DATABASE sample_db what will be the default location of the database in DBFS?
If you create a database sample_db with the statement CREATE DATABASE sample_db what will be the default location of the database in DBFS?A . Default location, DBFS:/user/B . Default location, /user/db/C . Default Storage accountD . Statement fails “Unable to create database without location”E . Default Location, dbfs:/user/hive/warehouseView AnswerAnswer: E...
Which of the following locations in the Databricks product architecture hosts the notebooks and jobs?
Which of the following locations in the Databricks product architecture hosts the notebooks and jobs?A . Data planeB . Control planeC . Databricks FilesystemD . JDBC data sourceE . Databricks web applicationView AnswerAnswer: B Explanation: The answer is Control Pane, Databricks operates most of its services out of a control...
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...
You are working on a table called orders which contains data for 2021 and you have the second table called orders_archive which contains data for 2020, you need to combine the data from two tables and there could be a possibility of the same rows between both the tables, you are looking to combine the results from both the tables and eliminate the duplicate rows, which of the following SQL statements helps you accomplish this?
You are working on a table called orders which contains data for 2021 and you have the second table called orders_archive which contains data for 2020, you need to combine the data from two tables and there could be a possibility of the same rows between both the tables, you...
as total_sales from sales
as total_sales from salesView AnswerAnswer: C Explanation: The answer is
You are currently working with the second team and both teams are looking to modify the same notebook, you noticed that the second member is copying the notebooks to the personal folder to edit and replace the collaboration notebook, which notebook feature do you recommend to make the process easier to collaborate.
You are currently working with the second team and both teams are looking to modify the same notebook, you noticed that the second member is copying the notebooks to the personal folder to edit and replace the collaboration notebook, which notebook feature do you recommend to make the process easier...
Which of the following scenarios is the best fit for AUTO LOADER?
Which of the following scenarios is the best fit for AUTO LOADER?A . Efficiently process new data incrementally from cloud object storageB . Efficiently move data incrementally from one delta table to another delta tableC . Incrementally process new data from streaming data sources like Kafka into delta lakeD ....
Which of the following SQL statements can be used to update a transactions table, to set a flag on the table from Y to N
Which of the following SQL statements can be used to update a transactions table, to set a flag on the table from Y to NA . MODIFY transactions SET active_flag = 'N' WHERE active_flag = 'Y'B . MERGE transactions SET active_flag = 'N' WHERE active_flag = 'Y'C . UPDATE transactions...
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:...
If you create a database sample_db with the statement CREATE DATABASE sample_db what will be the default location of the database in DBFS?
If you create a database sample_db with the statement CREATE DATABASE sample_db what will be the default location of the database in DBFS?A . Default location, DBFS:/user/B . Default location, /user/db/C . Default Storage accountD . Statement fails “Unable to create database without location”E . Default Location, dbfs:/user/hive/warehouseView AnswerAnswer: E...
