Oracle Exam 1Z0-1094-23 Topic 1 Question 6 Discussion

Actual exam question for Oracle's 1Z0-1094-23 exam

Question #: 6
Topic #: 1

Which are TWO benefits of Extract-Load-Transform (ELT) over traditional Extract-Transform-Load (ETL) architectures? (Choose all correct answers)

AELT architecture reduces the amount of network traffic over traditional ETL tools, which use a dedicated server.

BELT architecture can easily become a bottleneck by placing excessive loads on the target servers.

CELT architecture does not require dedicated hardware and leverages native data management engines, such as Big Data and RDBMs.

DTraditional ETL tools use a dedicated server, which provides better performance as it can be sized to any workload.

Show Suggested Answer

Suggested Answer: A, C

ELT (Extract, Load, Transform) offers benefits over traditional ETL (Extract, Transform, Load) by reducing network traffic and eliminating the need for dedicated transformation servers. In ELT, data transformation occurs within the target database leveraging its native processing capabilities, which can lead to more efficient use of resources and better performance, especially with large data volumes and complex transformations.

by Evangelina at Feb 09, 2024, 08:21 AM

Limited Time Offer

25%

7 months ago

I think one benefit of ELT over ETL is that it reduces network traffic.

upvoted 0 times

...