QV12BA 무료 덤프문제 온라인 액세스

Refer to the exhibits.

Table_1 has been transformed into Table_2. Which action did the business analyst take to transform the table?

• A.In the Presentation tab. checked Show Partial Sums
• B.In the Presentation tab checked Totals on Last Row
• C.In the Presentation tab. checked Subtotals at Top
• D.In the Dimension Limits tab, checked Show Total

A data model contains 1 billion records and a straight table renders all of the data at the most granular level.
The business users do NOT need all of the detailed information. The business analyst needs to improve the rendering time of the straight table.
Which two approaches should the analyst use? (Select two )

• A.Update the straight table to a more summarized view
• B.Remove all master dimensions and master measures, and replace with distinct expressions in each visualization
• C.Specify a specific sort order in the output of the straight table using a field not found in the straight table columns
• D.Replace all table fields with only one field which concatenates the values of all previous table fields
• E.Set up a calculation condition to only show the straight table if filtered down to a much smaller number of rows (e.g., 100k rows)

A data architect needs to develop a dashboard to represent the previous year's sales performance in a simple KPI object Which expression should be used to calculate this value?

• A.Sum({<Year={$(=Max(Year)-I)}>}Sales)
• B.Sum(Aggr(Sum(Sales),Max(Year)-1))
• C.Sum({<Year={Max(Year)-!}>}Sales)
• D.Sum(Aggr<Sum(Sales),Max(Year-l)))

A business analyst needs to sort the values for the Product dimension explicitly as "Planes", then "Trains", then "Automobiles" The analyst needs a highly optimized solution to provide the best performance for an application with between 900 million and 1 billion records Which solution should the analyst use?

• A.Use the Ord function in the user interface to sort in a custom order
• B.Build nested IF statements in the user interface to assign numeric values, then sort numerically
• C.Create a new calculated dimension in the Ul named ProductSort, then sort the Product field by the new ProductSort field
• D.Assign a numeric value to the Product values using the DUAL function during the data load, then sort numerically in the Ul

A business analyst will compare sales growth between this year and last year by country. The analyst is given the sales values and must calculate the growth.
Which two charts can be used? (Select two.)

• A.Gauge chart with country as dimension and sales per year as expression
• B.Table box with country as dimension and sales per year as expression
• C.Pivot table with country and year as dimensions and sales as expression
• D.Bar chart with country and year as dimensions and sales as expression
• E.Funnel chart with country and year as dimensions and sales as expression