Oracle Cloud Platform Enterprise Analytics 2020 Specialist - 1Z0-1041-20 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Which three options are correct about application workbooks?

A. Worksheets can be modified by using the Cube Designer wizard. B. Application workbooks can have data load worksheets and calculation worksheets. C. Multiple dimensions can be placed on a single worksheet. D. Worksheets cannot be modified directly in Excel. E. Application workbooks support the generation reference dimension build method.

Discussion 0

Correct Answer: A,B,E Vote an answer

Question 2

What is true about setting up Usage tracking?

A. You need to restart after modifying the connection pool. B. You need to set up a connection pool in Oracle Analytics Developer Client Tool. C. It is only available in Enterprise Edition. D. You need to set up a connection pool in Data Modeler. E. It is available in both Essbase and Enterprise Edition.

Discussion 0

Correct Answer: A,B,C Vote an answer

Question 3

Which statement is true when migrating content from Oracle BI Enterprise Edition 12c to Oracle Analytics Cloud?

A. You can only migrate an Oracle BI Enterprise Edition 12c Data Model to Oracle Analytics Cloud.
Catalog migration is not allowed. B. At this time there is no option to migrate Oracle BI Enterprise Edition llg content to Oracle Analytics Cloud. C. Both the Oracle BI Enterprise Edition 12c Data Model and the Catalog must be migrated to Oracle Analytics Cloud. They cannot be migrated independently. D. You can migrate a snapshot from Oracle BI Enterprise Edition 12c to Oracle Analytics Cloud.

Discussion 0

Correct Answer: D Vote an answer

Question 4

You want the Oracle BI Baseline Validation Tool to use specific dashboard prompts when executing a specific dashboard page. In which default file should you specify the values?

A. Prompts.txt B. DashboardPrompts.txt C. Prompts.xml D. DashboardPrompts.xml

Discussion 0

Correct Answer: B Vote an answer

Question 5

Which statement is false with respect to the ability to adjust visualization properties when placing multiple visuals on a canvas?

A. Duplicate a visual that is on the canvas, changing the visual type in the duplicated visual. B. Resize the canvas by changing the Canvas Layout option from Auto Fit to Freeform. C. Hide a visual by right-clicking the canvas and selecting Hide from the drop-down menu. D. Change the visual's location on a canvas by selecting and dragging it to the desired location.

Discussion 0

Correct Answer: C Vote an answer

Question 6

Your customer has a hybrid aggregate Essbase cube. They want to be able to model what-if scenarios with hypothetical data and are considering using the Sandbox dimension.
Which two statements represent correct functionality of the Sandbox dimension?

A. Initially, the state of each sandbox member is #missing. B. When you submit changes to a base member, changes are seen and stored in each sandbox member. C. After working in the sandbox environment, you can commit changes to the base environment or even to another sandbox target. D. Using the sandbox dimension has storage overhead that would be required to replicate data from the base environment. E. The sandbox dimension has one base member and multiple sandbox members.

Discussion 0

Correct Answer: C,E Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 7

What does the band inside a box plot visualization represent?

A. The standard deviation of the data B. The maximum of the data C. The median of the data D. The average of the data

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 8

If we select the Oracle Analytics Cloud Enterprise Edition, which are the options available to select while creating the service?

A. Business Intelligence - Enteprise Reports
Data Visualization
Essbase B. Business Intelligence - Enterprise Reports
Pixel Perfect Reports
Data Visualization C. Business Intelligence - Enterprise Reports
Pixel Perfect Reports
Essbase D. Essbase
Pixel Perfect Reports
Data Visualization

Discussion 0

Correct Answer: A Vote an answer

Question 9

Which two statements are true about the Data Sync functionality?

A. Data Sync can create and manage surrogate keys in target tables. B. Data Sync is the only mechanism available in Oracle Analytics Cloud Standard Edition for loading data Into DBaaS tables. C. Data Sync cannot load incremental source insertions and updates; only full refresh loads are supported. D. To manage extractions and loads from cloud-based sources, Data Sync can invoke the REST APIs of the Oracle Database Cloud Service as well as the Oracle Business Intelligence Cloud Service.

Discussion 0

Correct Answer: B,D Vote an answer