Ora

Which options can't you connect to when you create a connection through the Oracle Applications out of the box connector?. Oracle Transaction BI Subject Area. Oracle Transaction BI Analysis. Logical SQL against the Subject Area's exposed by the Oracle Transactional Business Intelligence Layer. Oracle Database.

Which statement is false regarding to Oracle Analytics Data Flow?. It's a user-friendly lightweight transformation tool. It provides a clean and powerful interface to a business user to cleans and transform your data. Is a visual representation document of data transformations. Recognize Patterns and trends in your data.

When one data flow failed within the sequence, select the true action happened. All the changes to the Data Sets done in the sequence are rolled back. You must add a trigger to handle the fault. It will work successfully in the next time. All of the above.

Which options make filtering? (Select three answers). Sorting. Drill Down. Keep Selected. Remove Selected. Highlight.

Which external can't be added to OAC? (select only one). csv. xls. zip. txt.

The default OCPU limit for professional and Enterprise edition when you sign up is?. 4 OCPU. 2 OCPU. 10 OCPU. 16 OCPU.

Which statement is false about migrating data models to the Cloud?. You must use Oracle BI Enterprise Edition 11.1.1.7 or later. You check global consistency and update connection pools to point to the cloud. You can use Oracle Developer Tool if model changes are required. You can move the RPD back to on premises.

Which two statements are false about OAC external sources characteristics?. Data source files should be .xls/xlsx, txt or .CSV extension. Data source files should be iso or html extension. Data source either extends a dimension or extends facts. Hierarchies can be defined in external data sources.

Which Operating system are not supported for Oracle Gateway? (Choose two). Oracle Linux. Mac OS. Oracle Solaris. Microsoft Windows. Android.

Advanced Filtering can be applied through?. Expression Filters. Extract Filter. Presentation Filter. Range Filters.

Which statement is false in regarding to Visualizations?. Custom Palette cannot be created in Visualizations. You can create your own custom palette in Visualizations. Custom Plate extension is skd. You can add your custom plate through Console - Extension.

Which statement is false in regarding to Data modeler?. Multiple users can use Data Modeler at the same time. Variables returns only single value. You can model data from various source types, such as star and snowflake, in ways that make sense to business users. The data model that you create is exposed as a subject area that you can use build reports and dashboards.

Variables in Data Modeler is allowed to store dynamic values and these variables can be used in data filters and expressions?. FALSE. TRUE.

Which two of these statements are true about Data Modeler?. You can edit the data model even without locking it. You must click on "Lock to edit" to make any changes. For further changes you click Publish and keep lock.

Which two statement are false in regarding to Data Models?. You can only export the data model through a snapshot. Individual data models cannot be exported to a JSON file. Individual data models can be exported to a JSON file and the information imported on another service. Individual data models can be exported to a XML file and the information imported on another service.

Which two statements are false about Advanced Analytics?. Statistical functions are required to be coded before they can be used. Statistical functions are available on the UI with a few clicks. Statistical functions need Oracle Analytics Cloud Enterprise edition. Statistical functions are available on the expression editor to create calculated columns.

Which statement is True?. Trendline predicts the measure or business KPI over a time series. Forecast predicts the measure or business KPI over a time series.

Select the appropriate statistical function to identify homogenous groups of data-points. Outlier. Cluster. Reference Line. Forecast.

Which algorithms are available for cluster and outlier visuals? (Choose two). K-Means. Seasonal ARIMA. Hierarchical Clustering. ETS.

Which two statements are false about Explain?. Recognize Patterns and trends in your data. It works only on attribute. Insights created by Explain, cannot be embedded in Project canvas. Generate insights for influencers, prediction confidence, and anomalies.

Explain can be used on Subject Areas?. FALSE. TRUE.

Insights generated by Explain are dependent on Column type attribute/metric that you choose?. FALSE. TRUE.

Which two statements are false about Predictive Model?. You can add the model to the project model dynamically by using Scenario. You can create your training model without creating a data flow. Predictive Modelling is a feature available only in Professional edition. Parameters can be fine tuned by analyst for the chosen ML Algorithm.

ML Model quality is available in Inspect - Quality for analyst to evaluate after the model is created?. FALSE. TRUE.

Which of these options in data wrangling function is not available for all data types?. Rename. Duplicate. Convert to. Concatenate. Group.

Can you create a new Analysis from more than one subject area?. FALSE. TRUE.

Which two objects can be saved in Catalog folder?. Dashboards. Forms. Name Action. Inline Action.

Which two are TRUE about Master View?. The master column should be added as is prompted. The master column can display on the section slider. The master and detail view can be added to the same dashboard page. A master view contains a master column, where you set up the interaction that sends master-detail events on a channel.

Which statement is True?. You can't link views such that one view drives changes in one or more other views. You can link views such that one view drives changes in one or more other views.

Dashboard consists of only one page and one subpage page that display results of an Analysis?. FALSE. TRUE.

