先試後買

A. Execute a DROP statement in an SQL console connected to the HDI container.

B. Build the folder that contained the deleted design-time file.

C. Build the project that contained the deleted design-time file.

D. Execute the refactor function for the calculation view.

A. Hint

B. Where

C. Set

D. Placeholder

A. Create a restricted column for each country.

B. Create a filter expression that uses an OR operator.

C. Implement a union node and map each year as a separate column.

D. Create 3 calculated columns.

A. Push-down of queries to remote data sources

B. Exposure of real-time data from remote tables

C. Replication of remote data

D. Cleansing and harmonization of data from disparate sources

A. To prevent passing columns in stacked calculation views

B. To remove a column that is also used as a Label column

C. To ensure specific columns are NOT exposed to the reporting tool

D. To avoid exposing sensitive columns when defining calculated columns

A. To avoid duplicate rows in the output

B. To force filters to apply at the lowest node

C. To hide columns that are not required

D. To ensure semantic correctness

A. Control the flow logic using IF-THEN-ELSE conditions.

B. Choose declarative language instead of imperative language.

C. Break up large statements by using variables.

D. Use dynamic SQL.

A. To ensure that the aggregation always happens after the join execution

B. To ensure that the join execution only uses the join columns requested in the query

C. To force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query

D. To allow data analysis at different levels of granularity with the same calculation view

A. Provide reusable hierarchies for drilldown in a CUBE with star join

B. Enable SQL SELECT statements to access hierarchies

C. Provide reusable hierarchies for drilldown in a CUBE without star join

D. Access hierarchies created in external schemas