Quiz
oac 2
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (95)
1Which Advanced Analytics you can add if you have a visualization with one period column in one of its axes?
- AForecast
- BReference Line
- CAll of the above
- DCluster
- ETrend Line
2What happens when you remove a data set from the Project?
- AYou can't remove a data set from project
- BIt will be deleted from project and keep it on the OAC Data objects
- CIt will be deleted from project and from on the OAC Data objects as well
- DNothing will happen
3You need to connect to Oracle Fusion Applications and create a new data set, how you can accomplish it?
- ABy uploading key wallet file
- BBy installing gateway and connect through it
- CBy inserting Host link, User name and password and type of Authentication
- DBy installing the OAS on the same server
4Which of the following can't be defined as external data set?
- AAttribute
- BMeasures
- CHierarchies
5In which two Oracle Cloud Infrastructure (OCI) - Autonomous Database Tab you can download the wallet?
- AScale Up/Down
- BDB Connection
- CPerformance Hub
- DService Console
6Which one help you to create multiple outputs from a data flow?
- AJoin
- BSplitter
- CBranch
- DFork
7Which type of Data Actions you need to connect to Oracle Analytics BI Publisher Reports?
- APublish Events
- BAnalytics link
- CURL Navigation
- DHTTP API
8You want to create a new connection for Oracle Autonomous Data Warehouse through DV, which step is not required?
- ADownload wallet.zip file from OCI
- BUpload Client credentials {wallet.zip file}
- CUpload data gateway key file]
- DInsert User Name/Password
- ESelect Service Name
9Which one is not a part of Export project content?
- ADashboard
- BPermissions
- CConnection credentials
- DData
10Which application role can create visualization projects, load data for data visualizations, and explore data visualizations?
- ABI Content Author
- BBI Data load Author
- CBI Data Model Author
- DBI Consumer
- EDV Content Author
- FDV Consumer
11Which option can be done in a story and can't be done in Canvases?
- APrint
- BUndo/Redo
- CExport
- DChoose to hide or show visuals
12You can modify Data set Name, Check data elements, Enable Index Data set for Searching and check permissions from?
- ADuplicate
- BSetting
- COpen
- DInspect
13Which three of the following are use cases for Data Flows?
- AApply Machine Learning training models
- BCreate Sequence
- CCurate Data Sets
- DCreate Machine Learning training models
14For which data type ( Bin option in data wrangling function) is available?
- ADate
- BBoolean
- CNumber
- DText
15What is automatic correlating of data in oracle DVCS?
- ASelecting data in one visualization highlights related data in others
- Bblending of data
- CAutomatic creation of visualization based on scenario
16When you download the snapshot from console, What is the extension file?
- AJson
- Brpd
- Cdva
- Dbar
17Which statement is false about External Sources Characteristics?
- AData source files with the .csv or .txt extension
- BHierarchies can be defined in external data sources
- CMaximum size of the file can be 250 MB with 250 columns
- DA data source either extends a dimension by adding attributes or extends facts by adding measures and optional attributes
- EData source files can form a Microsoft Excel spreadsheet file, with the .xlsx or - xls extension
18What is the extension for a pluggable visualization extension?
- Abi
- BJson
- Cdva
- Dsdk
- Exml
19Which statement is True about Visualization? (Select Two answers)
- AWhen you add data elements to a canvas, you will be prompted to choose a visualization type
- BWhen you add data elements to a canvas, A visualization will automatically be created
- CWith the canvas in free form mode visualization can be layered with images arranged into a composite visualization (Staking visuals)
- DYou can’t add elements to a canvas
20Which of the Advanced analysis can be used in Expression filter? (Select four answers)
- AForecast
- BOutlier
- CCluster
- DTrendline
- EReference
21What is the maximum number of branches in data flow?
- A3
- B5
- C10
- D1
22Augmented and Enriched Data include?
- AApply suggestions
- BAll of the options
- CData profiling
- DData preparation
23Oracle Analytics Publisher is suited for? (Choose Three answers)
- AConnect to a variety of data sources including BI Subject Areas, BI Analysis and RPD
- BSchedule your report to run once or as a recurring job
- CCreate and Delivering highly formatted business documents such as Invoices, Purchase Orders and Dunning Letters
- DCreating Machine learning model
24Which two filters are applied to data elements that are dimensions? (Choose Two answers)
- AData Filter
- BExpression Filter
- CList filters
- DRange filters
25Which of these data types can be used for Top N/Bottom N filter? (Select two answers)
- AText
- BAll of the above
- CDate
- DNumber
26Artifacts saved in a snapshot include? (Choose four answers)
- ADatabase dump
- BApplication Roles
- CClassic content
- DMachine Learning
- EData
27Which two functions are Time series functions?
- ATrend Line
- BForecast
- CPeriod Rolling
- DCluster
28Which of these data types can be used for List filter? (Select three answers)
- AAll of the above
- BNumber (Attribute)
- CDate
- DNumber (Measure)
- EText
29Sentiment Analysis creates a new output column called “emotion”, What are the three default values?
- ANatural
- BPositive
- CBad
- DNegative
- EGood
30Data Actions Enable you connect to? (Choose Five answers)
- AData flow
- BOther Canvases
- CREST APIs
- DOracle Analytics Publisher Reports
- EAnalysis
- FExternal URLS
31You received a requirement to build a visualization to show the total revenue for South Africa where their salaries is more than 1 million dollars? (Choose two answers)
- ACreate a list filter for south Africa and list filter for salary
- BCreate a list filter for south Africa and range filter for salary
- CNarrate
- DCreate a list filter for south Africa and expression filter for salary
- ECreate a list filter for south Africa and relative for salary
32Which of these data types can be used for Range filter? (Select two answers)
- AAll of the above
- BDate
- CNumber
- DText
33Which statement is false about Visualization?
- AOutliers are divided into two Groups (Outliers and non-Outliers)
- BWhen RPD published you can use Cloud data modelling tool
- CYou can create your own custom palette in visualizations
- DYou can create a new data set by using SQL statement
34Explain the Measures will generate?
- ASegment
- BKey Drivers
- CAll of them
- DBasic Fact
- EAnomalies
35Which alternative way to present the outliers?
- AClusters
- BForecast
- CBoxplot
- DReference Line
- ETrendline
36Which one helps analyst to establish an appropriate baseline ?
- AClusters
- BReference Line
- CForecast
- DTrendline
37Limit Value option can be applied in which types of filters?
- AList and Range
- BRange and Relative Expression
- CTop N/Bottom N
- DRelative Expression and List
38Which statement is True about Visualization?
- AThe scope of filter can be only for one canvas
- BWhen RPD published you can use Cloud data modelling tool
- CYou can create your own custom plate in visualizations and save it in Console - Maps as xml extension
- DWhen you add the reference lines twice for a scatter plot it creates or splits data into four quadrants
39Which two data flow options are required to Allow Increment Data load?
- ACreate Surrogate key
- BCreate Primary key
- CAdd new data only
- DNew Data Indicator
40Where can you drag and drop data elements to create the visualization?
- AAssignment
- BWhite canvas
- CAll of the options
- DGrammar Panel
41Which three functions can be used in the Reference Line?
- ALog
- BMax
- CAverage
- DConstant
- ESum
42Data Flow options are?
- AAdd column
- BAdd a new data set
- CSelect Columns
- DAggregate data
- EAll of the them
- FUser filter to limit amount of data
43Which one highlights a general pattern or a direction of data when seen in relation to a time series?
- AForecast
- BTrendline
- CReference Line
- DOutliers
- EClusters
44Maximum number of snapshots that can be kept online?
- A15
- B40
- C20
- D5
45In which data type is Sentiment Analysis (Emotional) applied?
- AText
- BNumber
- CAll of the above
- DDate
46Which of the following are available Filters in OAC?
- ARange
- BAll of the them
- CTop N/Bottom N
- DList
- ERelative Expression
47Which four functions can be used in the Reference Line and the Reference Band?
- AMedian
- BLog
- CMin
- DMax
- EAverage
- FLn
48Members of application roles can be?
- AUsers
- BApplication Roles
- CRoles
- DAll of the them
49Which of the following is related to Transformation Tool and Create Curated data set?
- AData Flow
- BData set
- CPrepare
- DApply Model
50While you are preparing a dataset, you have a numeric value that contains a lot of values, which wrangling function you can use to group the column for different groups?
- AConcatenate
- BBin
- CCluster
- DGroup
51Which statement is not true in regards to manage Visuals in a canvas?
- AYou can hide the visual
- BYou can copy and paste a visualization or canvas within the same workbook, to another open workbook, or to another workbook open in a different browser tab
- CYou can move the visual by drag drop
- DYou can copy all of a visualization's data to the clipboard and then paste the data to another application, like Word or Excel
52A box plot displays the five-number summary of a set of data. The five number summary are? (Choose Five answers)
- AAverage
- BFirst quartile
- CThird quartile
- DMaximum
- EMinimum
- FMedian
53Data Gateway Types? (Select two answers)
- APersonal
- BServer
- CCloud Gateway
- DOn-prem Gateway
54Which of these are Machine Learning Processes?
- AData Understanding
- BAll of them
- CModelling
- DEvaluation
- EData Preparation
55Multiple Subject area can be used through? (Select four answers)
- AUnion
- Bintersect
- CUnion all
- Dintersect all
- EAll of the above
- FMinus
56Action links types? (Select two answers)
- ADashboard Action link
- BDashboard Prompt
- CInline Action ljnk
- DNamed action link
57Which one is consisting Input and Output to produce the predictive data?
- AModel
- BAll of them
- CData set
- DData flow
58Inspect Model Includes?
- AAll of them
- BRelated
- CAccess
- DDetails
- EQuality
- FGeneral
59Use conditional formatting to highlight important data events in your visualizations so that you can take action. What can you do for each canvas? (Select four answers)
- AChange the order in which rules are applied
- BApply multiple rules to a measure at the same time
- CApply multiple rules to a canvas at the same time
- DTurn rules on and off for a canvas
- ETurn rules on and off for a visualization
60You have a data set that you wish to use to train a ML model. The attribute contains three text values (Good, Fair and Bad). How should you perform this operation?
- ACreate a data flow that includes a step to train a binary classifier model
- BCreate a data flow that includes a step to train a Clustering model
- CCreate a data flow that includes a step to train a Multi Classifier model
- DCreate a data flow that includes a step to train a Numeric Prediction model
61Snapshot contains? (Select three answers)
- ADatabase Dump
- BApplication Roles
- CCatalog
- DAll of the above
- EModel
62Which ML algorithm Provides historical data with input and output and produces a program that can predict and analyze the data based on a specific business problem?
- AReinforcement
- BAll of the above
- CSupervised
- DUnsupervised
63In which edition you can use Data Gateway?
- AOracle Business Intelligence
- BOracle Analytics Professional
- COracle Analytics Essbase
- DAll of them
- EOracle Analytics Cloud Enterprise
64What is the OOTB algorithm used for Outliers and Clusters? (Select two answers)
- ASeasonal ARIMA
- BARIMA
- CK-Means
- DETS
- EHierarchical cluster
65Which statement is false for Cloud data modelling tool?
- AYou can synchronize with database the entire model or specific object
- BNo need to click on “Lock to edit” to make any changes
- CIt generates subject areas
- DYou can build more than one hierarchy
- EPublish options are Publish and unlock or publish and keep lock
66Maximum row limit for 12 OCPU is?
- A500000
- B125000
67Which of the following is not a part of Service Models?
- AIaas
- BPackaged Software
- CCaas
- DPaas
- ESaas
68You create natural language descriptions of the attributes and measures in your dataset, what are the Supported Data Element Combinations? (Select two answers)
- AOne attribute and two measures
- BTwo attributes and one measure
- COne attribute and One measure
- DTwo attribute and Two measures
69Connecting to Saas sources by using OOTB connector includes? (Select three answers)
- AAnalytics
- BDatabase Tables
- CAttributes and Measures from subject area
- DLogical SQL
70Which statement is false for Catalog Manager?
- ACreate analyses to display catalog data
- BIt's a tool that lets you perform online and offline management of OAC Catalogs
- CYou can Manage folders, shortcuts, global variables, and objects
- DView and edit catalog objects in Json language
- EPreview and Search and replace objects, such as analyses and prompts
71Which statement is false for Data Gateway?
- AFor Server type you install DG using Oracle university installer on Linux platform
- BYou can deploy multiple data gateway agents for high availability
- CFor Personal type you install DG by copy DG binaries onto a Windows or MacOS machine
- DYou can deploy only single data gateway agent
72In a data set, how you Restore a Hidden Column? (Choose two answers)
- AClick Format – Unhide all
- Bclick Hidden columns in the bottom right hand corner of the transform editor and select a column, or click Unhide All
- CRight click a column and select Unhide
- DGo to the Preparation Script Panel and locate the Hide Column or Delete Column step Click Delete Step
73You can Apply Color to Visualizations from different options, which on is not a valid option?
- ANarrate - color – manage assignments
- BProject properties – Color series
- CVisual – right click – color – manage assignments
- DColumn – right click – color – manage assignments
74Which one is not a part of Data Actions types?
- AAction Links
- BPublish Events
- CAnalytics Link
- DURL Navigation
- EHTTP API
75Machine Learning Algorithms are?
- AReinforcement
- BSupervised
- CAll of them
- DUnsupervised
76When you Copy and Paste a Visualization's Data You can copy all of a visualization's data to the clipboard and then paste the data to another application like? (Select Two Answers)
- AMicrosoft Word
- BMicrosoft Excel
- CMicrosoft Access
- DNotepad
77Dashboard prompts types? (Select three answers)
- ASession Variable
- BColumn Prompt
- CImage prompt
- DVariable Prompt
- ERepository Variable
78Which three Data wrangling functions can be applied on Date data type?
- AExtract
- BExponential
- CHide
- DDuplicate
- EReplace
79Which of the following steps are not a part of creating a predictive analysis?
- ACreate train model by creating a data flow with the above dataset and select appropriate algorithm and implantation method
- BInsect the model for model quality
- CAdd the scenario (Pre defined model) direct to the project
- DCreate stories
- EApply the model by creating the data flow with the above model and save data in either Data set or DatabaseApply the model by creating the data flow with the above model and save data in either Data set or Database
80Which of the following is not a part of Migrating OBIEE 12c to OAC?
- ARestore the snapshot
- BIf you restore a snapshot with delivery, you must restore and activate them
- CRestart OAC services
- DUpload snapshot (BAR file) file to OAC
- EVerify dashboards, reports and subject areas
81Clustering, Association Rules and Anomaly Detection are examples of which ML algorithm?
- AUnsupervised
- BSupervised
- CAll of them
- DReinforcement
82You can Add Notes to Visualizations, what is the maximum points to connect a note to data points on a visualization or canvas?
- A1 data point
- B16 data points
- C10 data points
- D5 data points
83OAC Components include?
- AVisualization, DVCS and OACS
- BAll of them
- COracle Essbase
- DOracle Smart View
- EBI Modeler
84BI Modeler
- AHighlights a general pattern or direction of data when seen in relation to a time series
- BIt's a process of splitting data into blocks, generating documents for each block, and delivering the documents to one or more destinations?
- CHighlight feature in selected items in the chart to effect in the other charts
- DWhen apply a filter or select a data set to reflect in all analysis in the canvases
85Which four steps are part of Shifting RPD to OAC instance?
- ACheck global consistency
- BUpload RPD to OAC service: Go to DV – Console – Snapshot – Replace data model - Proceed without viruses scanner
- CPoint RPD to the ADW
- DReplicate the data from On-premise source to autonomous data warehouse ATW if you don’t want to use Data gateway
- ECreate Repository and session variables
86Classification and Regression are examples of which ML algorithm?
- AAll of the above
- BUnsupervised
- CReinforcement
- DSupervised
87Master-Detail is defined through which tab in Column Properties?
- AStyle
- BData Format
- CColumn Format
- DInteraction
88Trendline offers?
- AExponential methods
- BPolynomial methods
- CLinear methods
- DAll of them
89When you copy a visualization or canvas from one workbook to another, Oracle Analytics Include? (Select four answers)
- AColor assignments
- BDashboard Prompts
- CFilters
- DCalculations
- EData
90You used BI search from home page and nothing returned, what is the reason?
- AYou used comma
- BYou enter star *
- CThe date format is Year-Month-Date
- DYou entered numbers value only
91Imported Projects with dva extension include?
- AAll of the above
- BConnection credentials
- CConnection string
- DAssociated data set
- EStored data
92Which two database types you can register and use Oracle machine learning models to score data in Oracle Analytics?
- AOracle Autonomous Transaction Processing
- BYou can’t register Oracle machine learning models
- COracle Database
- DOracle Autonomous Data Warehouse
93You can upload Microsoft Excel spreadsheets (XLSX and XLS) to create datasets, which rule can’t be applied for Excel tables?
- AThe names in Row 1 must be unique
- BTables must start in Row 1 and Column 1 of the Excel file
- CRow 2 and greater must contain the data for the table
- DData in a column must be of the same type
- ERow 1 must contain the names of the columns in the table
- FTables must have an inline heading
94You use an Image as a Map Background and Draw Map Layer Shapes on the Image, What are the Custom Map Layer types?(Select four answers)
- ACircle
- BPoint
- CLine
- DSquare
- EPolygon
95Which one of filtering after aggregation is applied. Removing some member from analysis?
- ADashboard Prompt
- BIn line Action Link
- CSelection Step
- DAll of the above
Information
- Description
- Quiz on oac 2, created by Cara Dudley on 04/05/2022.
- Author
- Cara Dudley
- Language
- English
- Views
- 5
- Tags
- Rating
- No ratings yet Rate this quiz