VCEdump

1Z0-1041-20 Oracle Cloud Platform Enterprise Analytics 2020 Specialist

PDF question preview Back to product

Reading controls

Reader tools

Free demo

13 of 82 questions

Purchase the full version to unlock every question and answer.

View the full question set

Preview tools

Try Web TestEngine

Question formats

Single choice8

Multiple choice5

Oracle · 1Z0-1041-20

Free 1Z0-1041-20 Exam Dumps Preview

Preview real exam questions, verified answers and available explanations before choosing a study plan.

Question 1

Single choice

Your company is using an Essbase cube, which is enabled for Scenario Management. Planners model data in individual scenarios and submit them for approval. While modeling data in the "SB1" sandbox, you changed a few values based on some assumption. Later, you realized that your assumptions were incorrect. You want to start again with the original values, the same as base.

Which step should you perform?

A
Type #Revert in the changed scenario cells and Submit Data.
B
Type #Missing in the changed scenario cells and Submit Data.
C
Type #Discard in the changed scenario cells and Submit Data.
D
Type #Base in the changed scenario cells and Submit Data.
E
Type #Original in the changed scenario cells and Submit Data.

Reveal answer details Close answer details

Correct answerA

Question 2

Single choice

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
DashboardPrompts.txt
B
DashboardPrompts.xml
C
Prompts.txt
D
Prompts.xml

Reveal answer details Close answer details

Correct answerA

Question 3

Single choice

Which action cannot be employed to split one Data Set column containing data with hyphenated strings (in the format of xxx-xxx) into two columns?

A
Edit the Data Set and select the Create option from the hyphenated column's action menu to invoke the Expression Editor. Use the String functions to parse and extract the string preceding the hyphen.
Repeat for the text following the hyphen.
B
Edit the Data Set and select the Split option from the hyphenated column's action menu.
C
Edit the Data Set and select the Edit option from the hyphenated column's action menu to invoke the Expression Editor. Use the String functions to parse and extract the string preceding the hyphen.
Repeat for the text following the hyphen.
D
Edit the Data Set and select the Group option from the hyphenated column's action menu to create two new groups for each element.

Reveal answer details Close answer details

Correct answerD

Question 4

Single choice

Which feature does the Data Lake Edition uniquely offer?

A
Use the Day by Day mobile app
B
Execute data flows on Apache Spark
C
Migrate content from your existing on-premises environment
D
Live optimized connectivity to your on-premises database

Reveal answer details Close answer details

Correct answerB

Explanation

Reference
https://www.us-analytics.com/hyperionblog/oracle-unveils-data-lake-edition-for-oac

Question 5

Single choice

How should you determine the accuracy of a machine learning model created in Oracle Analytics Cloud?

A
Open the Inspect dialog for a given machine learning model and review the F1 score.
B
Run the machine learning model with various filter values applied.
C
Create a data flow that Includes a histogram.
D
Use the debug option in the data flow where the model was created.

Reveal answer details Close answer details

Correct answerA

Question 6

Multiple choice

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

A
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.
B
Join rules for mashing up data from relational sources and delimited flat files can only be defined within the Oracle Analytics Cloud Data Modeler.
C
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.
D
Data sources can include application tables, data warehouses, data lake reservoirs, delimited flat files, and Microsoft Excel spreadsheets in the .xlsx format.

Reveal answer details Close answer details

Correct answersC, D

Question 7

Multiple choice

What are two incorrect steps when creating pixel perfect reports with Bl Publisher?

A
Generate and save to a folder in the Presentation Catalog a sample set of data that can be used for configuring and testing the report.
B
Define a data model to set the business view of the data, join data sets, and create custom measures.
C
Create connections to sources, some of which include Oracle l0g/llg, Oracle BI Server, JDBC, and MS
SQL Server 2005/2008.
D
Test connections between BI Publisher and configured sources using Oracle Fusion Middleware Control.

Reveal answer details Close answer details

Correct answersB, D

Question 8

Multiple choice

Your customer is using Oracle Analytics Cloud - Essbase Command Line Interface (CL1) to perform administrative actions on Oracle Analytics Cloud - Essbase.

Which are three valid options for executing the DataLoad command?

A
a dimension file
B
a data file and an optional rules file
C
a saved local connection using a secure URL
D
a rules file with a username and password
E
a stream option referencing a saved local connection

Reveal answer details Close answer details

Correct answersB, D, E

Question 9

Multiple choice

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
You need to set up a connection pool in Data Modeler.
D
It is only available in Enterprise Edition.
E
It is available in both Essbase and Enterprise Edition.

Reveal answer details Close answer details

Correct answersA, B, D

Question 10

Multiple choice

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

A
Expression filters cannot be applied in the filter steps of Oracle Analytics Cloud Data Visualization data flows.
B
Variables may be employed in all Data Visualization filter types (that is, Range, List, Date, Expression).
C
Application role filters for fact and dimension tables are defined in the Oracle Analytics Cloud Data Modeler.
D
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.

Reveal answer details Close answer details

Correct answersC, D

Question 11

Single choice

How should you use a machine learning model within a canvas of an Oracle Analytics Cloud project?

A
Create a custom calculation.
B
Create a scenario using the required model.
C
Use the machine learning model visualization.
D
Create a data sequence.

Reveal answer details Close answer details

Correct answerB

Question 12

Single choice

Your customer has an Essbase cube with current year P&L data.
Once a month, the cube needs to be updated with the last closed month data.

How can the monthly data be loaded incrementally using Cube Designer?

A
Use the Update Cube option from the Build Option menu in Cube Designer.
B
Use the Transform Data option in Cube Designer.
C
Cube Designer cannot be used to load data in the cube.
D
Cube Designer cannot be used to load data incrementally in the cube.
E
Use the Load Data option in Cube Designer.

Reveal answer details Close answer details

Correct answerA

Explanation

Reference
https://docs.oracle.com/en/cloud/paas/analytics-cloud/essug/using-oracle-analytics-cloud-
essbase.pdf (123)

Question 13

Single choice

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

A
The log file is not accessible via the repository Administration client.
B
Catalog Manager provides rapid access to the log file.
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.

Reveal answer details Close answer details

Correct answerB

VOL	TYPE	QUESTIONS
1	Single choice	8
2	Multiple choice	5

Free 1Z0-1041-20 Exam Dumps Preview

Oracle Cloud Platform Enterprise Analytics 2020 Specialist

PREVIEW CONTENTS · 2 VOLUMES

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9

QUESTION 10

QUESTION 11

QUESTION 12

QUESTION 13