Oracle 1Z0-1041-22 Online Practice Questions and Exam Preparation

Oracle 1Z0-1041-22 Online Questions & Answers

• Question 71:

  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.
  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 72:

  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
  A. 10 dimension worksheets

• Question 73:

  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.
  E. 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 embers in the dimension worksheet. Finally, select the Load Data option.
  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.

• Question 74:

  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.
  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.

• Question 75:

  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
  B. One to Many Relationship

• Question 76:

  Which is the correct URL for smartview?

  A. /smartview
  B. /Essbase
  C. / Essbase / sv
  D. /Essbase/smartview
  D. /Essbase/smartview

• Question 77:

  Which feature does the Data Lake Edition uniquely offer?

  A. Use the Day by Day mobile app
  B. Execute data flows on Apache Spark
  C. Migrate content from your existing on-premises environment
  D. Live optimized connectivity to your on-premises database
  B. Execute data flows on Apache Spark

  ---

  Explanation/Reference:

  Reference https://www.us-analytics.com/hyperionblog/oracle-unveils-data-lake-edition-for-oac

• Question 78:

  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 display name 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 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.
  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 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.

  ---

  Explanation/Reference:

  Reference https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/users-and- roles.html#GUID-20877829-4DFC-477A-A289-8E11E2788C7C

• Question 79:

  A client is using Weblogic Embeded LDAP server for identity managment. When creating the Oracle Analytics Cloud service, credentials must be provided for the Oracle Analytics Cloud administrator. Which of the following is a valid password?

  A. ll-password_my
  B. my-(passwordll$)
  C. my-(passwordll#)
  D. my_password$ 11
  D. my_password$ 11

• Question 80:

  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
  C. Synchronize with Database