Quiz
100-150
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 (50)
1which two statements are false about OAC external sources characteristics?
- AData source files should be .xls/xlsx, txt or .CSV extension
- BData source files should be iso or html extension
- CData source either extends a dimension or extends facts
- DHierarchies can be defined in external data sources
2Which options can't you connect to when you create a connection through the Oracle Applications out of the box connector?
- AOracle Transaction BI Subject Area
- BOracle Transaction BI Analysis
- CLogical SQL against the Subject Area's exposed by the Oracle Transactional Business Intelligence Layer
- DOracle Database
3Which statement is false regarding to Oracle Analytics Data Flow?
- AIt’s a user-friendly lightweight transformation tool
- BIt provides a clean and powerful interface to a business user to cleans and transform your data.
- CIs a visual representation document of data transformations
- DRecognize Patterns and trends in your data
4When one data flow failed within the sequence, select the true action happened?
- AAll the changes to the Data Sets done in the sequence are rolled back
- BYou must add a trigger to handle the fault
- CIt will work successfully in the next time
- DAll of the above
5Which options make filtering? (Select three answers)
- ASorting
- BDrill Down
- CKeep Selected
- DRemove Selected
- EHighlight
6Which external can't be added to OAC? (select only one)
- Acsv
- Bxls
- Czip
- Dtxt
7The default OCPU limit for professional and Enterprise edition when you sign up is?
- A4 OCPU
- B2 OCPU
- C10 OCPU
- D16 OCPU
8Which statement is false about migrating data models to the Cloud?
- AYou must use Oracle BI Enterprise Edition 11.1.1.7 or later
- BYou check global consistency and update connection pools to point to the cloud
- CYou can use Oracle Developer Tool if model changes are required
- DYou can move the RPD back to on premises
9Which Operating system are not supported for Oracle Gateway?
- AOracle Linux
- BMAC OS
- COracle Solaris
- DMicrosoft Windows
- EAndroid
10Advanced Filtering can be applied through?
- AExpression Filters
- BExtract Filter
- CPresentation Filter
- DRange Filters
11Which statement is false in regarding to Visualizations?
- ACustom Palette cannot be created in Visualizations.
- BYou can create your own custom palette in Visualizations
- CCustom Plate extension is skd
- DYou can add your custom plate through Console - Extension
12Which statement is false in regarding to Data modeler?
- AMultiple users can use Data Modeler at the same time
- BVariables returns only single value
- CYou can model data from various source types, such as star and snowflake, in ways that make sense to business users
- DThe data model that you create is exposed as a subject area that you can use build reports and dashboards.
13Variables in Data Modeler is allowed to store dynamic values and these variables can be used in data filters and expressions?
- ATrue
- BFalse
14Which two of these statements are true about Data Modeler?
- AYou can edit the data model even without locking it
- BYou must click on “Lock to edit” to make any changes
- CFor further changes you click Publish and keep lock
15Which two statement are false in regarding to Data Models?
- AYou can only export the data model through a snapshot. Individual data models cannot be exported to a JSON file
- BIndividual data models can be exported to a JSON file and the information imported on another service
- CIndividual data models can be exported to a XML file and the information imported on another service
16Which two statements are false about Advanced Analytics?
- AStatistical functions are required to be coded, before they can be used
- BStatistical functions are available on the UI with a few clicks
- CStatistical functions need Oracle Analytics Cloud Enterprise edition
- DStatistical functions are available on the expression editor to create calculated columns
17Which statement is True?
- ATrendline predicts the measure or business KPI over a time series
- BForecast predicts the measure or business KPI over a time series
18Select the appropriate statistical function to identify homogenous groups of data-points ?
- AOutlier
- BCluster
- CReference Line
- DForecast
19Which algorithms are available for cluster and outlier visuals? (2)
- AK-Means
- BSeasonal ARIMA
- CHierarchical Clustering
- DETS
20Which two statements are false about Explain?
- ARecognize Patterns and trends in your data
- BIt works on only attribute
- CInsights created by Explain, cannot be embedded in Project canvas
- DGenerate insights for influencers, prediction confidence, and anomalies
21Explain can be used on Subject Areas?
- ATrue
- BFalse
22Which two statements are false about Predictive Model?
- AYou can add the model to the project model dynamically by using Scenario
- BYou can create your training model without creating a data flow
- CPredictive Modelling is a feature available only in Professional edition
- DParameters can be fine tuned by analyst for the chosen ML Algorithm
23Which statement is false in regarding to OAC Service Name?
- AMust start with an ASCII letter (a to z or A to Z)
- BMustn't contain any other special characters
- CMustn't contain only ASCII letters or numbers
- DMust contain between 1 and 25 characters
- EMust be unique within the identity domain
24ML Model quality is available in Inspect - Quality for analyst to evaluate after the model is created?
- ATrue
- BFalse
25Which of these options in data wrangling function is not available for all data types?
- ARename
- BDuplicate
- CConvert to
- DConcatenate
- EGroup
26Can you create a new Analysis from more than one subject area?
- ATrue
- BFalse
27Which two objects can be saved in Catalog folder?
- ADashboards
- BForms
- CNamed Action
- DInline Action
28Which two are TRUE about Master View?
- AThe master column should be added as is prompted
- BThe master column can display on the section slider
- CThe master and detail view can be added to the same dashboard page
- DA master view contains a master column, where you set up the interaction that sends master-detail events on a channel
29Which statement is True?
- AYou can't link views such that one view drives changes in one or more other views
- BYou can link views such that one view drives changes in one or more other views
30Dashboard consists of only one page and one subpage page that display results of an Analysis?
- AFALSE
- BTRUE
31Which objects can be added to a Dashboard Page?
- AColumn, Section, Action Link, and Filter
- BColumn, Section, Action Link Menu, and Analyses
- CColumns, Sections, Filter, and Analyses
- DColumns, Action Link Menu, Folder, and Calculation
32Which statement is True?
- AIs it not possible to build many actions from the same interaction
- BIs it possible to build many actions from the same interaction
33Which statement is false related to Pixel-Perfect Data Modeler?
- ACan be reused
- BIs available in the Catalog
- CIt can connects to Subject Areas
- DCannot be reused
34You can install Day to Day Mobile app in which OS?
- AAndroid
- BWindows
- CApple
- DLinux
35Oracle Day by Day available in which edition? (2)
- AOracle Analytics Cloud Professional Edition
- BOracle Analytics Essbase
- COracle Analytics Cloud Enterprise Edition
- DOracle Business Intelligence
36What are the Application Roles needed to have to connect to Day by Day?
- ADV Consumer
- BBI Content Author
- CBI Consumer
- DDV Content Author
37When you create a ML Model, in which Inspect tab you will find the Generated Data or Virtual Data?
- ADetails
- BRelated
- CQuality
- DGeneral
- EAccess
38Execute Data Flow will run the data flow and save it?
- ATrue
- BFalse
39Data Blending is available in which Tab?
- ANarrate
- BData Diagram
- CVisualize
- DData Synchronization
40Exponential option in data wrangling function is available for which data type?
- ANumber
- BText
- CDate
41Which two statements are true in regarding to Catalog Manager?
- AYou can’t create an analysis to display catalog data
- BView and edit catalog objects in JSON
- CYou perform online and offline management of OAC Catalogs
- DView and edit catalog objects in Extensible Markup Language (XML)
42What is the criteria needed if you want to add Forecasting to your visualization?
- AVisualization should have a period column in none of its axes.
- BVisualization should have a period column in one of its axes.
- CVisualization should have a period column in both of its axes.
43Which statement is not true in regarding to Data flow?
- ABlending two tables are only available in Data Flow
- BYou can use Data Flow to create a new ML Model
- CYou can use Data Flow to create curated data set
- DYou can use Data Flow to create sentiment analysis
44Which statement is True?
- AYou can't create your own custom palette in visualizations
- BYou can create your own custom palette in visualizations
45We use Expression filter if we need more control on functions and its parameter and it's useful for Data science and statistics?
- AFALSE
- BTRUE
46Which two statement are True?
- AExplain both Measure and Attribute produce Basic Fact, Key Drivers Segment and Anomalies
- BExplain Attribute produce Basic Fact, Key Drivers Segment and Anomalies
- CExplain Measure produce Basic Fact and Anomalies
- DIt can be used only for measure columns.
47You received a new requirement to create a composite (stack) visualization containing Pie and Bar charts.How can achieve it?
- AYou can’t stack two visuals
- BChange the layout canvas properties to FreeForm and add one over the other, however they will not be stacked or both clickable at the same time
- CChoose the Pie-Bar visual type from visualizations panel
- DChange the layout canvas properties to Auto fit and add one over the other, however they will not be stacked or both clickable at the same time
48Which of these product is not part of OAC?
- AReport Builder
- BPixel Perfect Reporting
- CAnalysis and Dashboards
- DOracle Analytics Cloud
49Data Sync enable you to schedule data loads into only Oracle Database?
- AFALSE
- BTRUE
50Source Views in Data Modeler can be used for which purposes? (Choose three answers)
- AWhen using a single table as a source for more than one dimension table
- BJoin many tables to be one table
- CPerform pre-aggregation calculations
- DCreate Variables
- ECreate ML Models
Information
- Description
- Certificado PMP (Dirección de Proyectos) Tecnología Quiz on 100-150, created by Benjamin Fernandez on 12/10/2025.
- Author
- Benjamin Fernandez
- Language
- Español
- Views
- 26
- History
- Created on 12 Oct 2025 · updated on 25 Oct 2025
- Tags
- Rating
- No ratings yet Rate this quiz