Oracle 1Z0-1041-23 Quiz 1 Topic 2 Questions 1-5

Question: 1

You are building a model that will be used for a sales report.

Which two statements are the about hierarchy and levels?

AEach level is based on one or multiple columns.

BHierarchies enable drilling in reports.

CA hierarchy must have one to many relationships between attributes.

DSkipped levels and unbalanced hierarchies can be enabled for all the dimension tables.

EA hierarchy shows relationships among a group of columns in a fact table.

FA dimension table must have only one hierarchy.

GWhen defining a level. Key Columns must be the same as Display Columns.

Show Answer

Question: 2

Data How can take one or more data sets and integrate them to produce curated sets of dat

a. After applying all the joins, transformations, and filters, you need to save the data. What are the two options to save data in Data Flow?

ASpreadsheet

BAll Rows

CData Set Storage

DDatabase Connection

Show Answer

Question: 3

Your client has created new custom map layer. How can this map layer be exposed in a project?

ACreate a new project. Add a map visualization. Change the layer property to new. Click upload. Select the Json file to upload.

BCreate a new project. Add a map visualization, change the layer property to new. click upload. Select the geojson file to upload.

CNavigate to the Console. Click Maps. From the Map Layers tab, upload the geojson file.

DNavigate to the Console. Click Maps. On the Map Layers tab, upload the xml file.

Show Answer

Question: 4

You have a Historical Sales data set, which you use to train a model in Oracle Anatytics Cloud (OAC)

Your products have an attribute named Profitability, which has one of the three values: high, medium, c This is the property you set as the target.

Which train data step is required to train a model in

ATrain Clustering

BTrain Text Prediction

CTrain Multi-Classifier

DTrain Multi-Value

ETrain Numeric Prediction

FTrain Binary-Classifier

Show Answer

Question: 5

You are a developer designing a solution to analyze retail sales. A key requirement for the solution is a product hierarchy with multiple levels that supports drill-down in an Oracle Analytics Cloud (OAC) workbook.

Which two configurations are appropriate for your solution?

AData set created with data preparation

BSemantic model created in the OA Admin tool

CSemantic model created in the Thin Client Modeler

DHierarchy created in a proper snowflake multi-table data set

EData set with a hierarchy created in OAC Data Flow

FData set merging a semantic model with the hierarchy and additional data

Show Answer

Oracle 1Z0-1041-23 Quiz:1 Topic:2 Questions:1-5