Quiz
OAC PARTE 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 (100)
1Which of the following are available Filters in OAC?
- AList
- BAll of them
- CTop N/Bottom N
- DRelative Expression
- ERange
2What is the maximum number of branches in data flow?
- A3
- B10
- C1
- D5
3Data Flow options are?
- AAdd a new data set
- BSelect Columns
- CAggregate data
- DAll of them
- EUser filter to limit amount of data
- FAdd column
4Where can you drag and drop data elements to create the visualization?
- AWhite canvas
- BGrammar Panel
- CAssignment
- DAll of them
5Which two application roles can view and run reports in Oracle Analytics Cloud (projects, analyses, dashboards). Use this application role to control who has access to the service? (Choose Two answers)
- ABI Data load author
- BBI Author
- CBi Data Model Author
- DDV Author
- EBI Consumer
- FDV Consumer
6Which of the following examples represent Bursting reports implementations? (Select two answers)
- AFinancial reporting
- BEmployee Salary slip
- CExperience Letter
- DInvoice generation
7Which alternative way to present the outliers?
- AReference line
- BClusters
- CBoxplot
- DForecast
- ETrendline
8Which one highlights a general pattern or a direction of data when seen in relation to a time series?
- ATrendline
- BForecast
- CClusters
- DReference Line
- EOutliers
9Maximum number of snapshots that can be kept online?
- A20
- B40
- C15
- D5
10Which statement is not true in regards to manage Visuals in a canvas?
- AYou 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
- BYou can hide the visual
- 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 world or excel
11Filter can be added to?
- AAll Canvases
- BAll of the options
- CSingle Canvases
- DSingle Visualization
12Which two functions are Time series functions?
- ACluster
- BForecast
- CPeriod Rolling
- DTrend line
13Artifacts saved in a snapshot include? (Choose four answers)
- AApplication Roles
- BDatabase dump
- CData
- DMachine Learning
- EClassic content
14A box plot displays the five-number summary of a set of data. The five number summary are? (Choose Five answers)
- AFirst quartile
- BMinimum
- CThird quartile
- DMedian
- EAverage
- FMaximum
15Users with the following application role can manage data models?
- ABI Data model author
- BBI consumer
- CDV consumer
- DDV Data model author
16Which of these data types can be used for Relative Time filter?
- Anumber
- BAll of the above
- CDate
- DText
17What is the mandatory item that must be included in any Data flows?
- ABranch
- BSave Dataset
- CJoin
- DAdd Data
- EFilter
18In what ways can members of application roles be characterized?
- AAll of them
- BUsers
- CRoles
- DApplication Roles
19Which of these data types can be used for Expression filter?
- AAll of them
- BNumber
- CText
- DDate
20Which three functions can be used in the Reference Line?
- AConstant
- BAverage
- CLog
- DSum
- EMax
21Which two application roles are needed to connect to Day by Day? (Choose Two answers)
- ABI Data Model Author
- BBI Content Author
- CDV Consumer
- DDV Content Author
- EBI Consumer
- FBI Data load Author
22Which three filters are applied to data elements that are Text dimensions? (Choose Three answers)
- AList Bottom N
- BRange Filters
- CExpression Filter
- DData filter
- EList Filters
23Which one helps analyst to establish an appropriate baseline ?
- AClusters
- BOutliers
- CReference Line
- DTrendline
- EForecast
24You 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 expression filter for salary
- BCreate a list filter for south Africa and list filter for salary
- CCreate a list filter for south africa and relative for salary
- DCreate a list filter for south Africa and range filter for salary
- ENarrate
25Which one is related to Create Curated dataset and Transformation Tool?
- AData Flow
- BPrepare
- CApply Model
- DData set
26Which two data flow options are required to Allow Increment Data load?
- AAdd new data only
- BCreate surrogate key
- CNew Data Indicator
- DCreate Primary Key
27What does Data Actions enable you to connect to? (Choose Five answers)
- AExternal URLS
- BOracle Analytics Publisher Reports
- CData flow
- DRest APIs
- EOther Canvases
- FAnalysis
28Oracle Analytics Publisher is suited for? (Choose Three answers)
- ACreating Machine learning model
- BCreate and Delivering highly formatted business documents such as Invoices, Purchase Orders and Dunning Letters
- CSchedule your report to run once or as a recurring job
- DConnect to a variety of data soruces including BI Subject Areas, BI Analysis and RPD
29Which statement is True about Visualization? (Select Two answers)
- AWith the canvas in free form mode visualization can be layered with images arranged into a composite visualization ( Staking visuals )
- BYou can´t add elements to a canvas
- CWhen you add data elements to a canvas, A visualization will automatically be created
- DWhen you add data elements to a canvas, you will be prompted to choose a visualization type
30In which data type is Sentiment Analysis (Emotional) applied?
- ANumber
- BAll of the above
- CText
- DDate
31Explain the Measures will generate? (Choose Two answers)
- AKey Drivers
- BBasic Fact
- CSegment
- DAll of them
- EAnomalies
32Which four functions can be used in the Reference Line and the Reference Band?
- ALog
- BMedian
- CMin
- DMax
- EAverage
- FLn
33Which Semantic Type Recommendation is employed to convert Visa card numbers into asterisks?
- ASemantic Extractions
- BColumn Concatenations
- CEnrichments
- DFull and Partial Obfuscation/ Masking
- EPart Extraction
- FDate Extractions
34Which two application roles can create analyses and dashboards in Oracle Analytics Cloud and share them with others? (Choose Two answers)
- ABI Content Author
- BDV Consumer
- CDV Content Author
- DBI Consumer
- EBI Data load Author
- FBI Data model Author
35Which feature or capability is beneficial when one data flow serves as input for another data flow and when running multiple data flows as a single transaction?
- AMachine learning Model
- BData set
- CScenario
- DSequence
36Which of these data types can be used for List filter? (Select three answers)
- ANumber (Measure)
- BAll of the above
- CDate
- DText
- ENumber(Attribute)
37Limit Value option can be applied in which types of filters?
- ATop N/ Bottom N
- BList and Range
- CRelative Expression and List
- DRange and Relative Expression
38What is the extension for a pluggable visualization extension?
- Axml
- Bjson
- Csdk
- Dbi
- Edva
39On which of the following can you apply the Search Index? (Select three answers)
- AUser Folders
- BShared Folders
- CData Flow
- DSequence
- EData Model
- FScenario
40Identify all accurate statements regarding Level-Based Hierarchies? (Select Four answers)
- AEach business model can have one or more dimensions
- BEach dimension can have one or more logical levels
- CEach logical level hast one or more attributes(columns) associated with it
- Deach business model has only one dimension
- EThe relationship between the attribute is Many-To-Many
- FThe relationship between the attribute is One-To-Many
41Which object cannot be utilized with Explain?
- ASubject Area
- BMeasure
- CDataset
- DAttribute
42At what versions can you migrate content from Oracle Business Intelligence Enterprise Edition to Oracle Analytics Cloud? (Select two answers)
- AOracle Business Intelligence Enterprise Edition 12c(12.2.1.4 or later)
- BOracle Business Intelligence Enterprise Edition 11c(11.1.1.9.x or later)
- COracle Business Intelligence Enterprise Edition 12g(12.2.1.4 or later)
- DOracle Business Intelligence Enterprise Edition 11g(11.1.1.9 or later)
43Which statement is false about Visualization?
- AWhen RPD published you can use Clod data modelling tool
- BOutliers are divided into two Groups (Outliers and non-Outliers)
- CYou can create a new data set by using SQL statement
- DYou can create your own custom palette in visualization
44Augmented and Enriched Data include?
- AData preparation
- BApply suggestions
- CAll of the options
- DData profiling
45Which statement is True about Visualization?
- AWhen RPD published you can use Cloud data modelling tool
- BYou can create your own custom plate in visualization and save it in Console - Maps as xml extension
- CWhen you add the reference lines twice for a scatter plot it creates or splits data into four quadrants
- DThe scope of filter can be only for one canvas
46Which Advanced Analytics identify homogenous groups of data-points?
- ATrendline
- BReference Line
- CClusters
- DOutliers
- EForecast
47In Quality Insights, temporarily filter data across all columns in the table refer to?
- AExplore
- BAssess
- CAll of them
- DReview
48Inspect Model Includes?
- AAccess
- BAll of them
- CRelated
- DDetails
- EGeneral
- FQuality
49We can apply a selection step on? (Select four answers)
- AAttribute
- BGroups
- CMeasures
- DCalculated Items
- EHierarchy
50You 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 Multi Classifier model
- BCreate a data flow that includes a step to train a binary classifier model
- CCreate a data flow that includes a step to train a Numeric Prediction model
- DCreate a data flow that includes a step to train a Clustering Model
51Dashboard prompts types? (Select three answers)
- AColumn Prompt
- BVariable Prompt
- CSession Variable
- DRepository Variable
- EImage Prompt
52Each dataset has an assigned, unique, fixed object ID. You can use this ID to?
- AAll of them
- BHelp troubleshoot Oracle Analytics errors and issues
- CSearch log files
- DLog an Oracle Support request
53Connecting to Saas sources by using OOTB connector includes? (Select three answers)
- ALogical SQL
- BAnalytics
- CDatabase Tables
- DAttributes and Measures from subject area
54Which 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
- BUnsupervised
- CSupervised
- DAll of the above
55Which Data wrangling function can't be applied on Number data type?
- ALog
- BBin
- CPower
- DExtract
- EQuantile
- FSquare Root
56In a dataset, how do you restore a hidden column? (Choose two answers)
- AClick Format - Unhide all
- BGo to the Preparation Script Panel and locate the hide Column or Delete Column step> Click Delete step
- CRight click a column and select unhide
- DClick Hidden columns in the bottom right hand corner of the transform editor and select a column or click unhide all
57Which one is consisting Input and Output to produce the predictive data?
- AData flow
- BAll of them
- CModel
- DData set
58Explain features are? (Select two answers)
- ARecognize Patterns and trends in your data
- BWhen you drill by , keep , remove the other will be filtered as well
- CGenerate insights for influencers, prediction confidence and anomalies
- DClick on a field to highlight the others
59Which two database types you can register and use Oracle machine learning models to score data in Oracle Analytics?
- AYou can´t register Oracle machine learning models
- BOracle Database
- COracle Autonomous Transaction Processing
- DOracle Autonomous Data Warehouse
60In which tab you can define Master-Detail in Column Properties?
- AInteraction
- BConditional Formatting
- CColumn Format
- DStyle
- EData format
61Bursting in BI Publisher is used for?
- AWhen apply a filter or select a data set to reflect in all analysis in the canvases
- BHighlights a general pattern or direction of data when seen in relation to a time series
- CIt´s a process of splitting data into blocks, generating documents for each block , and delivering the documents to one or more destinations.
- DHighlight feature in selected items in the chart to effect in the other charts
62Which of the following is not a part of Migrating OBIEE 12c to OAC?
- AVerify dashboards, reports and subject areas
- BRestore the snapshot
- CIf you restore a snapshot with delivery, you must restore and activate them
- DRestart OAC services
- EUpload snapshot (BAR file) file to OAC
63Which of these are Machine Learning Processes?
- AModelling
- BData Preparation
- CAll of them
- DData understanding
- EEvaluation
64Action links types? (Select two answers)
- AInline Action link
- BDashboard Action link
- CNamed action link
- DDashboard Prompt
65Which one is not a part of Data Actions types?
- AAnalytics Link
- BHTTP API
- CURL Navigation
- DAction Links
- EPublish Events
66You can Apply Color to Visualizations from different options, which one is not a valid option?
- AColumn - right click - color - manage assigments
- BVisual - right click - color - manage assignments
- CProject properties - color series
- DNarrate - color - manage assignments
67Use 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 canvas at the same time
- CTurn rules on and off for a visualization
- DApply multiple rules to a measure at the same time
- ETurn rules on and off for a canvas
68Which of the following is not a part of Service Models?
- ACaas
- BSaas
- CIaas
- DPaas
- EPackaged Software
69The Oracle Analytics automatically analyze data quality to help you cleanse and enrich your data, quality tiles enable you to?
- AExplore
- BReview
- CAll of them
- DScroll
- EAssess
- FRename columns
- GReplace or correct
70When uploading Microsoft Excel spreadsheets (XLSX and XLS) to create datasets, which rule cannot be applied to Excel tables?
- AData in a column must be of the same type
- BTables must have an inline heading
- CTables must start in Row 1 and Column 1 of the Excel file
- DRow 1 must contain the names of the columns in the table
- EThe names in Row 1 must be unique
- FRow 2 and greater must contain the data for the table
71Which statement is false for Data Gateway?
- AYou can deploy multiple data gateway agents for high availability
- BFor Server type you install DG using Oracle university installer on Linux platform
- CYou can deploy only single data gateway agent
- DFor Personal type you install DG by copy DG binaries onto a Windows or MacOS machine
72Which of the following steps are not a part of creating a predictive analysis?
- ACreate a train model by creating a data flow with the above dataset and select appropriate algorithm and implantation method
- BCreate stories
- CApply the model by creating the data flow with the above model and save data in either Data set or Database
- DAdd the scenario ( Pre defined model) direct to the project
- EInspect the model for model quality
73Story telling allows analysts to?
- AShare your story with other stakeholders
- BAll of them
- CPresent your story in "power-point" like mode
- DOrganize your hypothesis, to initiate discussions amongst stakeholders
74In Present (Narrate) when you change the Present mode to ON, which tasks can you apply?
- AApply a new filter ,modify the existing filter and remove the existing filter
- BDrill through
- CAll of them
- DSort data
- EKeep selected and remove selected
75For which operating systems can you explore your data using the browser on mobile devices, both at your desk and while on the move? (Select three answers)
- AWindows
- BApple
- CAndroid
- DLinux
76You can Add Notes to Visualizations, what is the maximum points to connect a note to data points on a visualization or canvas?
- A10 data points
- B16 data points
- C1 data point
- D5 data points
77What could be the reason for not receiving any results when using BI search from the home page?
- AYou entered numbers value only
- BYou enter star *
- CYou used comma
78Classification and Regression are examples of which ML algorithm?
- AAll of the above
- BSupervised
- CReinforcement
- DUnsupervised
79Which statement is false for Catalog Manager?
- AIt´s a tool that lets you perform online and offline management of OAC Catalogs
- BYou can Manage folders, shortcuts, global variables, and objects
- CPreview and Search and replace objects, such as analyses and prompts
- DCreate analyses to display catalog data
- EView and edit catalog objects in Json language
80Analytics Task Classification are?
- APredictive
- BPrescriptive
- CAll of the above
- DDiagnostics
- EDescriptive
81You can upload Microsoft Excel spreadsheets (XLSX and XLS) to create datasets, what is the maximum data column limit for a single file?
- A100 columns
- B500 columns
- C50 columns
- D250 columns
82Clustering, Association Rules and Anomaly Detection are examples of which ML algorithm?
- ASupervised
- BReinforcement
- CUnsupervised
- DAll of them
83What are the Data Gateway Types? (Select two answers)
- AOn-prem Gateway
- BPersonal
- CCloud Gateway
- DServer
84Which four steps are part of Shifting RPD to OAC instance?
- AReplicate the data from On-premise source to autonomous data warehouse ATW if you don´t want to use Data gateway
- BCreate Repository and session variables
- CPoint RPD to the ADW
- DCheck global consistency
- EUpload RPD to OAC service : Go to DV - Console - Snapshot- Replace data model - Proceed without viruses scanner
85Trendline offers?
- ALinear methods
- BAll of them
- CPolynomial methods
- DExponential methods
86BI Briefing book features are?
- AAll of them
- BCan be shared off line for printing HTML and PDF
- CUpdated or snapshot of analysis and dashboard
- DCan be added to dashboard page
- ECan be updated, scheduled and delivered by agent
87Multiple Subject area can be used through? (Select four answers)
- AUnion
- BInsersect all
- CMinus
- DAll of the above
- EInsersect
- FUnion all
88Which one of the following actions is performed after applying filtering and aggregation, specifically involving the removal of certain members from the analysis?
- ADashboard Prompt
- BIn line Action Link
- CAll of the above
- DSelection Step
89What is the Out of the box (OOTB) algorithm that used for Clusters and Outliers? (Select two answers)
- AETS
- BSeasonal ARIMA
- CK-Means
- DARIMA
- EHierarchical cluster
90When 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 Access
- CNotepad
- DMicrosoft Excel
91What are the Presentation modes (Present Style) (Select Three answers)
- ADistribution
- BReportMode
- CNavigation Bar
- DFilmstrip
- EBottom Tabs
92Which three Data wrangling functions can be applied on Date data type?
- AReplace
- BExtract
- CExponential
- DHide
- EDuplicate
93You 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)
- APolygon
- BSquare
- CCircle
- DLine
- EPoint
94Imported Projects with dva extension include?
- AAssociated data set
- BAll of the above
- CStored data
- DConnection credentials
- EConnection string
95Which statement is false for Cloud data modelling tool?
- AYou can synchronize with database the entire model or specific object
- BIt generates subject areas
- CNo need to click on "Lock to edit" to make any changes
- DYou can build more than one hierachy
- EPublish options are Publish and unlock or publish and keep lock
96You can share a Visualization, Canvas, or Story to social media. Which one is not a part of available social media?
- ATwitter
- BOracle Content and Experience (OCE)
- CSlack
- DOracle Social Network (OSN
- EFacebook
- FLinkedin
97Machine Learning Algorithms are?
- ASupervised
- BReinforcement
- CAll of them
- DUnsupervised
98Snapshot contains? (Select three answers)
- AModel
- BDatabase Dump
- CCatalog
- DAll of the above
- EApplication Roles
99When you copy a visualization or canvas from one workbook to another, Oracle Analytics Include? (Select four answers)
- AFilters
- BColor assignments
- CDashboard Prompts
- DData
- ECalculations
100You create natural language descriptions of the attributes and measures in your dataset, what are the Supported Data Element Combinations? (Select two answers)
- ATwo attribute and two measures
- BTwo attributes and one measure
- COne attribute and one measure
- DOne attribute and two measures
Information
- Description
- Ordenadores/Informática Quiz on OAC PARTE 2, created by A A on 30/11/2023.
- Author
- A A
- Language
- Español
- Views
- 20
- Tags
- Rating
- No ratings yet Rate this quiz