Oracle Exam 1Z0-1041-23 Topic 7 Question 24 Discussion

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

Question #: 24
Topic #: 7

You need to curate data for Country Dimension and dependent Sales Facts that store country sales data.

How do you design the data flow and load data for these two separate data sets in data storage?

ACreate a single data flow that loads data to the Country data storage in the first step and then loaders data storage in the seconds the flows for the Country and Sales data sets.

BCreate two separate data flows for the Country and Sales data sets. Then call one data flow from another.

CCreate two separate data flows for the Country and Sales data sets. Then create a sequence 'low for Country is called first followed by the data flow for Sales.

DCreate data flows for the Country and Sales data sets. Then create a sequence where the data flow for Sales is called first followed by the data flow for Country.

Show Suggested Answer

Suggested Answer: C

Based on the image of the chart, the aggregate function SUM (Revenue) will calculate the sum of revenue for each product category. The chart shows that Product A has two rows with revenue values of 500 and 500, so the sum is 1000. Product B has two rows with revenue values of 1000 and 1000, so the sum is 2000. Reference: Oracle Analytics Cloud - Data Visualization User's Guide

by Carma at Jul 05, 2024, 06:41 AM

Limited Time Offer

25%

Off

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