Quiz
Test1
Crie uma conta grátis para terminar este quiz
Salve seu progresso e veja sua nota final.
Já tem uma conta? Inicie sessão
Perguntas do quiz (50)
1You have four columns related to Stock (Date, start time, End Time and Amount) which columns you can’t remove it to create your trend analysis?
- AEnd Time
- BDate
- CYou can't remove any column
- DStart Time
2The key is missing from Gateway, what do you need to upload it to connect into on-premis DB?
- AClick Generate Key, then click Copy to Clipboard -> In the URL field, enter the Oracle Analytics Cloud URL -> Click Add -> The agent is registered -> Start the Data Gateway Configuration page Go to the OAC Remote Data Connectivity page in OAC -> Paste the key generated from the Agent definition screen into the Public Key
- BStart the Data Gateway Configuration page -> In the URL field, enter the Oracle Analytics Cloud URL Click Generate Key, then click Copy to Clipboard -> Go to the OAC Remote Data Connectivity page in OAC -> Click Add -> Paste the key generated from the Agent definition screen into the Public Key The agent is registered
3How you describe the trend line? (Select two answers)
- AIt predicts the measure or business KPI over a time series
- BIt helps you focus on a range/band and highlight data points that fall in the band or out of the band
- CIt shows how one measure or business KPI relates with the other
- DHighlights a general pattern or direction of data when seen in relation to a time series
4You have transaction date and transaction amount, you create a line chart, which one is the measure or Y- Access?
- ABoth
- BTransaction Date
- CTransaction amount
5You have three values (Pass, Fail, Nature) By which train algorithm you can implement it?
- ATrain Clustering
- BTrain Binary Classifier
- CTrain Multi Classifier
6By which types of filters you can implement all date elements?
- AExtract
- BList
- CExpression
- DRange
7You have lots of attributes in your data set and over 1 million records, how can you recognize more about your data, by using?
- ADrilling
- BFilter
- CSelect
8What are the steps you follow to create a new Map Layer in OAC?
- AFrom the OAC console, go to maps and drag and drop a JSON file
- BFrom the OAC console, go to maps and drag and drop a geoJSON file
- CFrom the map visualization select map properties, new layer and drag geoJSON file
9You have around 35 columns in your data set, there 4 columns the values are close to each other. You are planning to create a new train, what is the impact if you remove three of the them?
- AThese columns have the lowest impact of the model
- BNothing will be changed
- CThese columns have the highest impact on the model (they are strongly correlated)
10Which statement is true when migrating content from Oracle BI Enterprise Edition 12c to Oracle Analytics Cloud?
- A: You can migrate a snapshot from Oracle BI Enterprise Edition 12c to Oracle Analytics Cloud
- BBoth the Oracle BI Enterprise Edition 12c Data Model and the Catalog must be migrated to Oracle Analytics Cloud. They cannot be migrated independently
- CAt this time there is no option to migrate Oracle BI Enterprise Edition content to Oracle Analytics Cloud.
11If you take an insight to keep track the visualization from narrate, how you can make sure that it contains common data in all users?
- AExport the whole project
- BYou can’t keep track the visualization
- CAll users should have the same permission
12How can you implement filter X>= 10000?
- AExpression filter
- BRange Filter
- CList Filter
13What can you add to Narrate? (Choose three answer)
- AComments
- BInsights
- CPage Title
- DNote
- EDescription
14Which statement is false with respect to the ability to adjust visualization properties when placing multiple visuals on a canvas?
- AHide a visual by right-clicking the canvas and selecting Hide from the drop-down menu
- BHide a visual by right-clicking the canvas and selecting Hide from the top menu
- CDuplicate a visual that is on the canvas, changing the visual type in the duplicated visual.
15Can you be stacked visualize one on top of another in a canvas?
- ANo
- BYes
16If you have three columns and you use SLA in the search field: Day1, Day2 by Day3 how it will be displayed in the report or charts?
- AScatter plot
- BBar Char
- CPie Char
17What is true about Analysis ownership?
- AWhen you create content in the catalog you can grant ownership of the content to the others. Also, a user who has been granted the proper privileges can take ownership of content.
- BYou can’t grant the ownership of the content to the others
18Your customer is looking to get a better understanding of their data, in particular how Oracle Analytics Cloud can help them gain a competitive advantage. Which two tasks can help them achieve their goals?
- ACreate a data flow to highlight the interesting data
- BCreate a data story by using the narrate functionality to present to their management.
- CPerform analysis on the data by using trend lines, clustering, and outlier detection to offer new perspectives.
- DImport the data Into Oracle Analytics Cloud and use the Data Tile functionality in the Prepare section of the product. Use the resulting combination of visualization types to determine relationships and avenues for further exploration.
19If you have 1000 and 2000 in a column A and you create a new column B with sum(A). what is the result in the new column?
- A3000 3000
- B1000 2000
- C2000 1000
20Can you create an analysis from 2 different business models?
- ANo
- BYes
21Which two statements are true about the Data Sync functionality?
- ALoad Automation for Data Sync: via native scheduler, CLI and SQL/File interface
- BData Sync can create and manage surrogate keys in target tables Data Sync is the only mechanism available in Oracle Analytics Cloud Standard Edition for loading data Into DBaaS tables
- CData Sync cannot load incremental source insertions and updates; only full refresh loads are supported.
- DTo manage extractions and loads from cloud-based sources, Data Sync can invoke the REST APIs of the Oracle Database Cloud Service as well as the Oracle Business Intelligence Cloud Service.
22What is the ML algorithm that needed to detect the Fraud?
- AMulti-Classification
- BAnomaly Detection
- CBinary Classification
23What is true about BI Search?
- AWhen you enter criteria in the search field, what displays in the drop-down list of suggestions can differ depending upon your locale setting
- BYou can search for project or elements (Attribute or Measure)
- CSearch in your local setting language
- DDate format Year-Month-Date
- EAll of them
24Oracle Analytics Cloud is related to which Service Models?
- APaas
- BIaas
- CSaas
- DCaas
25You have Dashboard prompt works in two pages and isn’t working in the other two pages, what is the reason? (Select two answers)
- AThere is a protect filter in some pages
- BThere is “is prompted” filter defined in all pages
- CSelection step is used.
- DThere is no “is prompted” filter defined in some pages
26You create a data set, data flow, use train, this is related to which process?
- AData Preparation
- BEvaluation
- CModelling
- DData Understanding
27Which statement is true about migrating BI Content and Users?
- AYou can only use the WebLogic embedded LDAP server which allows you to export data visualizations, reports, dashboards, and user Information and import them to another environment by using a WebLogic embedded LDAP server.
- BIf you have Oracle Analytics Cloud services that use the WebLogic embedded LDAP server, you can export data visualizations, reports, dashboards, and user information and import them to another environment by using a WebLogic embedded LDAP server
- CIf you have Oracle Analytics Cloud services that use the WebLogic embedded LDAP server, you can only export data visualizations, reports and dashboards, and import them to another environment by using a WebLogic embedded LDAP server. User information must be exported separately.
28By using BI Ask, you entered Values1(Days), Value2(Days) by Value3(Days). How it will be implemented in the scatter plot chart?
- AX-Axis: Value1(Days) Y-Axis: Value2(Days) Value3(Days)
- BX-Axis: Value1(Days) Value2(Days) Y-Axis: Value3(Days)
- CX-Axis: Value1(Days) Y-Axis: Value2(Days) Color: Value3(Days)
29How can you hide the report in Analytics?
- AGo to Catalog -> More -> Permissions -> Hidden
- BGo To My Folder -> Properties -> Hidden
- CGo to Catalog -> More -> Properties -> Hidden
30What are two incorrect steps when creating pixel perfect reports with Bl Publisher?
- AGenerate and save to a folder in the Presentation Catalog a sample set of data that can be used for configuring and testing the report
- BTest connections between BI Publisher and configured sources using Oracle Fusion Middleware Control
- CDefine a data model to set the business view of the data, join data sets, and create custom measures.
- DCreate connections to sources, some of which include Oracle 10g/11g, Oracle BI Server, JDBC, and MS SQL Server 2005/2008
31What are the steps you follow to download client credentials from the Autonomous Database Service Console?
- AFrom the Service Console click the Administration link -> Click Download Client Credentials (Wallet) On the Download Client Credentials (Wallet) page, enter a wallet password in the Password field and confirm the password in the Confirm Password field -> Click Download to save the client security credentials zip file. By default, the filename is: Wallet_databasename.zip
- BClick Download to save the client security credentials zip file. By default, the filename is: Wallet_databasename.zip -> From the Service Console click the Administration link On the Download Client Credentials (Wallet) page, enter a wallet password in the Password field and confirm the password in the Confirm Password field -> Click Download Client Credentials (Wallet)
32What is the most likely that the user creates a Narrate?
- ATo print the visuals by PDF format
- BTo present the story through Day-by-Day application for the management and help in Decision support
- CTo migrate it back to OBIEE
- DTo add a customer note
33You have BI publisher ready to use. How can you audit it? (choose three answers)
- AEnable Monitor and Audit Flag and set Audit Level to Medium
- BRestrict access to this Audit data source to intended users
- CCreate a JDBC data source with JDBC name as jdbc/ AuditViewDataSource
- DCreate a JNDI data source with JNDI name as jdbc/ AuditViewDataSource
- EAdd the report to dashboard
34What are the steps to you follow to download the Wallet file?
- ANavigate to the Autonomous Database details page -> Click Download to save the client security credentials zip file -> In the Download Wallet dialog, enter a wallet password in the Password field and confirm the password in the Confirm Password -> On the Database Connection page select the Wallet Type -> Click DB Connection
- BNavigate to the Autonomous Database details page -> Click DB Connection -> On the Database Connection page select the Wallet -> Click Download Wallet -> In the Download Wallet dialog, enter a wallet password in the Password field and confirm the password in the Confirm Password field -> Click Download to save the client security credentials zip file
35After you creating the Data flow, where can you save the output of it? (Select two)
- ADatabase
- BCatalog
- CData Set
- DYou can’t save it
36You have created a visualization of revenue data by date (at day level) for the last three years. What functionality should you use to create a prediction of ongoing revenue throughout the next three months?
- AAdd a forecast with a forward period of 3.
- BAdd a forecast with a forward period of approximately 90.
- CCreate a custom calculation based on the revenue metric
37Which one is true regarding to manage the cache?
- AQuery WHERE clause constrains need to be equivalent to the cached result or to a subset of the result
- BJoin conditions must be equivalent
- CAll the columns in the SELECT list of a new query must exist in the cached query, or they must be able to be calculated from the columns in the query
- DAll of them
- EQueries that request an aggregated level of information can use cached result at a lower level of aggregation
38What are the forecast model types?
- AHierarchal Cluster
- BAREMA, Season AREMA and ETS
- CARIMA, Season ARIMA and ETS
39Oracle Analytics Cloud offers several visualization options for presenting query results. How do you explicitly invoke "best visualization" in Oracle Analytics Cloud?
- ASelect the desired data elements from the Data Elements pane, right-click and select "Create Best Visualization" from the drop-down menu.
- BSelect the desired data elements from the Data Elements pane and drag them onto the Best Visualization zone in the Explore pane
- CDrag an entire Data Set from the Data Elements pane onto the Data Visualization canvas and let the tool determine the best visualization
40You create a custom Application role, after that you added it to DV Content Author. Why you can’t modify the Sales data model?
- ADV Content Author is an administrator
- BBI Data Model Author has lower role of DV Content Author
- CBI Data Model Author has higher role of DV Content Author
41You upload a new extension throw Console - Upload Extension - ZIP File, how It will work?
- AConsole – Users and roles
- BConsole - Maps
- CRefresh the page
- DRestart Data Visualization Instance
42How should you determine the accuracy of a machine learning model created in Oracle Analytics Cloud?
- ACreate a data flow that Includes a histogram
- BUse the debug option in the data flow where the model was created
- COpen the Inspect dialog for a given machine learning model and review the F1 score
43You want to create time Dimension by wizard, select the true statement?
- AWhen you create a time dimension, the Create Time Dimension wizard creates a table in the database, populates it with time data, creates a corresponding time dimension table in the data model, and creates a time hierarchy
- BYou should create the Date table first in Database
- CData modeler will generate SQL statement that conflict changes to Database
44You have dashboard, you need to enable dashboard Report link in all pages and deny it from specific analysis, what are the steps you have to follow?
- ATo change it for specific analysis -> Setting Gear -> Edit Dashboard -> Specific analysis XYZ (Properties) -> Report Links
- BEnable dashboard Report link for all pages in the dashboard from -> Setting Gear -> Edit Dashboard -> Gear Setting -> Dashboard Properties -> dashboard Report link
- CYou can’t do it
- DEnable dashboard Report link for all pages in the dashboard from -> Setting Gear -> Edit Dashboard -> Gear Setting -> Dashboard Properties -> dashboard Report link
AND
To change it for specific analysis -> Setting Gear -> Edit Dashboard -> Specific analysis XYZ (Properties) -
> Report Links
45Which of the following you can modify while creating a custom hierarchy?
- ALevel Name, Key Name and Display Name
- BLevel Name, Key Column, Hierarchy name and Display Column
- CHierarchy name and Dimension Name
46How can you make catalog read only?
- AUn Archive
- BBy enabling Maintenance Mode, set on the Presentation Services Administration page.
- CGo to Catalog -> More -> Properties
47You've been given a spreadsheet of employee attrition data and have been asked to determine which are the most important factors that contribute to whether an employee is likely to leave their position. What is the quickest way to start this analysis after uploading the data to Oracle Analytics Cloud?
- AUse Outlier identification
- BCalculate a forecast of the probability of attrition.
- CUse the Explain option on the attrition attribute
48How can Oracle Analytics Cloud be used to visualize group relationships between data points on a particular canvas?
- AUse a variety of colors for each data point
- BCreate a cluster with a suitable number of groups for the specific analysis
- CVisualize the data by using a network chart
49You have to 2 Data flows; one populates Values and the other populate text. How can you populate the fact table?
- ABy creating synonyms
- BBy creating sequence, add that first dataflow that populate text (Dimension) and then the other data flow that populate values (Fact)
- CBy creating single data flow with 2 branches
50What is the required service you need to create an OAC instance?
- AOracle Autonomous
- BOracle Analytics Cloud
- COracle Business Intelligence
Informações
- Descrição
- Quiz sobre Test1, criado por Santiago García B. em 11-10-2025.
- Autor
- Santiago García B.
- Idioma
- Español
- Visualizações
- 23
- Histórico
- Criado em 11 out 2025 · atualizado em 12 out 2025
- Etiquetas
- Avaliação
- Ainda sem avaliações Avalie este quiz