-1

If I were to ask the question What is a Delta table in a directory? Which of the following would be the correct answer

a) It is a directory containing data files

b) It is a single file containing the data

c) It is a subdirectory that is named based on partition values

d) It is a JSON file containing a snapshot of the table

I was asked this question as part of a mock exam. I'm interested to know what you think the answer is.

I thought the answer was It is a single file containing the data

Thanks

Pratik Lad
  • 4,343
  • 2
  • 3
  • 11
Patterson
  • 1,927
  • 1
  • 19
  • 56
  • A Delta table is actually a directory that contains data files, metadata, and other artifacts related to the table. – Pratik Lad Apr 06 '23 at 10:23
  • Hi @PratikLad, thanks for getting in touch, there the correct answer would be Answer: c) It is a subdirectory that is named based on partition values. Correct? – Patterson Apr 06 '23 at 11:35
  • no, it's not answer – Alex Ott Apr 06 '23 at 12:30
  • Hi Alex, thanks for reaching out. What would you is the correct answer? – Patterson Apr 06 '23 at 16:16
  • I meant to say what would you say is the correct answer ? – Patterson Apr 06 '23 at 16:29
  • Hi Alex, on second I think the answer C is correct. If you re-read the question it states What is a Delta table in a directory? – Patterson Apr 06 '23 at 17:12
  • 1
    Weird question if you've posted it exactly. Option A should be the answer if we're not word-playing. See [this](https://miro.medium.com/v2/resize:fit:1400/format:webp/1*L1yM-xDaIUNMSIoanVr8BA.png) – o_O Apr 07 '23 at 13:14
  • Hi, o, thanks for reaching out. I admit the question does come across a word play, however, if you take a look at your image you will see that the delta table _delta_log is indeed a subdirectory of root diectory my_table. – Patterson Apr 07 '23 at 17:14
  • I’m voting to close this question because: This is exam prep. They need to RTM. – Kashyap Apr 13 '23 at 14:29

1 Answers1

1

A table is usually stored in multiple files(partitions) and along with it are stored the historic tables and the log files, hence A would be the answer.

Pallav Garg
  • 46
  • 3