- All Exams Instant Download
Which of the following describes why the statement might not have copied any new records into the table?
A data engineer runs a statement every day to copy the previous day’s sales into the table transactions. Each day’s sales are in their own file in the location "/transactions/raw". Today, the data engineer runs the following command to complete this task: After running the command today, the data engineer...
Which of the following lines of code fills in the above blank to successfully complete the task?
A data engineer wants to create a new table containing the names of customers that live in France. They have written the following command: A senior data engineer mentions that it is organization policy to include a table property indicating that the new table includes personally identifiable information (PII). Which...
Which of the following is hosted completely in the control plane of the classic Databricks architecture?
Which of the following is hosted completely in the control plane of the classic Databricks architecture?A . Worker nodeB . JDBC data sourceC . Databricks web applicationD . Databricks FilesystemE . Driver nodeView AnswerAnswer: C Explanation: In the classic Databricks architecture, the control plane includes components like the Databricks web...
Which of the following code blocks creates this SQL UDF?
A data engineer needs to apply custom logic to string column city in table stores for a specific use case. In order to apply this custom logic at scale, the data engineer wants to create a SQL user-defined function (UDF). Which of the following code blocks creates this SQL UDF?...
Which of the following describes how a data lakehouse could alleviate this issue?
A data organization leader is upset about the data analysis team’s reports being different from the data engineering team’s reports. The leader believes the siloed nature of their organization’s data engineering and data analysis architectures is to blame. Which of the following describes how a data lakehouse could alleviate this...
Which of the following commands could the data engineering team use to access sales in PySpark?
A data analyst has created a Delta table sales that is used by the entire data analysis team. They want help from the data engineering team to implement a series of tests to ensure the data is clean. However, the data engineering team uses Python for its tests rather than...
Which of the following describes a scenario in which a data team will want to utilize cluster pools?
Which of the following describes a scenario in which a data team will want to utilize cluster pools?A . An automated report needs to be refreshed as quickly as possible.B . An automated report needs to be made reproducible.C . An automated report needs to be tested to identify errors.D...
Which of the following code blocks will remove the rows where the value in column age is greater than 25 from the existing Delta table my_table and save the updated table?
Which of the following code blocks will remove the rows where the value in column age is greater than 25 from the existing Delta table my_table and save the updated table?A . SELECT * FROM my_table WHERE age > 25;B . UPDATE my_table WHERE age > 25;C . DELETE FROM...
Which of the following commands will return the location of database customer360?
Which of the following commands will return the location of database customer360?A . DESCRIBE LOCATION customer360;B . DROP DATABASE customer360;C . DESCRIBE DATABASE customer360;D . ALTER DATABASE customer360 SET DBPROPERTIES ('location' = '/user'};E . USE DATABASE customer360;View AnswerAnswer: C Explanation: To retrieve the location of a database named "customer360" in...
Which of the following benefits is provided by the array functions from Spark SQL?
Which of the following benefits is provided by the array functions from Spark SQL?A . An ability to work with data in a variety of types at onceB . An ability to work with data within certain partitions and windowsC . An ability to work with time-related data in specified...