Which objects can be added to a Dashboard Page?. Column, Section, Action Link, and Filter. Column, Section, Action Link Menu, and Analyses. Columns, Sections, Filter, and Analyses. Columns, Action Link Menu, Folder, and Calculation.

Which statement is True?. It is not possible to build many actions from the same interaction. It is possible to build many actions from the same interaction.

Which statement is false related to Pixel-Perfect Data Modeler?. Can be reused. Is available in the Catalog. It can connects to Subject Areas. Cannot be reused.

Oracle Day by Day available in which edition? (Choose two). Oracle Analytics Cloud Professional Edition. Oracle Analytics Essbase. Oracle Analytics Cloud Enterprise Edition. Oracle Business Intelligence.

What are the Application Roles needed to have to connect to Day by Day? (Choose two). DV Consumer. BI Content Author. BI Consumer. DV Content Author.

When you create a ML Model, in which Inspect tab you will find the Generated Data or Virtual Data?. Details. Related. Quality. General. Access.

Execute Data Flow will run the data flow and save it?. FALSE. TRUE.

Data Blending is available in which Tab?. Narrate. Data Diagram. Visualize. Data Synchronization.

You can install Day by Day Mobile app in which OS? (Choose two). Android. Windows. Apple. Linux.

Exponential option in data wrangling function is available for which data type?. Number. Text. Date.

Which two statements are true in regarding to Catalog Manager?. You can't create an analysis to display catalog data. View and edit catalog objects in JSON. You perform online and offline management of OAC Catalogs. View and edit catalog objects in Extensible Markup Language (XML).

What is the criteria needed if you want to add Forecasting to your visualization?. Visualization should have a period column in none of its axes. Visualization should have a period column in one of its axes. Visualization should have a period column in both of its axes.

Which statement is not true in regarding to Data flow?. Blending two tables are only available in Data Flow. You can use Data Flow to create a new ML Model. You can use Data Flow to create curated data set. You can use Data Flow to create sentiment analysis.

Which statement is True?. You can't create your own custom palette in visualizations. You can create your own custom palette in visualizations.

We use Expression filter if we need more control on functions and its parameter and it's useful for Data science and statistics?. FALSE. TRUE.

Which two statement are True?. Explain both Measure and Attribute produce Basic Fact, Key Drivers Segment and Anomalies. Explain Attribute produce Basic Fact, Key Drivers Segment and Anomalies. Explain Measure produce Basic Fact and Anomalies. It can be used only for measure columns.

You received a new requirement to create a composite (stack) visualization containing Pie and Bar charts. How can achieve it?. You can't stack two visuals. Change 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. Choose the Pie-Bar visual type from visualizations panel. Change 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.

Which of these product is not part of OAC?. Report Builder. Pixel Perfect Reporting. Analysis and Dashboards. Oracle Analytics Cloud.

Data Sync enable you to schedule data loads into only Oracle Database?. FALSE. TRUE.

Source Views in Data Modeler can be used for which purposes? (Choose three answers). When using a single table as a source for more than one dimension table. Join many tables to be one table. Perform pre-aggregation calculations. Create Variables. Create ML Models.

Which one is not part of Export project content?. Permissions. Connection credentials. Data. Dashboard.

In which two Oracle Cloud Infrastructure (OCI) - Autonomous Database Tab you can download the wallet?. Scale Up/Down. DB Connection. Service Console. Performance Hub.

A Narrate can have multiple story pages?. TRUE. FALSE.

Filter Can be applied on only one canvases?. FALSE. TRUE.

Brushing data refers to the Synchronization of Visualizations?. FALSE. TRUE.

Same visualizations are available across following services? (Choose three answers). Oracle BDCS. Oracle BI 12c. Oracle BDPCS. Oracle DVCS. Oracle BICS.

When you add data elements to a canvases, A visualization will automatically be created?. TRUE. FALSE.

When using the explain for Measure, you can gather insights by? (Choose two). Disparities. Segments. Key Drivers. Basic Facts. Anomalies.

Can you create your own custom plate in visualizations and save it in Console - Maps as xml extension?. TRUE. FALSE.

When you create snapshot and choose "Every things", what it will include? (Choose three). Connection credentials. Permissions. Rest API. Data. DB Dump.

Which extension is for importing a project?. Json. exe. xml. dva.

Which Advanced Analytics you can add if you have a visualization with one period column in one of its axes?. Trend Line. Cluster. Reference Line. Forecast. All of the above.

Which model is not part of train model available in data flows?. Binary Classifier. Multi-Classifier. Numeric Prediction. Clustering. Anomalies Detections.

From which option you can assign the ownership of an item that you created to others?. Administrator. Permissions. Prosperities. Console.

You can modify Data set Name, Check data elements, Enable Index Data set for Searching and check permissions from?. Duplicate. Setting. Inspect. Open.

