Oracle Exam 1Z0-915-1 Topic 3 Question 11 Discussion

Actual exam question for Oracle's 1Z0-915-1 exam

Question #: 11
Topic #: 3

Which table option defines a Lakehouse external table based on a CSV file?

AENGINE=csv SECONDARY_ENGINE=rapid ENGINE_ATTRIBUTE='{''file'': [{''region'': ''us-ashburn-1'', ''namespace'': ''mytenant'', ''bucket'': ''bucket01'', ''name'': ''airport.csv''}] }'

BENGINE=csv SECONDARY_ENGINE=lakehouse ENGINE_ATTRIBUTE='{''file'': [{''region'': ''us-ashburn-1'', ''namespace'': ''mytenant'', ''bucket'': ''bucket01'', ''name'': ''airport.csv''}] }'

CENGINE=lakehouse SECONDARY_ENGINE=csv ENGINE_ATTRIBUTE='{''file'': [{''region'': ''us-ashburn-1'', ''namespace'': ''mytenant'', ''bucket'': ''bucket01'', ''name'': ''airport.csv''}] }'

DENGINE=lakehouse SECONDARY_ENGINE=rapid ENGINE_ATTRIBUTE='{''file'': [{''region'': ''us-ashburn-1'', ''namespace'': ''mytenant'', ''bucket'': ''bucket01'', ''name'': ''airport.csv''}] }'

Show Suggested Answer

Suggested Answer: C

by Malcom at Sep 19, 2024, 02:27 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-915-1 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Rusty

8 months ago

Wow, these options are really putting my data engineering skills to the test! But I'm confident that Option B is the way to go. Lakehouse all the way!

upvoted 0 times

Crissy

7 months ago

User 3: Definitely, Option B is the way to go for handling data in a Lakehouse environment.

upvoted 0 times

...

Marcos

7 months ago

User 2: I agree, the combination of ENGINE=csv and SECONDARY_ENGINE=lakehouse seems like the right fit.

upvoted 0 times

...

Vincenza

8 months ago

User 1: I think Option B is the best choice for defining a Lakehouse external table based on a CSV file.

upvoted 0 times

...

Nickolas

9 months ago

I'm not sure, but I think the rationale behind B) is that it specifies the correct engines for a Lakehouse external table.

upvoted 0 times

...

Margurite

9 months ago

I agree with Raymon, because we need to define a Lakehouse external table based on a CSV file.

upvoted 0 times

...

Lindsey

9 months ago

Haha, Option D sounds like it's trying to be the 'cool kid' of the bunch, but I don't think that's what the question is asking for. Gotta stick with good ol' Option B.

upvoted 0 times

Delisa

7 months ago

Let's go with Option B then, it seems like the most logical option.

upvoted 0 times

...

Elin

8 months ago

I think Option B is the safest bet for defining a Lakehouse external table based on a CSV file.

upvoted 0 times

...

Karan

8 months ago

Yeah, Option D does seem a bit out there.

upvoted 0 times

...

Graham

8 months ago

I agree, Option B seems like the most appropriate choice.

upvoted 0 times

...

Jeff

9 months ago

Hmm, this is a tricky one. I'm torn between Options B and C, but I think I'm going to have to go with B. The 'lakehouse' engine just seems more relevant to the question.

upvoted 0 times

Cherry

8 months ago

I'm going with Option B as well. The 'lakehouse' engine does seem more fitting.

upvoted 0 times

...

Leila

8 months ago

I think Option C might be the better option, but I see why you chose B.

upvoted 0 times

...

Reid

9 months ago

I agree, Option B seems like the right choice here.

upvoted 0 times

...

Bo

9 months ago

I'm going to go with Option B as well. It seems the most straightforward and explicitly mentions the 'lakehouse' engine, which is what the question is looking for.

upvoted 0 times

...

Elinore

9 months ago

Option B looks like the correct choice here. The question asks for a Lakehouse external table, and Option B specifically mentions the 'lakehouse' engine.

upvoted 0 times

Eric

9 months ago

Yes, Option B clearly mentions the 'lakehouse' engine, which aligns with the requirements of the question.

upvoted 0 times

...

Katina

9 months ago

I agree, Option B seems to be the most suitable for defining a Lakehouse external table based on a CSV file.

upvoted 0 times

...

Raymon

10 months ago

I think the answer is B) ENGINE=csv SECONDARY_ENGINE=lakehouse.

upvoted 0 times

...