1Z0-1041-23 Sample Questions
Old You are migrating 11.1.2.4.nnn On-Premises Essbase cubes to the cloud service. Which four steps should you perform? A. Convert all applications and associated artifacts to non-Unicode mode before export. B. Correct any partition settings in the Life Cycle Management exported .zip file. C. Install and execute the Life Cycle Management utility to export the required Essbase source application. D. Import a .zip file using the Command Line Interface tool. E. Convert all application-level substitution variables to server-level variables before export. F. Convert all application-level files and artifacts to database-level files and artifacts before export.
Answer(s): B,C,D,E Reference: https://blogs.perficient.com/2018/04/11/migrating-essbase-cubes-oracle-analytics-cloud/
Old Your customer is using Oracle Analytics Cloud - Essbase Command Line Interface (CL1) to perform administrative actions on Oracle Analytics Cloud - Essbase.Which are three valid options for executing the DataLoad command? A. a dimension file B. a data file and an optional rules file C. a saved local connection using a secure URL D. a rules file with a username and password E. a stream option referencing a saved local connection
Answer(s): B,D,E
Old Which statement is true when migrating content from Oracle BI Enterprise Edition 12c to Oracle Analytics Cloud? A. At this time there is no option to migrate Oracle BI Enterprise Edition llg content to Oracle Analytics Cloud. B. Both the Oracle BI Enterprise Edition 12c Data Model and the Catalog must be migrated to Oracle Analytics Cloud. They cannot be migrated independently. C. You can migrate a snapshot from Oracle BI Enterprise Edition 12c to Oracle Analytics Cloud. D. You can only migrate an Oracle BI Enterprise Edition 12c Data Model to Oracle Analytics Cloud. Catalog migration is not allowed.
Answer(s): C
Old Before you create an Oracle Analytics Cloud Standard Edition service, you must check to make sure you are subscribed to the required services. Which combination of services is required? A. Oracle Database Cloud Service; Oracle Cloud Infrastructure Object Storage Classic; Oracle Big Data Cloud B. Oracle Cloud Infrastructure Compute Classic; Oracle Cloud Infrastructure Object Storage Classic; Oracle Identity Cloud Service (Oracle Universal Credits required) C. Oracle Cloud Infrastructure Compute Classic; Oracle Database Cloud Service; Oracle Cloud Infrastructure Object Storage Classic; Oracle Identity Cloud Service (Oracle Universal Credits required); Oracle Big Data Cloud D. Oracle Cloud Infrastructure Compute Classic; Oracle Database Cloud Service; Oracle Cloud Infrastructure Object Storage Classic; Oracle Identity Cloud Service (Oracle Universal Credits required)
Answer(s): C Reference: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsam/administering-oracleanalytics-cloud-user-managed-environment.pdf (14)
Old DUP! What does the band inside a box plot visualization represent? A. The standard deviation of the data B. The average of the data C. The maximum of the data D. The median of the data
Answer(s): C Reference: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/visualizing-data-and-buildingreports- oracle-analytics-cloud.pdf
Old Which option is false with respect to the Presentation Catalog? A. Catalog Manager is a client administration tool that can be used to view and manage the Presentation Catalog. B. Object permissions for Analyses and Prompts can be archived along with the object in the catalog. C. Multiple objects can be archived into a single file. D. To prevent corruption of the catalog, storage of objects of different types must be segregated into their own folders.
Answer(s): D
A compound layout contains Title and Pivot Table by default if you add attribute and measures to the Criteria? A. FALSE B. TRUE
Correct Answer: A
Filter can be applied only in a single canvases? A. FALSE B. TRUE
Correct Answer: A
Old Which three options are correct about application workbooks? A. Worksheets can be modified by using the Cube Designer wizard. B. Worksheets cannot be modified directly in Excel. C. Application workbooks support the generation reference dimension build method. D. Multiple dimensions can be placed on a single worksheet. E. Application workbooks can have data load worksheets and calculation worksheets.
Answer(s): A,C,E
Old What are the two commonly used dimensional modeling schemas? A. Star B. Sun C. Moon D. Snowflake
Answer(s): A,D
Old What is a typical relationship between levels in a dimension hierarchy going from top to bottom? A. Many to Many Relationship B. One to Many Relationship C. Zero Cardinality D. Multiple Relationship
Answer(s): B
Old What should you use to make sure that the model you created is correct? A. Data Checker icon B. Validate Icon C. DB Sync Icon D. Correct icon
Answer(s): B
Old Which subscription do you need to begin using Oracle Analytics Cloud? A. Oracle Big Data Cloud Service B. Oracle Cloud Infrastructure Compute Classic C. Oracle Business Intelligence Foundation Service D. Oracle Analytics Software as a Service
Answer(s): B Reference: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsam/getting-startedadministration.html#GUID-19731504-AD47-43C5-87C1-E8E4E81E7997
Old How can Oracle Analytics Cloud be used to visualize group relationships between data points on a particular canvas? A. Use a variety of colors for each data point. B. Create a cluster with a suitable number of groups for the specific analysis. C. Use a combination of a tree diagram and a trellis visualization. D. Visualize the data by using a network chart.
Answer(s): B Reference: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/visualizing-data-andbuilding- reports-oracle-analytics-cloud.pdf
Old Which two statements are true about the Data Sync functionality? A. Data Sync can create and manage surrogate keys in target tables. B. Data Sync is the only mechanism available in Oracle Analytics Cloud Standard Edition for loading data Into DBaaS tables. To manage extractions and loads from cloud-based sources, C. Data Sync can invoke the REST APIs of the Oracle Database Cloud Service as well as the Oracle Business Intelligence Cloud Service. D. Data Sync cannot load incremental source insertions and updates; only full refresh loads are supported.
Answer(s): B,C
Old A customer built an Essbase cube (Block Storage) with six dimensions. At a later stage, a few cube settings were updated and new members were added manually. Based on new requirements from users, the customer wants to add a new dimension to the existing cube. The administrator will be using the Cube Designer extension in SmartVlew to make the updates. How can the customer update the cube incrementally while retaining any previous changes that were applied manually? A. Previous changes applied manually in cloud service cannot be retained while using Cube Designer. B. A new dimension cannot be added to an existing cube using Cube Designer. C. In Cube Designer: 1. Export the cube to the application workbook. 2. Select "From Sheet" to populate the wizard with contents of the application workbook. 3. Add a new dimension. 4. Select "To Sheet" to propagate the changes to the application workbook. 5. Add members in the dimension worksheet. 6. Finally, select Update Cube from the build options. D. In Cube Designer: 1. Export the cube to the application workbook. 2. Select "From Sheet" to populate the wizard with contents of the application workbook. 3. Add a new dimension. 4. Select "To
Answer(s): C
Old A virtual machine In Compute Classic, created resources defined by a shape is called . A. Orchestration B. Private Gateway C. Image D. Instance
Answer(s): C
Old How should you determine the accuracy of a machine learning model created in Oracle Analytics Cloud? A. Open the Inspect dialog for a given machine learning model and review the F1 score. B. Run the machine learning model with various filter values applied. C. Create a data flow that Includes a histogram. D. Use the debug option in the data flow where the model was created.
Answer(s): C
Old The extensive palette of visualization options delivered with Oracle Analytics Cloud can be extended with custom plugins. What option is false about implementing custom visualization plugins? A. The bicreateplugin script, provided with Oracle Analytics Cloud, can be used to create a skeleton visualization to facilitate custom development. B. Oracle Analytics Cloud provides a Software Development Kit (SDK) to enable builds of custom plugins. C. To be implemented, custom plugins must be deployed in the Bi_HOME\Analytics\src\customVi2 directory and BI Services need to be restarted. D. Plugins for rendering sophisticated visuals can be downloaded from the Oracle Data Visualization Library.
Answer(s): C
Old Which is not a step that can be followed to create a Story? A. Create and position annotations on the canvas as desired. B. Capture a story insight from one or more Visualization canvases in a project by navigating from Visualize to Narrate and dragging the desired Visualization canvas(es) onto the Narration canvas. C. Share the Story in presentation mode by setting the reportMode parameter in the project properties to FullDisplay. D. Create a new project for the Story by clicking the Save As button in the project toolbar.
Answer(s): C
Old Which two statements are true regarding the ways in which Oracle Analytics Cloud provides self service data preparation capabilities? A. The Oracle Data Integrator tool used for extraction, load, and transformation of data is a foundational component of the Oracle Analytics Cloud and is essential for data preparation. B. Join rules for mashing up data from relational sources and delimited flat files can only be defined within the Oracle Analytics Cloud Data Modeler. C. Data flows within the data preparation feature of Data Visualization can be used to extract, wrangle, and format data content from all supported data sources to create data sets upon which visuals may be constructed. D. Data sources can include application tables, data warehouses, data lake reservoirs, delimited flat files, and Microsoft Excel spreadsheets in the .xlsx format.
Answer(s): C,D
Old You have a data set that you wish to use to train a machine learning model in Oracle Analytics Cloud. The attribute you are interested in predicting has one of two text values (e.g. Yes/No or True/False). How should you perform this operation? A. Create a data flow that includes a step to train a fuzzy prediction model and save the model for later use. B. Create a data flow that includes a step to analyze sentiment and save the model for later use. C. Create a data flow that includes a step to train a clustering model and save the model for later use. D. Create a data flow that includes a step to train a binary classifier model and save the model for later use.
Answer(s): D
Old DUP!! What should you do to visualize the relationship between two numeric values? A. Use a box plot with trellising. B. Create a line chart with multiple reference lines. C. Create a scatter plot of the two numeric values and choose a value of interest as the category (points). D. Create multiple pie charts.
Answer(s): D ALT ANSWER: C <------
Old You want to create a filter that restricts access to the Fact table so that Revenue Is only visible to users assigned to a particular role. In which tab should you set this up? A. Permissions B. Row Level Data C. Table filter D. Data Filters
Answer(s): D Explanation: You can define data filters for fact tables, dimension tables, and columns that provide row-level security for data model objects. For example, you can create a filter that restricts access to the Products table so that only certain brands are visible to users assigned to a particular role. Reference: https://docs.oracle.com/en/cloud/paas/bi-cloud/bilpd/securing-access-data.html
Old If something goes wrong with your data model, you can easily restore your content to a previous working state from a . A. db_restore command B. Model Restore C. analytics_restore command D. snapshot
Answer(s): D Reference: https://docs.oracle.com/en/cloud/paas/data-visualization-cloud/bidvc/taking-snapshotsand-restoring.html#GUID-52D4F7BA-DC1E-4BE9-B8C3-9CC7D204E698
04. You want the Oracle BI Baseline Validation Tool to use specific dashboard prompts when executing a specific dashboard page. In which default file should you specify the values? a) DashboardPrompts.txt b) DashboardPrompts.xml c) Prompts.txt d) Prompts.xml
Answer: a
06. You create a visualization of revenue data by date (at day level) for the past three years. You then add a forecast. How can you check the accuracy of the forecast? a) Add reference lines for the maximum and minimum. b) Combine a polynomial trend line with a suitable reference line. c) Change the model employed by the algorithm. d) Select the option to highlight the prediction interval for a given percentage.
Answer: a
09. A customer wants to build a Block Storage (BSO) cube which has 8 standard dimensions and 2 attribute dimensions. How many dimension worksheets will the application workbook have? a) 10 dimension worksheets b) 12 dimension worksheets c) 8 dimension worksheets d) 9 dimension worksheets e) 1 dimension worksheet
Answer: a
07. Which three options are correct about application workbooks? a) Worksheets can be modified by using the Cube Designer wizard. b) Worksheets cannot be modified directly in Excel. c) Application workbooks support the generation reference dimension build method. d) Multiple dimensions can be placed on a single worksheet. e) Application workbooks can have data load worksheets and calculation worksheets.
Answer: a, c, e
02. You've created a visualization of revenue data over time. The revenue data over time exhibits some curvature in the line visualization. What trending algorithm should you use to refine the trendline? a) Set the confidence interval to 95%. b) Use the linear option. c) Use the polynomial option. d) Use the exponential option.
Answer: b
08. You have added new columns to the source table. What should you do to include the new columns in your data model? a) Update Data Model b) Add Columns from Database c) Synchronize with Database d) Connect to Tables
Answer: c
10. Which statement is false regarding arrangement of visuals on a canvas? a) Visuals can be stacked one on top of another. b) Visuals can be arranged vertically, one visual beside another. c) Visuals cannot be arranged automatically. d) Visuals can be arranged horizontally, one visual above another.
Answer: c
01. Which two statements are true regarding the source of Oracle BI Enterprise Edition Analyses? a) Analyses can be created from multiple subject areas as long as at least one metric Is Included from each, and the Dimensionality Flag is enabled. b) Analyses can be created from multiple business models as long as they contain common, conformed dimensions. c) Analyses cannot be created from multiple subject areas even though they contain common, conformed dimensions. d) Analyses can be created with measures from multiple physical tables defined as sources in a single logical fact table.
Answer: c, d
03. How can Oracle Analytics Cloud be used to visualize group relationships between data points on a particular canvas? a) Visualize the data by using a network chart. b) Use a combination of a tree diagram and a trellis visualization. c) Use a variety of colors for each data point. d) Create a cluster with a suitable number of groups for the specific analysis.
Answer: d
05. What does the band inside a box plot visualization represent? a) The standard deviation of the data b) The average of the data c) The maximum of the data d) The median of the data
Answer: d
What is true about BI Search? A. When you enter criteria in the search field, what displays in the drop-down list of suggestions can differ depending upon your locale setting B. You can search for project or elements (Attribute or Measure) C. Search in your local setting language D. Date format Year-Month-Date E. All of them
Correct Answer: E
Which Advanced Analytics you can add if you have an visualization with one period column in one of its axes? A. Trend Line B. Cluster C. Reference Line D. Forecast E. All of the above
Correct Answer: E
While you are preparing a dataset, you have a numeric value that containing a lot of values, which wrangling function you can use to group the column for different groups? A. Group B. Cluster C. Concatenate D. Bin
Correct Answer: D
After you creating the Data flow, where can you save the output of it? (Select two) A. Database B. Catalog C. Data Set D. You can't save it
Correct Answer: A,C
Old Which two statements pertaining to Action Links are false? A. Navigation from one Analysis to another Analysis is not possible if they reside In different folders. B. The Navigation option on a column can be enabled conditionally. C. Navigation from one Analysis to another Analysis only works when both analyses are created from single subject area. D. Presentation variables can be used while navigating from one Analysis to another Analysis. Reveal Solution Next Question
Answer(s): A,B
Old Your customer has an Essbase cube with current year P&L data. Once a month, the cube needs to be updated with the last closed month data. How can the monthly data be loaded incrementally using Cube Designer? A. Use the Update Cube option from the Build Option menu in Cube Designer. B. Use the Transform Data option in Cube Designer. C. Cube Designer cannot be used to load data in the cube. D. Cube Designer cannot be used to load data incrementally in the cube. E. Use the Load Data option in Cube Designer.
Answer(s): A Reference: https://docs.oracle.com/en/cloud/paas/analytics-cloud/essug/using-oracle-analyticscloud-essbase.pdf (123)
Old Which tab should you use to restrict access to a specific item in a model? A. Permissions B. Security C. App Responsibilities D. App Roles
Answer(s): A Reference: https://docs.oracle.com/en/cloud/paas/bi-cloud/bilpd/securing-access-objectsmodel.html#GUID-492F344F-5558-4C98-8472-8CD897143C97
Old Your company is using an Essbase cube, which is enabled for Scenario Management. Planners model data in individual scenarios and submit them for approval. While modeling data in the "SB1" sandbox, you changed a few values based on some assumption. Later, you realized that your assumptions were incorrect. You want to start again with the original values, the same as base. Which step should you perform? A. Type #Revert in the changed scenario cells and Submit Data. B. Type #Missing In the changed scenario cells and Submit Data. C. Type #Discard in the changed scenario cells and Submit Data. D. Type #Base in the changed scenario cells and Submit Data. E. Type #Original in the changed scenario cells and Submit Data.
Answer(s): A
Old What is not a pre-requisite for deploying the Oracle Business Intelligence Cloud Service Remote Data Connector? A. Configure the load balancer or HTTP server for Secured Socket Layer communication. B. Download the Oracle Business Intelligence Cloud Service Remote Data Connector WAR file from the Oracle Technology Network website. C. Download and Install Weblogic Server and Node Manager from the Oracle Technology Network website or, alternatively, download and install Apache Tomcat. D. Obtain the OAuth 2.0 token from the IETF OAuth Working Group website and save it to the Oracle Analytics Cloud bi_home directory.
Answer(s): A
Old What is the Oracle resource recommendation for applying a patch? A. Oracle recommends 230 GB, that is, 130 GB latency, and 100 GB data. B. Oracle recommends 300 GB, that is, 150 GB latency, and 150 GB data. C. Oracle recommends 200 GB, that is, 100 GB latency, and 100 GB data. D. Oracle recommends 330 GB, that is, 180 GB latency, and 150 GB data.
Answer(s): A
Old What statement is false regarding how Data Flow Sequences can be configured? A. Sequences can be configured to fork multiple Data Flows to be run in parallel so as to complete data preparation more quickly than running flows serially. B. Data Set prepare execution can be encapsulated by embedding Sequences inside of other Sequences. C. To remove an item from a Sequence, click the Action menu icon at the far right of the line upon which the item is found and then select Remove from the drop-down menu, D. To change the order of an item in the Sequence, the item can be selected by clicking it and dragging it up or down. It will be placed immediately below the highlighted item.
Answer(s): A
Old Which operating system does the administration tool require? A. Microsoft Windows x86-64-bit B. Linux x86-64-bit C. Oracle Solaris on SPARC 64-bit D. Oracle Solaris on x86 64-bit
Answer(s): A
Old Which statement is false with respect to the ability to adjust visualization properties when placing multiple visuals on a canvas? A. Change the visual's location on a canvas by selecting and dragging it to the desired location. B. Duplicate a visual that is on the canvas, changing the visual type in the duplicated visual. C. Resize the canvas by changing the Canvas Layout option from Auto Fit to Freeform. D. Hide a visual by right-clicking the canvas and selecting Hide from the drop-down menu.
Answer(s): A
Old You create a visualization of revenue data by date (at day level) for the past three years. You then add a forecast. How can you check the accuracy of the forecast? A. Add reference lines for the maximum and minimum. B. Combine a polynomial trend line with a suitable reference line. C. Change the model employed by the algorithm. D. Select the option to highlight the prediction interval for a given percentage.
Answer(s): A
Old You want the Oracle BI Baseline Validation Tool to use specific dashboard prompts when executing a specific dashboard page. In which default file should you specify the values? A. DashboardPrompts.txt B. DashboardPrompts.xml C. Prompts.txt D. Prompts.xml
Answer(s): A
Old You'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? A. Calculate a forecast of the probability of attrition. B. Use Outlier identification C. Use the Explain option on the attrition attribute. D. Perform a cluster analysis of employees.
Answer(s): A
Old Which step is required to create a new curated Data Set comprised of columns from several existing Data Sets? A. Merge Columns B. Add Data C. Aggregate D. Filter
Answer(s): A Reference: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/typical-workflow-creatingcurated-data-sets-data-flows.html
If you take an insight to keep track the visualization from narrate, how you can make sure that it contains common data in all users? A. Export the whole project B. You can't keep track the visualization C. All users should have the same permission
Correct Answer: C Explanation/Reference: Insights don't take a snapshot of data. They take a snapshot of the project definition at a certain point in time. If someone else views the same insight, but that person has different permissions to the data, they might see different results than you do
How you describe the trend line? (Select two answers) A. It predicts the measure or business KPI over a time series B. It helps you focus on a range/band and highlight data points that fall in the band or out of the band C. It shows how one measure or business KPI relates with the other D. Highlights a general pattern or direction of data when seen in relation to a time series
Correct Answer: C,D
OCI is available as part of OAS service? A. FALSE B. TRUE
Correct Answer: A
What are the steps you follow to download client credentials from the Autonomous Database Service Console? A. From 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 B. Click 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)
Correct Answer: A
What should you do to visualize the relationship between two numeric values? A. Create a scatter plot of the two numeric values and choose a value of interest as the category (points). B. Create multiple pie charts C. Create a line chart with multiple reference lines. D. Use a box plot with trellising
Correct Answer: A
You can execute the Data Flow without saving it? A. FALSE B. TRUE
Correct Answer: A
Which objects can't be added to a dashboard? A. Folder B. Embedded Content C. Action Link Menu D. Filter E. Alert Section
Correct Answer: D
Which statement is false regarding to Oracle Analytics Data Flow? A. It's a user-friendly lightweight transformation tool B. It provides a clean and powerful interface to a business user to cleans and transform your data. C. Is a visual representation document of data transformations D. Recognize Patterns and trends in your data
Correct Answer: D
Which statement is false with respect to Dashboard Prompts? A. Prompts can be developed using multiple columns from different subject areas. B. Repository variables and session variables can be used in prompt default values C. Images can be used in the prompts D. Prompt values can be limited based on requirements
Correct Answer: D
Bursting in BI Publisher is used for? A. It's a process of splitting data into blocks, generating documents for each block, and delivering the documents to one or more destinations? B. Highlights a general pattern or direction of data when seen in relation to a time series C. Highlight feature in selected items in the chart to effect in the other charts D. When apply a filter or select a data set to reflect in all analysis in the canvases
Correct Answer: A Explanation/Reference: About Bursting Bursting is a process of splitting data into blocks, generating documents for each block, and delivering the documents to one or more destinations. The data for the report is generated by executing a query once and then splitting the data based on a Key value. For each block of the data, a separate document is generated and delivered · The Split By element governs how the data is split. For example, to split a batch of invoices by each invoice, you may use an element called CUSTOMER_ID. The data set must be sorted or grouped by this element. · The Deliver By governs how formatting and delivery options are applied. In the invoice example, it's likely that each invoice has delivery criteria determined by customer; therefore, the Deliver By element would also be CUSTOMER_ID. · The Delivery Query is a SQL query that you define to construct the delivery XML data file. The query must return the formatting and delivery details. Enable a report to use a bursting definition on the Report Properties dialog of the report editor
In which two ways can you use Oracle Analytics Cloud to determine which values of a given data set may provide the greatest opportunity due to their stand out qualities? A. Create a box plot visualization of your data set. B. Modify the color palette to highlight unique values C. Use a combination of Max / Min value reference lines. D. Add an outlier visualization to your canvas. This will highlight data points that stand out and may justify further investigation
Correct Answer: A,C
Which two statement are false in regarding to Data Models? A. You can only export the data model through a snapshot. Individual data models cannot be exported to a JSON file B. Individual data models can be exported to a JSON file and the information imported on another service C. Individual data models can be exported to a XML file and the information imported on another service
Correct Answer: A,C
Multiple Subject area can be used through? (Select four answers) A. intersect B. intersect all C. Union all D. Minus E. Union F. All of the above
Correct Answer: A,C,D,E
You received a requirement to build a visualization to show the total revenue for south Africa who their salary is more than 1 million dollars? (Choose two answers) A. Create a list filter for south Africa and expression filter for salary B. Create a list filter for south Africa and relative for salary C. Create a list filter for south Africa and list filter for salary D. Narrate E. Create a list filter for south Africa and range filter for salary
Correct Answer: A,E
What statement is false regarding for how Data Flow Sequences can be configured? A. Data Set prepare execution can be encapsulated by embedding Sequences inside of other Sequences. B. Sequences can be configured to fork multiple Data Flows to be run in parallel so as to complete data preparation more quickly than running flows serially. C. To change the order of an item in the Sequence, the item can be selected by clicking it and dragging it up or down. It will be placed immediately below the highlighted item. D. To remove an item from a Sequence, click the Action menu icon at the far right of the line
Correct Answer: B
Which of these data types can be used for Expression filter? A. Number B. All of them C. Text D. Date
Correct Answer: B
Which statement is True? A. You can't create your own custom palette in visualizations B. You can create your own custom palette in visualizations
Correct Answer: B
Which statement is false for Cloud data modelling tool? A. Publish options are Publish and unlock or publish and keep lock B. No need to click on "Lock to edit" to make any changes C. It generates subject areas D. You can build more than one hierarchy E. You can synchronize with database the entire model or specific object
Correct Answer: B
Which step is required to create a new curated Data Set comprised of columns from several existing Data Sets? A. Aggregate B. Merge Columns C. Filter D. Add Data
Correct Answer: B
Which options make filtering? (Select three answers) A. Sorting B. Drill Down C. Keep Selected D. Remove Selected E. Highlight
Correct Answer: B,C,D
Narrate Presentation mode (Style)? (Select two answers) A. Distribution B. Compact C. ReportMode D. Filmstrip
Correct Answer: B,D
Which two are not part of the predefined application Roles? A. BI Content author B. DV Data Load Author C. BI consumer D. DV Data modeler Author E. BI Service Administrator
Correct Answer: B,D
What is NOT true about a snapshot? A. You can download a snapshot to your local system B. Restoring a snapshot will override the existing application role, catalog and data model C. A snapshot cannot be migrated from one instance environment to another D. When you upload a snapshot, the artifacts stored inside will not be immediately available in the environment
Correct Answer: C
Which of these data types can be used for Relative Time filter? A. Text B. All of the above C. Date D. Number
Correct Answer: C
You 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? A. Create a data flow that includes a step to train a Clustering model B. Create a data flow that includes a step to train a Numeric Prediction model C. Create a data flow that includes a step to train a Multi Classifier model D. Create a data flow that includes a step to train a binary classifier model
Correct Answer: C
You have transaction date and transaction amount, you create a line chart, which one is the measure or Y- Access? A. Both B. Transaction Date C. Transaction amount
Correct Answer: C
You'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? A. Use Outlier identification B. Calculate a forecast of the probability of attrition. C. Use the Explain option on the attrition attribute
Correct Answer: C
