Questions and Answers
Question uLTOOBrAK7dQp66XuHUr
Question
A data engineer needs to create a table in Databricks using data from a CSV file at location /path/to/csv.
They run the following command:
//IMG//
Which of the following lines of code fills in the above blank to successfully complete the task?
Choices
- A: FROM “path/to/csv”
- B: USING CSV
- C: FROM CSV
- D: USING DELTA
answer?
Answer: B Answer_ET: B Community answer B (100%) Discussion
Comment 1282702 by CommanderBigMac
- Upvotes: 2
Selected Answer: B B: using csv is correct
Question vumIc5QsMCd9UIUTOlLR
Question
What is a benefit of creating an external table from Parquet rather than CSV when using a CREATE TABLE AS SELECT statement?
Choices
- A: Parquet files can be partitioned
- B: Parquet files will become Delta tables
- C: Parquet files have a well-defined schema
- D: Parquet files have the ability to be optimized
answer?
Answer: C Answer_ET: C Community answer C (100%) Discussion
Comment 1300976 by RandomForest
- Upvotes: 1
Selected Answer: C Parquet supports rich data types and enforces a schema, making it more suitable for structured data. CSV lacks schema enforcement and treats everything as plain text, which can lead to data parsing issues.
Comment 1218501 by MDWPartners
- Upvotes: 1
Selected Answer: C Parquetare columnar and can be optimized. However, I think the key part is ” when using a CREATE TABLE AS SELECT statement?”, that’s C
Comment 1211366 by mgari
- Upvotes: 1
D partquet file are columnar and otimised
Question YnGpOY5zOYpCaLyk23o4
Question
A data engineer has left the organization. The data team needs to transfer ownership of the data engineer’s Delta tables to a new data engineer. The new data engineer is the lead engineer on the data team. Assuming the original data engineer no longer has access, which of the following individuals must be the one to transfer ownership of the Delta tables in Data Explorer?
Choices
- A: Databricks account representative
- B: This transfer is not possible
- C: Workspace administrator
- D: New lead data engineer
- E: Original data engineer
answer?
Answer: C Answer_ET: C Community answer C (100%) Discussion
Comment 1269228 by marioscarasciaagile
- Upvotes: 1
Selected Answer: C C. Workspace administrator
Comment 1262394 by 80370eb
- Upvotes: 1
Selected Answer: C C. Workspace administrator
Comment 1252364 by souldiv
- Upvotes: 1
Workspace admin
Comment 1249377 by ranjan24
- Upvotes: 2
Question is to give access to new data engineer, How will he/she have it ? correct answer is C - Workspace admin
Comment 1244538 by 3fbc31b
- Upvotes: 1
Selected Answer: C The new data engineer would be unable to make this change. It’s up to the WSA.
Comment 1214380 by carlosmps
- Upvotes: 1
Option c
Comment 1198199 by Svengance
- Upvotes: 2
Selected Answer: C workspace admin
Comment 1189112 by benni_ale
- Upvotes: 1
Selected Answer: C workspace admin
Comment 1177188 by Itmma
- Upvotes: 1
Selected Answer: C C is correct
Comment 1113191 by SerGrey
- Upvotes: 1
Selected Answer: C Correct answer is C
Comment 1109087 by Garyn
- Upvotes: 4
Selected Answer: C The ownership of Delta tables in Data Explorer can be transferred by the current owner, a metastore admin, or the owner of the container1. In this case, since the original data engineer no longer has access, the Workspace Administrator (Option C) would be the most appropriate individual to transfer the ownership of the Delta tables to the new data engineer. This is because the Workspace Administrator typically has the necessary permissions to manage such resources2. Please note that the exact process may vary depending on the specific configurations and permissions set up in your workspace. It’s always a good idea to consult with your organization’s IT or data governance team to ensure the correct procedures are followed.
Comment 1071076 by Huroye
- Upvotes: 2
The answer is C - the workspace admin. How can it be the new DE? You do not even know if the new DE has access. That was not stated and so you cannot consider it.
Comment 1028774 by VijayKula
- Upvotes: 1
Selected Answer: C Workspace Administrator
Comment 1017349 by KalavathiP
- Upvotes: 1
Selected Answer: C C is correct
Comment 1016559 by d_b47
- Upvotes: 1
Selected Answer: C It should be “workspace administrator”
Comment 937865 by Niteesh
- Upvotes: 1
Selected Answer: C It should be “workspace administrator”
Comment 927270 by abdullahmyahya
- Upvotes: 1
Selected Answer: C It’s C
Comment 921427 by ThomasReps
- Upvotes: 1
Selected Answer: C It’s C.
Comment 893314 by Bob123456
- Upvotes: 1
why can’t it be a ‘Workspace administrator’ instead of option ‘D’
Comment 889064 by Majjjj
- Upvotes: 2
Selected Answer: C The Workspace administrator must be the one to transfer ownership of the Delta tables in Data Explorer in this scenario.
Comment 876203 by Varma_Saraswathula
- Upvotes: 3
Option C - https://docs.databricks.com/sql/admin/transfer-ownership.html
Comment 875856 by naxacod574
- Upvotes: 1
Option C
Comment 860625 by sdas1
- Upvotes: 2
Option C
Comment 860401 by knivesz
- Upvotes: 1
Selected Answer: C La respuesta es la C
Comment 857984 by XiltroX
- Upvotes: 2
Selected Answer: C Wrong answer. The correct answer should be C https://www.databricks.com/blog/2022/08/26/databricks-workspace-administration-best-practices-for-account-workspace-and-metastore-admins.html
Question atJgDxkeOF0ABAgxTScG
Question
Which SQL keyword can be used to convert a table from a long format to a wide format?
Choices
- A: TRANSFORM
- B: PIVOT
- C: SUM
- D: CONVERT
answer?
Answer: B Answer_ET: B Discussion
Comment 1273030 by 9d4d68a
- Upvotes: 2
Answer is (B. PIVOT) The PIVOT keyword is used to transform rows into columns, converting data from a long format (where each row represents a single measurement) to a wide format (where multiple measurements are represented as columns). For example, if you have a table of sales data with columns for Date, Product, and Sales, you can use PIVOT to create a table where each Product has its own column, and sales are aggregated by Date.
Question D85qbVRf7ccjQB0Qr43C
Question
A data engineer has a Python variable table_name that they would like to use in a SQL query. They want to construct a Python code block that will run the query using table_name.
They have the following incomplete code block:
____(f”SELECT customer_id, spend FROM {table_name}”)
What can be used to fill in the blank to successfully complete the task?
Choices
- A: spark.delta.sql
- B: spark.sql
- C: spark.table
- D: dbutils.sql
answer?
Answer: B Answer_ET: B Community answer B (100%) Discussion
Comment 1286853 by Stefan94
- Upvotes: 2
Selected Answer: B B is correct