Oracle Analytics Cloud 2024 Professional (1Z0-1041-24) Free Questions - Part 2
Question No : 16) You've been given a spreadsheet of employee attrition data and have been asked todetermine 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 beresized 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 theShare 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 youuse 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 atrend 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 twocolumns?
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 theAutonomous 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 whereyou 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 RemoteData 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 anAnalytics Cloud service on the OAC dashboard; click the Display monitoring information icon on the Overview pane; click the Export Healthcheck Details icon.
B. Select an Analytics Cloud service on the OAC dashboard; click the View Healthcheck Details IconIn the Resources section; click the Export Healthcheck 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 Healthcheck 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 Healthcheck Details icon.
Question No : 26) Your customer has a hybrid aggregate Essbase cube. They want to be able to model whatif scenarios with hypothetical data and are considering using the Sandbox dimension. Which two statements represent correct functionality of the Sandbox dimension?
A. Using the sandbox dimension has storage overhead that would be required to replicate data from the base environment.
B. The sandbox dimension has one base member and multiple sandbox members.
C. Initially, the state of each sandboxmember is #missing.
D. When you submit changes to a base member, changes are seen and stored in each sandbox member.
E. After working in the sandbox environment, you can commit changes to the base environment or even to another sandbox target.
Question No : 27) 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.
Question No : 28) You are trying to get a quick view of the number of orders placedwithout having to create a project. In the "What are you interested in" field of the home page, you enter the search string Number of Orders and BI Ask search returns a visual of order numbers. Select two options that describe what occurred.
A. The indexes that BI Ask uses to search are corrupt and cache needs to be cleared.
B. BI Ask used fuzzy logic to determine that you really wanted a list of the order numbers and complied.
C. There is no metric defined with the name Number of Orders. Resubmit the search using a wildcard.
D. There is no metric defined with the name Number of Orders. Resubmit with another variation of the name (for example, # of Orders) and see if results are returned.
Question No : 29) Which two elements does a well modeled Fact Table consist of?
A. Dimension Keys
B. REST APIs
C. Nulls
D. Measures
Question No : 30) 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 theconfidence interval to 95%.
B. Use the linear option.
C. Use the polynomial option.
D. Use the exponential option.
1Z0-1041-24 Answers