1Z1-936 by Oracle Actual Free Exam Q&As

Question 1

Which three options are correct about application workbooks?

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

Discussion 0

Correct Answer: A,B,C Vote an answer

Question 2

What should you do to visualize the relationship between two numeric values?

A. Use a box plot with trellising. B. Create multiple pie charts. C. Create a line chart with multiple reference lines. D. Create a scatter plot of the two numeric values and choose a value of interest as the category (points).

Discussion 0

Correct Answer: B Vote an answer

Question 3

What statement is false regarding how Data Flow Sequences can be configured?

A. To change the order of an item in the Sequence, the item can be selected by clicking it and dragging it up or down. It will be placed immediately below the highlighted item. B. Data Set prepare execution can be encapsulated by embedding Sequences inside of other Sequences. C. To remove an item from a Sequence, click the Action menu icon at the far right of the line upon which the item is found and then select Remove from the drop-down menu, D. Sequences can be configured to fork multiple Data Flows to be run in parallel so as to complete data preparation more quickly than running flows serially.

Discussion 0

Correct Answer: D Vote an answer

Question 4

Select two correct editions of Oracle Analytics Cloud.

A. Standard Edition B. BI Cloud Service Edition C. Data Lake Edition D. Big Data Edition E. SaaS Edition

Discussion 0

Correct Answer: A,C Vote an answer

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

Question 5

In which two ways can you use Oracle Analytics Cloud to determine which values of a given data set may provide the greatest opportunity due to their stand out qualities?

A. Create a box plot visualization of your data set. B. Use a combination of Max / Min value reference lines. C. Modify the color palette to highlight unique values. D. Add an outlier visualization to your canvas. This will highlight data points that stand out and may Justify further investigation.

Discussion 0

Correct Answer: A,B Vote an answer

Question 6

Which two statements are true regarding configuring filters to control visual content?

A. Variables may be employed in all Data Visualization filter types (that is, Range, List, Date, Expression). B. When the Oracle Business Intelligence Enterprise Edition repository is used as a data source, filters defined in the initialization blocks with the client administration tool are automatically inherited in Data Visualization. C. Expression filters cannot be applied in the filter steps of Oracle Analytics Cloud Data Visualization data flows. D. Application role filters for fact and dimension tables are defined in the Oracle Analytics Cloud Data Modeler.

Discussion 0

Correct Answer: B,D Vote an answer

Question 7

Which two statements are true regarding the ways in which Oracle Analytics Cloud provides self-service data preparation capabilities?

A. Data sources can include application tables, data warehouses, data lake reservoirs, delimited flat files, and Microsoft Excel spreadsheets in the .xlsx format. B. Data flows within the data preparation feature of Data Visualization can be used to extract, wrangle, and format data content from all supported data sources to create data sets upon which visuals may be constructed. C. The Oracle Data Integrator tool used for extraction, load, and transformation of data is a foundational component of the Oracle Analytics Cloud and is essential for data preparation. D. Join rules for mashing up data from relational sources and delimited flat files can only be defined within the Oracle Analytics Cloud Data Modeler.

Discussion 0

Correct Answer: A,B Vote an answer

Question 8

Which statement Is false about log files generated by Oracle BI Analyses?

A. Catalog Manager provides rapid access to the log file. B. The log file is not accessible via the repository Administration client. C. An Analysis that references two fact tables will generate two database-specific SQL queries in the log file. D. The log file can be accessed via the Fusion Middleware Control.

Discussion 0

Correct Answer: B Vote an answer

Oracle Cloud Platform Enterprise Analytics 2018 Associate - 1Z1-936 Exam Practice Test