Oracle Analytics Cloud 2024 Professional (1z0-1041-24) Free Questions - Part 3
Question No : 31) 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.
Question No : 32) Which two statements aretrue regarding configuring filters to control visual content?
A. Expression filters cannot be applied in the filter steps of Oracle Analytics Cloud Data Visualization data flows.
B. Variables may be employed in all Data Visualization filter types (that is, Range, List, Date, Expression).
C. Application role filters for fact and dimension tables are defined in the Oracle Analytics Cloud Data Modeler.
D. When the Oracle Business Intelligence Enterprise Edition repository is used as a data source, filters defined in the initialization blocks with the client administration tool are automatically inherited in Data Visualization.
Question No : 33) 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.
Question No : 34) You want the Oracle BI Baseline Validation Tool to use specificdashboard 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
Question No : 35) 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.
Question No : 36) 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.
Question No : 37) If your service uses the embedded LDAP server, you can add users and roles one-by-one through the Console. What is the correct process to add a role?
A. Click Roles; Click Add; Enter a name for the role; Import Users from a .csv file; Assign one or more users to this role by selecting Manage Members; Select Users from the Type list and then click Search to list all the users you imported from your .csv file.
B. Click Roles; Click Add; Enter a name for the role; Enter a more detailed displayname and description (required); Assign one or more users to this role by selecting Manage Members, select Users from the Type list and then click Search to list all the users; Move all the users you want for this role to the Selected Users pane; click OK.
C. Click Roles; Click Add; Enter a name for the role; Enter a more detailed display name and description (optional); Assign one or more users to this role by selecting Manage Members; Import Users from a .csv file; Move all the users you want for this role to the Selected Users pane; click OK.
D. Click Roles; Click Add; Enter a name for the role; Enter a more detailed display name and description (optional); Assign one or more users to this role by selecting Manage Members, select Users from the Type listand then click Search to list all the users; Move all the users you want for this role to the Selected Users pane; click OK.
Question No : 38) How should you use a machine learning model within a canvas of an Oracle Analytics Cloud project?
A. Create a custom calculation.
B. Create a scenario using the requiredmodel.
C. Use the machine learning model visualization.
D. Create a data sequence.
Question No : 39) 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.
Question No : 40) 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
Question No : 41) Select two correct editions of Oracle Analytics Cloud.
A. Big Data Edition
B. SaaS Edition
C. Data Lake Edition
D. BI Cloud Service Edition
E. Standard Edition
Question No : 42) 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. adimension 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
Question No : 43) What is a typical relationship between levels in a dimension hierarchy going from top to bottom?
A. Many to ManyRelationship
B. One to Many Relationship
C. Zero Cardinality
D. Multiple Relationship
Question No : 44) Your customer has a requirement to generate a Year-to-Date and Quarter-to-Date report from a Block Storage Essbase cube. The cube has a dimension that represents Time and includes calendar months as leaf-level members. What two steps should you perform to enable To-Date reporting?
A. Enable Dynamic Time Series in the Time dimension and configure Y-T-D and Q-T-D.
B. Ensure the Time Balance functionality is turned on for the cube.
C. Exclude Quarters from the Time hierarchy.
D. Ensure the dimension representing Time is tagged as the "Time" dimension.
Question No : 45) 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.
C. To manage extractions and loads from cloud-based sources, DataSync 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.
1z0-1041-24 Answers