Which filter only accept multiple data elements?. Relative Time. Expression Filters. Range Number. Top/Bottom.

You can execute the Data Flow without save it?. FALSE. TRUE.

You can share story using the PDF and include? (Choose three answers). All Canvases. Active Canvases. Active Page. All story Pages. Active Visual.

What happen when you remove a data set from Project?. You can't remove a data set from project. It will be deleted from project and keep it on the OAC Data objects. It will be deleted from project and from on the OAC Data objects as well. Nothing will happen.

Bin option in data wrangling function is available for which data type?. Boolean. Number. Date. Text.

Which option can be done in a story and can't be done in Canvases?. Export. Print. Choose to hide or show visuals. Undo/Redo.

You want to create a new connection for Oracle Autonomous Data Warehouse through DV, which step is not required?. Upload data gateway key file. Select Service Name. Upload Client credentials {wallet.zip file}. Insert User Name/Password. Download wallet.zip file from OCI.

Oracle Analytics Publisher is suited for? (Select three answers). Creating dashboards. Connect to a variety of data sources including BI Subject Areas, BI Analysis and RPD. Schedule your report to run once or as a recurring job. Create and Delivering highly formatted business documents such as Invoices, Purchase Orders and Dunning Letters.

When you add a data elements to a canvases, you will be prompted to choose a visualization type?. FALSE. TRUE.

You are using Data Gateway; the key is missing, how can you provide it?. From BI Publisher dataset. From Data Gateway Configuration page. From Classic administrator page. From OCI.

When you search for a date attribute using search field? (Select three answers). Search in your local setting language. Date format is Year-Month-Date. You can only search for project name. When you enter criteria in the search field, what displays in the drop-down list of suggestions can differ depending upon your locale setting.

Choose what is NOT true about instant mobile access that the DVCS provides?. No coding is required to view the content on mobile device. Interface is optimized for the layout of mobile devices. You can enhance the existing visuals on your mobile device. You can just view the content on your mobile device.

when you download the snapshot from console, What is the extension file?. bar. dva. Json. rpd.

A sequence run multiple data flow as a single transaction?. TRUE. FALSE.

You need to connect to Oracle Fusion Applications and create a new data set, how you can accomplish it?. By installing the OAS on the same server. By inserting Host link, User name and password and type of Authentication. By uploading key wallet file. By installing gateway and connect through it.

OAC projects contains which tabs? (Choose three). Row Data. Narrate. Catalog. Visualize. Prepare.

OCI is available as part of OAS service?. TRUE. FALSE.

Which three of the following are use cases for Data Flows? (Choose three). Apply Machine Learning training models. Create Sequence. Create Machine Learning training models. Curate Data Sets.

Which type of Data Actions you need to connect to Oracle Analytics BI Publisher Reports?. URL Navigation. Analytics Link. HTTP API. Publish Events.

To change the Scope of dashboard prompt from Dashboard to page through?. Column Properties. Dashboard Prompt Properties. Format Section. Dashboard Properties.

What is the extension file when Archive object from catalog?. xml. exe. Json. catalog.

What are the mandatory fields for Hierarchy in Data Modeler? (Select three). Key Column. Display Column. Surrogate Key. Level Name. Primary key.

Which OAC edition has the Day By Day mobile app, OAC data modeler and OAC data gateway?. Oracle Analytics Professional. Oracle Analytics Essbase. Oracle Business Intelligence Enterprise Application. Oracle Analytics Cloud Enterprise.

The maximum size limit for txt, xls and csv data files that I want to upload?. 100 MB. 1024 MB. 250 MB. 15 MB.

Which of the following can't be defined as external data set?. Hierarchies. Measures. Attribute.

Which objects can't be added to a dashboard?. Folder. Embedded Content. Action Link Menu. Filter. Alert Section.

The explain feature only can be accessed by Right click on either Measure or Attribute?. FALSE. TRUE.

The default query mode for a database table in the create source dialog box is Live?. TRUE. FALSE.

When create a snapshot it includes only one option "Every Thing"?. FALSE. TRUE.

Which two are not part of the predefined application Roles? (Choose two). BI Content author. DV Data Load Author. BI consumer. DV Data modeler Author. BI Service Administrator.

Which of the following are not part of operating systems that can access Oracle Data Visualization Cloud Service? (Select two answers). Kaios. Tizen. Windows. IOS. Andriod.

Which statements are true in regarding to Scenario?. Scenario is useful to run multiple data flow as a single transaction. You can't add the scenario directly to the project. You should create a data flow to use Scenario. You can add the scenario directly to the project.

When you create a new data set with database connection, the default query mode for table is Cached?. FALSE. TRUE.

What is automatic correlating of data in oracle DVCS?. Selecting data in one visualization highlights related data in others. Automatic creation of visualization based on scenario. blending of data.

Column name in the uploaded excel file should be unique?. TRUE. FALSE.