Oracle Analytics Cloud 2024 Professional (1z0-1041-24) Free Questions - Part 5
Question No : 61) 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.
Question No : 62) Which statement is false with respect to Dashboard Prompts?
A. Prompt values can be limited based on requirements.
B. Repositoryvariables and session variables can be used in prompt default values.
C. Prompts can be developed using multiple columns from different subject areas.
D. Images can be used in the prompts.
Question No : 63) You have created a visualization of revenue data over time. It displays some seasonality (e.g. high revenue around typical holiday periods) but there is no obvious pattern to the data overall. In which two ways can you start to get insight from this data?
A. Create a trend line.
B. Create a column trellis over the prominent dimension value.
C. Add a filter to remove the oldest data.
D. Create a reference line which displays the average revenue.
Question No : 64) 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 Designercannot 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.
Question No : 65) Which statement is true about migrating BI Content and Users?
A. You can only use the WebLogic embedded LDAP server which allows you to export everything including data visualizations, reports, dashboards, and user information and other relevant information and import them to another environment by using a WebLogic embedded LDAP server.
B. If 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.
C. You 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.
D. If 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.
Question No : 66) What should you use to start the BIcomponents within your service?
A. start_analytics_suite
B. start_bi
C. start_ORCL_bi
D. start_oac
Question No : 67) What is true about setting up Usage tracking?
A. You need to restart after modifying the connection pool.
B. You need to set up a connection pool in Oracle Analytics Developer Client Tool.
C. You need to set up a connection pool in Data Modeler.
D. It is only available in Enterprise Edition.
E. It is available in both Essbase and Enterprise Edition.
Question No : 68) How can Oracle Analytics Cloud be used to visualize group relationships between data points on aparticular 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 networkchart.
Question No : 69) If we select the Oracle Analytics Cloud Enterprise Edition, which are the options available to select while creating theservice?
A.
Business Intelligence - Enterprise Reports
Pixel Perfect Reports
Data Visualization
B.
Business Intelligence - Enteprise Reports
Data Visualization
Essbase
C.
Business Intelligence - Enterprise Reports
Pixel Perfect Reports
Essbase
D.
Essbase
Pixel Perfect Reports
Data Visualization
Question No : 70) 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
Question No : 71) 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 appliedmanually?
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, selectUpdate Cube from the build options.
D. In Cube Designer:
1. Export the cube to the application workbook.
E. Select "From Sheet" to populate the wizard with contents of the application workbook.
3. Add a new dimension.
4. Select "To Sheet to propagatethe changes to the application workbook.
5 Add embers in the dimension worksheet.
Finally, select the Load Data option.
Question No : 72) Which are the steps to create a new Map Layer in OAC?
A. From the map visualization select map properties, new layer and drag JSON file.
B. From the OAC console, go to maps and drag and drop a JSON file.
C. From the OAC console, go to maps and drag and drop a geoJSON file.
D. From the map visualization select map properties, new layer and drag geoJSON file.
Question No : 73) Which two statements are true about a segment as defined in the Oracle Analytics Cloud machine learning functionality?
A. It Is a component of the output from the Explain functionality.
B. It Is a component of a data flow sequence.
C. It is the resulting data set after applying a filter in a data flow.
D. It is a statistically determined group of data points that may contribute to predicting the value of an attribute of interest.
Question No : 74) Your 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?
A. Import 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.
B. Perform analysis on the data by using trend lines, clustering, and outlier detection to offer new perspectives.
C. Create a data story by using the narrate functionality to present to their management.
D. Create a data flow to highlight the interesting data.
Question No : 75) Which are the steps to upload the wallet to set up a connection with OAC?
A.
-Go to the oracle website and sign in
- Download the wallet.zip
- Proceed without Virus scan.
- Use this zip file to upload it in DV console.
- Upload it.
B.
- Go to the oracle website and sign in
- Click over the hamburgermenu icon.
- Select Console.
- Click connections
- Click over the top-right hamburger icon.
- Proceed without Virus scan.
- Choose wallet.sso
- Upload it.
C.
- Go to the url/dv/ui
- Click over the hamburger menu icon.
- Select connections
- Click over thetop-right hamburger icon.
- Proceed without Virus scan.
- Choose wallet.zip
- Upload it.
D.
- Go to the url/dv/ui
- Click over the hamburger menu icon.
- Select Console.
- Click connections
- Click over the top-right hamburger icon.
- Proceed without Virus scan.
- Choose wallet.sso
- Upload it.
E.
-Go to the url/dv/ui
- Click over the hamburger menu icon.
- Select Console.
- Click connections
- Click over the top-right hamburger icon.
- Proceed without Virus scan.
- Choose wallet.zip
- Upload it.
1z0-1041-24 Answers