Free Preparation Discussions
MENU
Databricks Exam Databricks Certified Data Engineer Associate Topic 2 Question 46 Discussion
Topic #: 2
A data engineer has developed a data pipeline to ingest data from a JSON source using Auto Loader, but the engineer has not provided any type inference or schema hints in their pipeline. Upon reviewing the data, the data engineer has noticed that all of the columns in the target table are of the string type despite some of the fields only including float or boolean values.
Which of the following describes why Auto Loader inferred all of the columns to be of the string type?
To grant full privileges on a table such as 'sales' to a group like 'team', the correct SQL command in Databricks is:
GRANT ALL PRIVILEGES ON TABLE sales TO team;
This command assigns all available privileges, including SELECT, INSERT, UPDATE, DELETE, and any other data manipulation or definition actions, to the specified team. This is typically necessary when a team needs full control over a table to manage and manipulate it as part of a project or ongoing maintenance.
Reference: Databricks documentation on SQL permissions: SQL Permissions in Databricks
Lourdes
3 months agoMayra
2 months agoLaurel
2 months agoGilma
2 months agoLauna
2 months agoErick
3 months agoDominga
2 months agoSelma
2 months agoRasheeda
3 months agoDannette
3 months agoRasheeda
3 months ago