Benjamin Keck
Quiz von , erstellt am more than 1 year ago

Oracle Certs Computer Studies Quiz am Oracle Analytics Cloud 2018 Associate 1Z0-936, erstellt von Benjamin Keck am 11/09/2018.

9046
1
0
Benjamin Keck
Erstellt von Benjamin Keck vor fast 6 Jahre
Schließen

Oracle Analytics Cloud 2018 Associate 1Z0-936

Frage 1 von 72

1

1. The extensive palette of visualization options delivered with Oracle Analytics Cloud can be extended with custom plugins. What option is false about implementing custom visualization plugins? (Checked)

Wähle eine der folgenden:

  • A. The bicreateplugin script, provided with Oracle Analytics Cloud, can be used to create a skeleton visualization to facilitate custom development.

  • B. Oracle Analytics Cloud provides a Software Development Kit (SDK) to enable builds of custom plugins.

  • C. To be implemented, custom plugins must be deployed in the Bi_HOME\Analytics\src\customVi2 directory and BI Services need to be restarted.

  • D. Plugins for rendering sophisticated visuals can be downloaded from the Oracle Data Visualization Library.

Erklärung

Frage 2 von 72

1

2. Which feature does the Data Lake Edition uniquely offer? (Checked)

Wähle eine der folgenden:

  • 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

Erklärung

Frage 3 von 72

1

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

Wähle eine der folgenden:

  • 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 a trend line with exponential option.

Erklärung

Frage 4 von 72

1

4. Which two elements does a well modeled Fact Table consist of? (Checked)

Wähle eine oder mehr der folgenden:

  • A. Dimension Keys

  • B. REST APIs

  • C. Nulls

  • D. Measures

Erklärung

Frage 5 von 72

1

5. Which is not a step that can be followed to create a Story? (Checked)

Wähle eine der folgenden:

  • 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 the reportMode 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.

Erklärung

Frage 6 von 72

1

6. Oracle Analytics Cloud offers several visualization options for presenting query results. How do you explicitly invoke "best visualization" in Oracle Analytics Cloud? (Checked)

Wähle eine der folgenden:

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

Erklärung

Frage 7 von 72

1

7. How can Oracle Analytics Cloud be used to visualize group relationships between data points on a particular canvas? (Checked)

Wähle eine der folgenden:

  • 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 network chart.

Erklärung

Frage 8 von 72

1

8. Which statement is true when migrating content from Oracle BI Enterprise Edition 12c to Oracle Analytics Cloud? (Checked)

Wähle eine der folgenden:

  • A. At this time there is no option to migrate Oracle BI Enterprise Edition 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.

Erklärung

Frage 9 von 72

1

9. Which two statements are true about the Data Sync functionality? (Checked)

Wähle eine oder mehr der folgenden:

  • 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, Data Sync 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.

Erklärung

Frage 10 von 72

1

10. Which option is false with respect to the Presentation Catalog? (Checked)

Wähle eine der folgenden:

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

Erklärung

Frage 11 von 72

1

11. Which operating system does the administration tool require? (Checked)

Wähle eine der folgenden:

  • A. Microsoft Windows x86-64-bit

  • B. Linux x86-64-bit

  • C. Oracle

  • D. Oracle Solaris on x86 64-bit

Erklärung

Frage 12 von 72

1

12. Before you create an Oracle Analytics Cloud Standard Edition service, you must check to make sure you are subscribed to the required services. Which combination of services is required? (Checked)

Wähle eine der folgenden:

  • A. Oracle Database Cloud Service; Oracle Cloud Infrastructure Object Storage Classic; Oracle Big Data Cloud

  • B. Oracle Cloud Infrastructure Compute Classic; Oracle Cloud Infrastructure Object Storage Classic; Oracle Identity Cloud Service (Oracle Universal Credits required)

  • C. Oracle Cloud Infrastructure Compute Classic; Oracle Database Cloud Service; Oracle Cloud Infrastructure Object Storage Classic; Oracle Identity Cloud Service (Oracle Universal Credits required); Oracle Big Data Cloud

  • D. Oracle Cloud Infrastructure Compute Classic; Oracle Database Cloud Service; Oracle Cloud Infrastructure Object Storage Classic; Oracle Identity Cloud Service (Oracle Universal Credits required)

Erklärung

Frage 13 von 72

1

13. A virtual machine in Compute Classic, created with resources defined by a shape is called _____. (Checked)

Wähle eine der folgenden:

  • A. Orchestration

  • B. Private Gateway

  • C. Image

  • D. Instance

Erklärung

Frage 14 von 72

1

14. What does a confusion matrix illustrate? (Checked)

