Quiz
PARTE 1- 1Z0-1041-20 Oracle Cloud Platform Enterprise Analytics 2020 Associate
Questions in this quiz (51)
1You 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?
- APermissions
- BRow Level Data
- CTable filter
- DData Filters
2Oracle Analytics Cloud offers several visualization options for presenting query results. How do you explicitly invoke "best visualization" in Oracle Analytics Cloud?
- ASelect the desired data elements from the Data Elements pane and drag them onto the Best Visualization zone in the Explore pane.
- BDrag an entire Data Set from the Data Elements pane onto the Data Visualization canvas and let the tool determine the best visualization.
- CSelect the "Best Visualization" option from the project's Canvas Settings drop-down menu.
- DSelect the desired data elements from the Data Elements pane, right-click and select "Create Best Visualization" from the drop-down menu.
3Which two statements are true regarding configuring filters to control visual content?
- AExpression filters cannot be applied in the filter steps of Oracle Analytics Cloud Data Visualization data flows.
- BVariables may be employed in all Data Visualization filter types (that is, Range, List, Date, Expression).
- CApplication role filters for fact and dimension tables are defined in the Oracle Analytics Cloud Data Modeler.
- DWhen 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.
4Which two statements are true regarding the source of Oracle BI Enterprise Edition Analyses?
- AAnalyses can be created from multiple subject areas as long as at least one metric Is Included from each, and the Dimensionality Flag is enabled.
- BAnalyses can be created from multiple business models as long as they contain common, conformed dimensions.
- CAnalyses cannot be created from multiple subject areas even though they contain common, conformed dimensions.
- DAnalyses can be created with measures from multiple physical tables defined as sources in a single logical fact table.
5Which feature does the Data Lake Edition uniquely offer?
- AUse the Day by Day mobile app
- BExecute data flows on Apache Spark
- CMigrate content from your existing on-premises environment
- DLive optimized connectivity to your on-premises database
6You 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?
- ACreate a custom calculation based on the revenue metric.
- BAdd a forecast with a forward period of approximately 90.
- CAdd a forecast with a forward period of 3.
- DAdd a trend line with exponential option.
7What does a confusion matrix illustrate?
- AA table that reports the occurrences of higher positives, false negatives, lower positives, and true negatives for a machine learning model
- BA table that reports the occurrences of negative positives, false negatives, true positives, and positive negatives for a machine learning model
- CA table that reports the occurrences of false positives, false negatives, true positives, and true negatives for a machine learning model
- DA table that reports the occurrences of upper positives, lower negatives, mid positives, and true negatives for a machine learning model
8In 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?
- AAdd an outlier visualization to your canvas. This will highlight data points that stand out and may Justify further investigation.
- BModify the color palette to highlight unique values.
- CUse a combination of Max / Min value reference lines.
- DCreate a box plot visualization of your data set.
9Which two elements does a well modeled Fact Table consist of?
- ADimension Keys
- BREST APIs
- CNulls
- DMeasures
10Monitoring 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?
- ASelect an Analytics Cloud service on the OAC dashboard; click the Display monitoring information icon on the Overview pane; click the Export Healthcheck Details icon.
- BSelect an Analytics Cloud service on the OAC dashboard; click the View Healthcheck Details Icon In the Resources section; click the Export Healthcheck Details icon.
- CSelect 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.
- DOn 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.
11Which statement is false with respect to Dashboards?
- AAll the Analyses placed on a dashboard must be sourced from the same subject area.
- BPrompts on the dashboards can be shared between different pages of a dashboard
- CMultiple Analyses can be arranged into different columns and sections with different sizes on a dashboard.
- DOptions for the Export and Refresh report links can be enabled globally at the dashboard level.
12You've created an instance with 1 OCPU and 15 GB of RAM. What is this combination of OCPU and RAM called?
- ACompute shape
- BAnalytics shape
- CClassic compute
- DArchitecture shape
13Which statement is false with respect to Dashboard Prompts?
- APrompt values can be limited based on requirements.
- BRepository variables and session variables can be used in prompt default values.
- CPrompts can be developed using multiple columns from different subject areas.
- DImages can be used in the prompts.
14What should you use to start the BI components within your service?
- Astart_analytics_suite
- Bstart_bi
- Cstart_ORCL_bi
- Dstart_oac
15Your 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?- AUsing the sandbox dimension has storage overhead that would be required to replicate data from the base environment.
- BThe sandbox dimension has one base member and multiple sandbox members.
- CInitially, the state of each sandbox member is #missing.
- DWhen you submit changes to a base member, changes are seen and stored in each sandbox member.
- EAfter working in the sandbox environment, you can commit changes to the base environment or even to another sandbox target
16Which action cannot be employed to split one Data Set column containing data with hyphenated strings (in the format of xxx-xxx) into two columns?
- AEdit 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.
- BEdit the Data Set and select the Split option from the hyphenated column's action menu.
- CEdit 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.
- DEdit the Data Set and select the Group option from the hyphenated column's action menu to create two new groups for each element.
17Which statement Is false about log files generated by Oracle BI Analyses?
- AThe log file is not accessible via the repository Administration client.
- BCatalog Manager provides rapid access to the log file.
- CAn Analysis that references two fact tables will generate two database-specific SQL queries in the log file.
- DThe log file can be accessed via the Fusion Middleware Control.
18Which of the following cannot be done with Data Visualization to shape stories?
- AVisual canvases can be resized and the Auto Fit setting can be disabled.
- BEnhance narrative transition by rearranging and/or hiding Insight canvases.
- CCreate filters to focus upon pertinent data points
- DMultiple projects can be combined into one project by clicking on the Share icon in the Narrate menu bar.
19A 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?- A10 dimension worksheets
- B12 dimension worksheets
- C8 dimension worksheets
- D9 dimension worksheets
- E1 dimension worksheet
20The 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?- Amaking the data source as small as possible by eliminating redundancy
- Bgrouping the data source by sparse-dimension member combination
- Cpositioning data in reverse order as the outline
- Dswitching from multiple data fields to a single data field
- Eloading from the Essbase server
- Fusing Parallel load
21Which two statements are true about a segment as defined in the Oracle Analytics Cloud machine learning functionality?
- AIt Is a component of the output from the Explain functionality.
- BIt Is a component of a data flow sequence.
- CIt is the resulting data set after applying a filter in a data flow.
- DIt is a statistically determined group of data points that may contribute to predicting the value of an attribute of interest.
22Select two correct editions of Oracle Analytics Cloud.
- ABig Data Edition
- BSaaS Edition
- CData Lake Edition
- DBI Cloud Service Edition
- EStandard Edition
23A 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?
- All-password_my
- Bmy-(passwordll$)
- Cmy-(passwordll#)
- Dmy_password$ 11
24When 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?
- AGo to your cloud storage and locate the service_provisioning_failure logs folder.
- BGo to your cloud storage and locate the service_failure logs folder.
- CGo to your cloud storage and locate the service_provisioning logs folder
- DGo to your cloud storage and locate the provisioning_failure logs folder
25You have added new columns to the source table. What should you do to include the new columns in your data model?
- AUpdate Data Model
- BAdd Columns from Database
- CSynchronize with Database
- DConnect to Tables
26You want to create an Essbase cube using a MaxL script. This is the content of the Max! script:
You saved the script file locally as cubeBuild.mx1, uploaded it to the cloud service, and executed a "MaxL script" job type. The job failed. What is the problem?
- AOnly one MaxL statement per script is allowed.
- BIt is an invalid script file. A script file must be saved with a .msh extension.
- CIt is an invalid MaxL statement. "Create or replace database" Is not supported.
- DMaxL scripts are not supported.
- EIt is an invalid job type.
27How should you use a machine learning model within a canvas of an Oracle Analytics Cloud project?
- ACreate a custom calculation.
- BCreate a scenario using the required model.
- CUse the machine learning model visualization.
- DCreate a data sequence.
28Your 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?- AEnable Dynamic Time Series in the Time dimension and configure Y-T-D and Q-T-D.
- BEnsure the Time Balance functionality is turned on for the cube.
- CExclude Quarters from the Time hierarchy.
- DEnsure the dimension representing Time is tagged as the "Time" dimension.
29You 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,- AThe indexes that BI Ask uses to search are corrupt and cache needs to be cleared.
- BBI Ask used fuzzy logic to determine that you really wanted a list of the order numbers and complied.
- CThere is no metric defined with the name Number of Orders. Resubmit the search using a wildcard.
- DThere 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.
30Which statement is true about migrating BI Content and Users?
- AYou 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.
- BIf 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.
- CYou 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.
- DIf 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.
31If 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?
- AClick 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.
- BClick 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.
- CClick 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.
- DClick 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.
32You'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?- ASet the confidence interval to 95%.
- BUse the linear option.
- CUse the polynomial option.
- DUse the exponential option.
33Which statement is false regarding arrangement of visuals on a canvas?
- AVisuals can be stacked one on top of another.
- BVisuals can be arranged vertically, one visual beside another.
- CVisuals cannot be arranged automatically.
- DVisuals can be arranged horizontally, one visual above another.
34Your 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?- AImport 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.
- BPerform analysis on the data by using trend lines, clustering, and outlier detection to offer new perspectives.
- CCreate a data story by using the narrate functionality to present to their management.
- DCreate a data flow to highlight the interesting data.
35You 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?
- ADashboardPrompts.txt
- BDashboardPrompts.xml
- CPrompts.txt
- DPrompts.xml
36Which two statements pertaining to Action Links are false?
- ANavigation from one Analysis to another Analysis is not possible if they reside In different folders.
- BThe Navigation option on a column can be enabled conditionally.
- CNavigation from one Analysis to another Analysis only works when both analyses are created from single subject area.
- DPresentation variables can be used while navigating from one Analysis to another Analysis.
37If something goes wrong with your data model, you can easily restore your content to a previous working state from a
- Adb_restore command
- BModel Restore
- Canalytics_restore command
- Dsnapshot
38Which operating system does the administration tool require?
- AMicrosoft Windows x86-64-bit
- BLinux x86-64-bit
- COracle Solaris on SPARC 64-bit
- DOracle Solaris on x86 64-bit
39The 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?- AThe bicreateplugin script, provided with Oracle Analytics Cloud, can be used to create a skeleton visualization to facilitate custom development.
- BOracle Analytics Cloud provides a Software Development Kit (SDK) to enable builds of custom plugins.
- CTo be implemented, custom plugins must be deployed in the Bi_HOME\Analytics\src\customVi2 directory and BI Services need to be restarted.
- DPlugins for rendering sophisticated visuals can be downloaded from the Oracle Data Visualization Library.
40You've created a machine learning model and investigated how accurate it is. How should you use it in Oracle Analytics Cloud?
- AUse a data flow with a Commit Model step and save as a new data set.
- BCreate a custom calculation based on a related formula.
- CUse a data flow with an Apply Model step and save as a new data set.
- DEmbed the model into a data flow sequence.
- ECreate a data flow with a cumulative value prediction.
41What is a typical relationship between levels in a dimension hierarchy going from top to bottom?
- AMany to ManyRelationship
- BOne to Many Relationship
- CZero Cardinality
- DMultiple Relationship
42A 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?- APrevious changes applied manually in cloud service cannot be retained while using Cube Designer.
- BA new dimension cannot be added to an existing cube using Cube Designer.
- CCube 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. - DIn 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 embers in the dimension worksheet.
6. Finally, select the Load Data option.
43How can Oracle Analytics Cloud be used to visualize group relationships between data points on a
particular canvas?- AUse a variety of colors for each data point.
- BCreate a cluster with a suitable number of groups for the specific analysis.
- CUse a combination of a tree diagram and a trellis visualization.
- DVisualize the data by using a network chart.
44Which two statements are true about the Data Sync functionality?
- AData Sync can create and manage surrogate keys in target tables.
- BData Sync is the only mechanism available in Oracle Analytics Cloud Standard Edition for loading data Into DBaaS tables.
- CTo 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.
- DData Sync cannot load incremental source insertions and updates; only full refresh loads are supported.
45Which subscription do you need to begin using Oracle Analytics Cloud?
- AOracle Big Data Cloud Service
- BOracle Cloud Infrastructure Compute Classic
- COracle Business Intelligence Foundation Service
- DOracle Analytics Software as a Service
46Which two statements are true regarding the ways in which Oracle Analytics Cloud provides selfservice data preparation capabilities?
- AThe 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.
- BJoin rules for mashing up data from relational sources and delimited flat files can only be defined within the Oracle Analytics Cloud Data Modeler.
- CData 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.
- DData sources can include application tables, data warehouses, data lake reservoirs, delimited flat files, and Microsoft Excel spreadsheets in the .xlsx format.
47What does the band inside a box plot visualization represent?
- AThe standard deviation of the data
- BThe average of the data
- CThe maximum of the data
- DThe median of the data
48Which three options are correct about application workbooks?
- AWorksheets can be modified by using the Cube Designer wizard.
- BWorksheets cannot be modified directly in Excel.
- CApplication workbooks support the generation reference dimension build method.
- DMultiple dimensions can be placed on a single worksheet.
- EApplication workbooks can have data load worksheets and calculation worksheets.
49How should you determine the accuracy of a machine learning model created in Oracle Analytics Cloud?
- AOpen the Inspect dialog for a given machine learning model and review the F1 score.
- BRun the machine learning model with various filter values applied.
- CCreate a data flow that Includes a histogram.
- DUse the debug option in the data flow where the model was created.
50Your 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?- AType #Revert in the changed scenario cells and Submit Data.
- BType #Missing In the changed scenario cells and Submit Data.
- CType #Discard in the changed scenario cells and Submit Data.
- DType #Base in the changed scenario cells and Submit Data.
- EType #Original in the changed scenario cells and Submit Data.
51Which objects can be added to a dashboard page?
- AColumn, Section, Action Link, and filter
- BColumn, Section, Action Link Menu, and Analyses
- CColumns, Sections, Filter, and Analyses
- DColumns, Action Link Menu, Folder, and Calculation
Information
- Description
- Quiz on PARTE 1- 1Z0-1041-20 Oracle Cloud Platform Enterprise Analytics 2020 Associate, created by Yasibit Reyes on 12/01/2021.
- Author
- Yasibit Reyes
- Language
- Español
- Views
- 280
- Rating
- No ratings yet Rate this quiz