While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?
A.
Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.
B.
Autonomous Data Warehouse workloads are optimized for mixed workloads.
C.
Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.
D.
Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.
Explanation:
ADW designed for parallel joins and aggregations
ATP designed for Mixed workloads
ADW optimized for data-warehouse, data lake and data mart
Data format for ATP row-wise and for ADW columnar
I agree with D.
D. Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.
ADW designed for parallel joins and aggregations
ATP designed for Mixed workloads
ADW optimized for data-warehouse, data lake and data mart
Data format for ATP row-wise and for ADW columnar
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
tell2ami
Highly Voted 4 years, 7 months agotell2ami
Highly Voted 4 years, 7 months agoadz07
Most Recent 4 months, 3 weeks agotopi
2 years, 11 months agoluizyto
3 years, 1 month agosantyrathod
4 years, 4 months agocgm_e
4 years, 5 months agoedlayop
4 years, 5 months agosebas880316
4 years, 5 months agobullu
4 years, 5 months agoHilalahmed
4 years, 6 months agoScunningham99
4 years, 7 months agoakt007tx
4 years, 7 months ago