Dell-EMC
E20-495 · Question #109
The following query creates a custom aggregation object for BAM: create bam_custom_aggr object set object_name ='AggrCustomHH', set table_script = 'CREATE TABLE CALLS_BY_REGION( LOCATION…
The correct answer is B. a query that populates the CALLS_BY_REGION table. See the full explanation below for the reasoning.
Question
The following query creates a custom aggregation object for BAM:
create bam_custom_aggr object set object_name ='AggrCustomHH', set table_script = 'CREATE TABLE CALLS_BY_REGION( LOCATION VARCHAR2(256), START_JAVATIME NUMBER, START_DATETIME TIMESTAMP, END_DATETIME TIMESTAMP, ORDER_COUNT NUMBER(38))', setfile 'c:\data.txt' with content_format='text'go What does the data.txt file contain?
Options
- Aa list of aggregation jobs to be run by the BAM server
- Ba query that populates the CALLS_BY_REGION table
- Ca query that creates the CALLS_BY_REGION table
- Da list of valid time intervals for the custom aggregation object
How the community answered
(24 responses)- A4% (1)
- B71% (17)
- C17% (4)
- D8% (2)
Community Discussion
No community discussion yet for this question.