Wähle eine der folgenden:

  • 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

Erklärung

Frage 15 von 72

1

15. Which step is required to create a new curated Data Set comprised of columns from several existing Data Sets? (Checked)

Wähle eine der folgenden:

  • A. Merge Columns

  • B. Add Data

  • C. Aggregate

  • D. Filter

Erklärung

Frage 16 von 72

1

16. 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? (Checked)

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 17 von 72

1

17. 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? (Checked)

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 18 von 72

1

18. 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? (Need to check -- I don't think any of them are valid '-' and '(' and ')')

Wähle eine der folgenden:

  • A. ll-password_my

  • B. my-(passwordll$)

  • C. my-(passwordll#)

  • D. my_password$ 11

Erklärung

Frage 19 von 72

1

19. 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? (Checked)

Wähle eine der folgenden:

  • 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 Designer cannot 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.

Erklärung

Frage 20 von 72

1

20. What should you do to visualize the relationship between two numeric values? (Checked)

Wähle eine der folgenden:

  • A. Use a box plot with trellising.

  • B. Create a line chart with multiple reference lines.

  • C. Create a scatter plot of the two numeric values and choose a value of interest as the category (points).

  • D. Create multiple pie charts.

Erklärung

Frage 21 von 72

1

21. 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? (NEED TO CHECK)

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 22 von 72

1

22. Which statement is false with respect to Dashboard Prompts? (Checked)

Wähle eine der folgenden:

  • A. Prompt values can be limited based on requirements.

  • B. Repository variables 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.

Erklärung

Frage 23 von 72

1

23. What are the two commonly used dimensional modeling schemas? (Checked)

Wähle eine oder mehr der folgenden:

  • A. Star

  • B. Sun

  • C. Moon

  • D. Snowflake

Erklärung

Frage 24 von 72

1

24. What are two incorrect steps when creating pixel perfect reports with Bl Publisher? (Checked)

Wähle eine oder mehr der folgenden:

  • A. Generate and save to a folder in the Presentation Catalog a sample set of data that can be used for configuring and testing the report.

  • B. Define a data model to set the business view of the data, join data sets, and create custom measures.

  • C. Create connections to sources, some of which include Oracle 10g/11g, Oracle BI Server, JDBC, and MS SQL Server 2005/2008.

  • D. Test connections between BI Publisher and configured sources using Oracle Fusion MiddlewareControl.

Erklärung

Frage 25 von 72

1

25. How should you determine the accuracy of a machine learning model created in Oracle Analytics Cloud? (need to check)

Wähle eine der folgenden:

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

Erklärung

Frage 26 von 72

1

26. 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? (Checked)

Wähle eine der folgenden:

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

Erklärung

Frage 27 von 72

1

27. You create a visualization of revenue data by date (at day level) for the past three years. You then add a forecast. How can you check the accuracy of the forecast? (Need to Check)

Wähle eine der folgenden:

  • A. Add reference lines for the maximum and minimum.

  • B. Combine a polynomial trend line with a suitable reference line.

  • C. Change the model employed by the algorithm.

  • D. Select the option to highlight the prediction interval for a given percentage.

Erklärung

Frage 28 von 72

1

28. What should you use to start the BI components within your service? (Checked)

Wähle eine der folgenden:

  • A. start_analytics_suite

  • B. start_bi

  • C. start_ORCL_bi

  • D. start_oac

Erklärung

Frage 29 von 72

1

29. Which two statements are true regarding the ways in which Oracle Analytics Cloud provides self-service data preparation capabilities? (Checked)

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 30 von 72

1

30. What should you use to make sure that the model you created is correct? (Checked)

Wähle eine der folgenden:

  • A. Data Checker icon

  • B. Validate Icon

  • C. DB Sync Icon

  • D. Correct icon

Erklärung

Frage 31 von 72

1

31. Which statement is true about migrating BI Content and Users? (need to check)

Wähle eine der folgenden:

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

Erklärung

Frage 32 von 72

1

32. The data loads for your Essbase cube are taking many hours, due to which the cube is unavailable to the user for extended periods every day. You are assigned the task of optimizing the data load process. Which are four optimization steps? (Checked)

Wähle eine oder mehr der folgenden:

  • A. making the data source as small as possible by eliminating redundancy

  • B. grouping the data source by sparse-dimension member combination

  • C. positioning data in reverse order as the outline

  • D. switching from multiple data fields to a single data field

  • E. loading from the Essbase server

  • F. using Parallel load

Erklärung

Frage 33 von 72

1

33. 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? (need to check)

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 34 von 72

1

34. 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? (Checked)

Wähle eine oder mehr der folgenden:

  • A. a dimension 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

Erklärung

Frage 35 von 72

1

35. What is not a pre-requisite for deploying the Oracle Business Intelligence Cloud Service Remote Data Connector? (Checked)

Wähle eine der folgenden:

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

Erklärung

Frage 36 von 72

1

36. Which statement is false about log files generated by Oracle BI Analyses? (Need to Check)

Wähle eine der folgenden:

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

Erklärung

Frage 37 von 72

1

37. What statement is false regarding how Data Flow Sequences can be configured? (Checked)

Wähle eine der folgenden:

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

Erklärung

Frage 38 von 72

1

38. You are migrating 11.1.2.4.nnn On-Premises Essbase cubes to the cloud service. Which four steps should you perform? (Checked)

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 39 von 72

1

39. If something goes wrong with your data model, you can easily restore your content to a previous working state from a _____. (Checked)

Wähle eine der folgenden:

  • A. db_restore command

  • B. Model Restore

  • C. analytics_restore command

  • D. snapshot

Erklärung

Frage 40 von 72

1

40. 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? (Checked)

Wähle eine der folgenden:

  • A. Select an Analytics 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 Icon In
    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.

Erklärung

Frage 41 von 72

1

41. How should you use a machine learning model within a canvas of an Oracle Analytics Cloud project? (Need to check)

Wähle eine der folgenden:

  • A. Create a custom calculation

  • B. Create a scenario using the required model.

  • C. Use the machine learning model visualization.

  • D. Create a data sequence.

Erklärung

Frage 42 von 72

1

42. 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? (Checked)

Wähle eine der folgenden:

  • 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.
    2. Select "From Sheet" to populate the wizard with contents of the application workbook.
    3. Add a new dimension.
    4. Add members in the dimension worksheet.
    5. Select "To Sheet" to propagate the changes to the application workbook.
    6. Finally, select Update Cube from the build options

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

Erklärung

Frage 43 von 72

1

43. What does the band inside a box plot visualization represent? (Checked)

Wähle eine der folgenden:

  • A. The standard deviation of the data

  • B. The average of the data

  • C. The maximum of the data

  • D. The median of the data

Erklärung

Frage 44 von 72

1

44. 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 trend line? (Checked)

Wähle eine der folgenden:

  • A. Set the confidence interval to 95%.

  • B. Use the linear option.

  • C. Use the polynomial option.

  • D. Use the exponential option.

Erklärung

Frage 45 von 72

1

45. 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? (Checked)

Wähle eine der folgenden:

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

Erklärung

Frage 46 von 72

1

46. When you create a service, a diagnostics ZIP file is uploaded to your cloud storage location. Where can you find this file if your issue requires further diagnosis? (Checked)

Wähle eine der folgenden:

  • A. Go to your cloud storage and locate the service_provisioning_failure logs folder.

  • B. Go to your cloud storage and locate the service_failure logs folder.

  • C. Go to your cloud storage and locate the service_provisioning logs folder.

  • D. Go to your cloud storage and locate the provisioning_failure logs folder.

Erklärung

Frage 47 von 72

1

47. Which two statements are true about a segment as defined in the Oracle Analytics Cloud machine learning functionality? (Need to Check)

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 48 von 72

1

48. Which two statements pertaining to Action Links are false? (Need to check)

Wähle eine oder mehr der folgenden:

  • A. Navigation from one Analysis to another Analysis is not possible if they reside In different folders.

  • B. The Navigation option on a column can be enabled conditionally.

  • C. Navigation from one Analysis to another Analysis only works when both analyses are created from single subject area.

  • D. Presentation variables can be used while navigating from one Analysis to another Analysis.

Erklärung

Frage 49 von 72

1

49. (Need to Check) You want to create an Essbase cube using a MaxL script. This is the content of the Max! script:
**************************
alter system enable unicode;
create or replace application "ASOmaxl" type unicode_mode using aggregate storage;
create or replace database "ASOmaxl"."Sample";
alter system unload application ASOmaxl;
alter system load application ASOmaxl;
**************************
You saved the script file locally as cubeBuild.mxl, uploaded it to the cloud service, and executed a "MaxL script" job type. The job failed. What is the problem? (Need to Check)

Wähle eine der folgenden:

  • 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. MaxL scripts are not supported.

  • E. It is an invalid job type.

Erklärung

Frage 50 von 72

1

50. Which two statements are true regarding the source of Oracle BI Enterprise Edition Analyses? (Checked)

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 51 von 72

1

51. Which subscription do you need to begin using Oracle Analytics Cloud? (Checked)

Wähle eine der folgenden:

  • A. Oracle Big Data Cloud Service

  • B. Oracle Cloud Infrastructure Compute Classic

  • C. Oracle Business Intelligence Foundation Service

  • D. Oracle Analytics Software as a Service

Erklärung

Frage 52 von 72

1

52. You want the Oracle BI Baseline Validation Tool to use specific dashboard prompts when executing a specific dashboard page. In which default file should you specify the values? (Checked)

Wähle eine der folgenden:

  • A. DashboardPrompts.txt

  • B. DashboardPrompts.xml

  • C. Prompts.txt

  • D. Prompts.xml

Erklärung

Frage 53 von 72

1

53. Which three options are correct about application workbooks? (Checked)

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 54 von 72

1

54. Which of the following cannot be done with Data Visualization to shape stories? (Checked)

Wähle eine der folgenden:

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

Erklärung

Frage 55 von 72

1

55. 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? (Need to Check)

Wähle eine der folgenden:

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

Erklärung

Frage 56 von 72

1

56. You want to create a filter that restricts access to the Fact table so that Revenue Is only visible to users assigned to a particular role. In which tab should you set this up? (Checked)

Wähle eine der folgenden:

  • A. Permissions

  • B. Row Level Data

  • C. Table filter

  • D. Data Filters

Erklärung

Frage 57 von 72

1

57. You've created a machine learning model and investigated how accurate it is. How should you use it in Oracle Analytics Cloud? (Checked)

Wähle eine der folgenden:

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

Erklärung

Frage 58 von 72

1

58. You have added new columns to the source table. What should you do to include the new columns in your data model? (Checked)

Wähle eine der folgenden:

  • A. Update Data Model

  • B. Add Columns from Database

  • C. Synchronize with Database

  • D. Connect to Tables

Erklärung

Frage 59 von 72

1

59. Your customer has a hybrid aggregate Essbase cube. They want to be able to model what-if scenarios with hypothetical data and are considering using the Sandbox dimension. Which two statements represent correct functionality of the Sandbox dimension? (Checked)

Wähle eine oder mehr der folgenden:

  • 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 sandbox member 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.

Erklärung

Frage 60 von 72

1

60. You've created an instance with 1 OCPU and 15 GB of RAM. What is this combination of OCPU and RAM called? (Checked)

Wähle eine der folgenden:

  • A. Compute shape

  • B. Analytics shape

  • C. Classic compute

  • D. Architecture shape

Erklärung

Frage 61 von 72

1

61. Which statement is false regarding arrangement of visuals on a canvas? (Checked)

Wähle eine der folgenden:

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

Erklärung

Frage 62 von 72

1

62. Which tab should you use to restrict access to a specific item in a model? (Checked)

Wähle eine der folgenden:

  • A. Permissions

  • B. Security

  • C. App Responsibilities

  • D. App Roles

Erklärung

Frage 63 von 72

1

63. Which two statements are true regarding configuring filters to control visual content? (Checked)

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 64 von 72

1

64. You are trying to get a quick view of the number of orders placed without 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. (Need to Check)

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 65 von 72

1

65. 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? (Checked)

Wähle eine der folgenden:

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

Erklärung

Frage 66 von 72

1

66. What is a typical relationship between levels in a dimension hierarchy going from top to bottom? (Checked)

Wähle eine der folgenden:

  • A. Many to Many Relationship

  • B. One to Many Relationship

  • C. Zero Cardinality

  • D. Multiple Relationship

Erklärung

Frage 67 von 72

1

67. What is the Oracle resource recommendation for applying a patch? (Checked)

Wähle eine der folgenden:

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

Erklärung

Frage 68 von 72

1

68. 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? (Checked)

Wähle eine der folgenden:

  • A. 10 dimension worksheets

  • B. 12 dimension worksheets

  • C. 8 dimension worksheets

  • D. 9 dimension worksheets

  • E. 1 dimension worksheet

Erklärung

Frage 69 von 72

1

69. Which statement is false with respect to the ability to adjust visualization properties when placing multiple visuals on a canvas?

Wähle eine der folgenden:

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

Erklärung

Frage 70 von 72

1

70. Which statement is false with respect to Dashboards? (Checked)

Wähle eine der folgenden:

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

Erklärung

Frage 71 von 72

1

71. 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? (Checked)

Wähle eine der folgenden:

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

Erklärung

Frage 72 von 72

1

72. Select two correct editions of Oracle Analytics Cloud. (Checked)

Wähle eine oder mehr der folgenden:

  • A. Big Data Edition

  • B. SaaS Edition

  • C. Data Lake Edition

  • D. BI Cloud Service Edition

  • E. Standard Edition

Erklärung

Vorherige
Antwort prüfen
Nächste