Oracle 1Z0-1041-23 Exam - Free questions
Oracle Cloud Infrastructure 2023 Enterprise Analytics Professional
1Z0-1041-23 Free questions:
Here you can find Oracle Cloud Infrastructure 2023 Enterprise Analytics Professional exam free sample questions which will help you to prepare for your upcoming certification test. These questions will give you an idea of what to expect on the exam and help you review the 1Z0-1041-23 study material.
These 1Z0-1041-23 questions are updated regularly, so you can be confident that you're studying with the most up-to-date information available. We also provide answer keys so that students can check their work.
Additionally, going through Oracle Cloud Infrastructure 2023 Enterprise Analytics Professional practice questions can help you identify any areas where you need more review. Taking advantage of our 1Z0-1041-23 demo questions is a great way to set yourself up for success on the real thing.
Question No. 1) Describe what is the aim or the main functionality for the BI Ask?
A) To search for specific Visualizations.
B) You can search for a column names, select them and add a visualization to your project.
C) You can search for column names, select them and quickly see a visualization containing those columns.
D) To search for specific Projects.
Question No. 2) 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) Add an outlier visualization to your canvas. This will highlight data points that stand out and may Justify further investigation.
B) Modify the color palette to highlight unique values.
C) Use a combination of Max / Min value reference lines.
D) Create a box plot visualization of your data set.
Question No. 3) 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.
Question No. 4) 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.
Question No. 5) A virtual machine In Compute Classic, created resources defined by a shape is called_____.
B) Private Gateway
Question No. 6) What does a confusion matrix illustrate?
A) a table that reports the occurrences of higher positives, false negatives, lower positives, and true negatives for a machine learning model
B) a table that reports the occurrences of negative positives, false negatives, true positives, and positive negatives for a machine learning model
C) a table that reports the occurrences of false positives, false negatives, true positives, and true negatives for a machine learning model
D) a table that reports the occurrences of upper positives, lower negatives, mid positives, and true negatives for a machine learning model
Question No. 7) 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.
Question No. 8) 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.
Question No. 9) Which are the steps to create a connection between ADWH and OAC?
A) - In home page, go to hamburger icon and console tab - Select connections - Create connection and Write connection name - Upload the wallet. So file. - add the appropriate credentials and select the correct service name.
B) - In OAC home menu, Create connection - Select Oracle Autonomous Data Warehouse Cloud - Write connection name - Upload the wallet. So file. - add the appropriate credentials and select the correct service name.
C) - In home page, go to hamburger icon and console tab - Select connections - Create connection and Write connection name - Upload the wallet.zip file. - add the appropriate credentials and select the correct service name.
D) - In OAC home menu, Create connection - Select Oracle Autonomous Data Warehouse Cloud - Write connection name - Upload the wallet.zip file. - add the appropriate credentials and select the correct service name.
Question No. 10) Which statement is false with respect to Dashboards?
A) All the Analyses placed on a dashboard must be sourced from the same subject area.
B) Prompts on the dashboards can be shared between different pages of a dashboard.
C) Multiple Analyses can be arranged into different columns and sections with different sizes on a dashboard.
D) Options for the Export and Refresh report links can be enabled globally at the dashboard level.
Question No. 11) Which statements false about log files generated by Oracle BI Analyses?
A) The log file is not accessible via the repository Administration client.
B) Catalog Manager provides rapid access to the log file.
C) An Analysis that references two fact tables will generate two database-specific SQL queries in the log file.
D) The log file can be accessed via the Fusion Middleware Control.
Question No. 12) You are migrating 220.127.116.11.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.
Question No. 13) 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.
Question No. 14) You want to create an Essbase cube using a MaxL script. This is the content of the Max! script:
A) Only one MaxL statement per script is allowed.
B) It is an invalid script file. A script file must be saved with a .msh extension.
C) It is an invalid MaxL statement. "Create or replace database" Is not supported.
D) MaxLscripts are not supported.
E) It is an invalid job type.
Question No. 15) 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 thereportMode 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.
Question No. 16) 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.
Question No. 17) Which of the following cannot be done with Data Visualization to shape stories?
A) Visual canvases can be resized and the Auto Fit setting can be disabled.
B) Enhance narrative transition by rearranging and/or hiding Insight canvases.
C) Create filters to focus upon pertinent data points.
D) Multiple projects can be combined into one project by clicking on the Share icon in the Narrate menu bar.
Question No. 18) You 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?
A) Create a custom calculation based on the revenue metric.
B) Add a forecast with a forward period of approximately 90.
C) Add a forecast with a forward period of 3.
D) Add attend line with exponential option.
Question No. 19) Which action cannot be employed to split one Data Set column containing data with hyphenated strings (in the format of xxx-xxx) into two columns?
A) Edit the Data Set and select the Create option from the hyphenated column's action menu to invoke the Expression Editor. Use the String functions to parse and extract the string preceding the hyphen. Repeat for the text following the hyphen.
B) Edit the Data Set and select the Split option from the hyphenated column's action menu.
C) Edit the Data Set and select the Edit option from the hyphenated column's action menu to invoke the Expression Editor. Use the String functions to parse and extract the string preceding the hyphen. Repeat for the text following the hyphen.
D) Edit the Data Set and select the Group option from the hyphenated column's action menu to create two new groups for each element.
Question No. 20) You've created a machine learning model and investigated how accurate it is. How should you use it in Oracle Analytics Cloud?
A) Use a data flow with a Commit Model step and save as a new data set.
B) Create a custom calculation based on a related formula.
C) Use a data flow with an Apply Model step and save as a new data set.
D) Embed the model into a data flow sequence.
E) Create a data flow with a cumulative value prediction.
Question No. 21) Which are the correct steps to download the Autonomous DW wallet?
A) - Go to Oracle Cloud Storage overview - Select the bucket where you have the ADW - Click to DB Connection. - Click Download - Enter appropriate Password. - Confirm Download
B) - Go to Oracle Cloud Infrastructure overview - Select the compartment where you have the ADW Click to DB Connection. - Click Download - Confirm Download
C) - Go to Oracle Cloud Baremetal overview - Select the compartment where you have the ADW - Click to DB wallet download - Confirm Download
D) - Go to Oracle Cloud Infrastructure overview - Select the compartment where you have the ADW - Click to DB Connection. - Click Download - Enter appropriate Password. - Confirm Download
E) - Go to Oracle Cloud Infrastructure overview - Select the compartment where you have the ATP - Click to DB Connection. - Click Download - Enter appropriate Password. - Confirm Download
Question No. 22) 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.
Question No. 23) 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
Question No. 24) Oracle Analytics Cloud offers several visualization options for presenting query results. How do you explicitly invoke "best visualization" in Oracle Analytics Cloud?
A) Select the desired data elements from the Data Elements pane and drag them onto the Best Visualization zone in the Explore pane.
B) Drag an entire Data Set from the Data Elements pane onto the Data Visualization canvas and let the tool determine the best visualization.
C) Select the "Best Visualization" option from the project's Canvas Settings drop-down menu.
D) Select the desired data elements from the Data Elements pane, right-click and select "Create Best Visualization" from the drop-down menu.
Question No. 25) Monitoring information is updated automatically. You can also run a health check to update the display of monitoring information at any time. What are the correct steps to explicitly run a health check?
A) Select an Analytics Cloud service on the OAC dashboard; click the Display monitoring information icon on the Overview pane; click the Export Health check Details icon.
B) Select an Analytics Cloud service on the OAC dashboard; click the View Health check Details IconIn the Resources section; click the Export Health check Details icon.
C) Select an Analytics Cloud service on the OAC dashboard; click the Display monitoring information Icon on the Overview pane; click the View Health check Details icon in the Resources section.
D) On the Overview pane, click the Display monitoring information icon and select an Analytics Cloud service; In the Resources section, click the View Health check Details icon.
Oracle 1Z0-1041-23 Exam answers