2021 1Z0-1041-20 Premium Files Test pdf - Free Dumps Collection
Get ready to pass the 1Z0-1041-20 Exam right now using our Oracle Business Analytics Exam Package
NEW QUESTION 42
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 Load Data option in Cube Designer.
- B. Cube Designer cannot be used to load data in the cube.
- C. Use the Update Cube option from the Build Option menu in Cube Designer.
- D. Use the Transform Data option in Cube Designer.
- E. Cube Designer cannot be used to load data incrementally in the cube.
Answer: C
Explanation:
Explanation
Reference
https://docs.oracle.com/en/cloud/paas/analytics-cloud/essug/using-oracle-analytics-cloud-essbase.pdf (123)
NEW QUESTION 43
Which statement is false with respect to Dashboard Prompts?
- A. Repository variables and session variables can be used in prompt default values.
- B. Prompts can be developed using multiple columns from different subject areas.
- C. Prompt values can be limited based on requirements.
- D. Images can be used in the prompts.
Answer: C
NEW QUESTION 44
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. In Cube Designer:
1. Export the cube to the application workbook. - B. 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. - C. 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. - D. Previous changes applied manually in cloud service cannot be retained while using Cube Designer.
- E. A new dimension cannot be added to an existing cube using Cube Designer.
Answer: B
NEW QUESTION 45
Which statement is false regarding arrangement of visuals on a canvas?
- A. Visuals can be arranged horizontally, one visual above another.
- B. Visuals cannot be arranged automatically.
- C. Visuals can be stacked one on top of another.
- D. Visuals can be arranged vertically, one visual beside another.
Answer: B
NEW QUESTION 46
Which statement is true about migrating BI Content and Users?
- A. 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.
- 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 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.
- D. 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.
Answer: B
NEW QUESTION 47
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?
- A. Edit the Data Set and select the Group option from the hyphenated column's action menu to create two new groups for each element.
- B. 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.
- 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 Split option from the hyphenated column's action menu.
Answer: A
NEW QUESTION 48
Which are the steps to create a connection between ADWH and OAC?
- A. - In home page, go to hamburger icon and console tab
- Select connections
- Create connection and Write connection name
- Upload the wallet.sso file.
- add the appropriate credentials and select the correct service name. - B. - In OAC home menu, Create connection
- Select Oracle Autonomous Data Warehouse Cloud
- Write connection name
- Upload the wallet.sso file.
- add the appropriate credentials and select the correct service name. - C. - In home page, go to hamburger icon and console tab
- Select connections
- Create connection and Write connection name
- Upload the wallet.zip file.
- add the appropriate credentials and select the correct service name. - D. - In OAC home menu, Create connection
- Select Oracle Autonomous Data Warehouse Cloud
- Write connection name
- Upload the wallet.zip file.
- add the appropriate credentials and select the correct service name.
Answer: D
NEW QUESTION 49
You 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?
- A. It is an invalid script file. A script file must be saved with a .msh extension.
- B. MaxL scripts are not supported.
- C. Only one MaxL statement per script is allowed.
- D. It is an invalid job type.
- E. It is an invalid MaxL statement. "Create or replace database" Is not supported.
Answer: A
NEW QUESTION 50
What is the Oracle resource recommendation for applying a patch?
- A. Oracle recommends 330 GB, that is, 180 GB latency, and 150 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 230 GB, that is, 130 GB latency, and 100 GB data.
Answer: D
NEW QUESTION 51
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,
- 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 a 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.
Answer: B,D
NEW QUESTION 52
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. my_password$ 11
- B. my-(passwordll$)
- C. ll-password_my
- D. my-(passwordll#)
Answer: A
NEW QUESTION 53
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?
- A. Calculate a forecast of the probability of attrition.
- B. Perform a cluster analysis of employees.
- C. Use Outlier identification.
- D. Use the Explain option on the attrition attribute.
Answer: D
NEW QUESTION 54
What should you use to make sure that the model you created is correct?
- A. DB Sync Icon
- B. Correct icon
- C. Data Checker icon
- D. Validate Icon
Answer: D
NEW QUESTION 55
Which statement is true when migrating content from Oracle BI Enterprise Edition 12c to Oracle Analytics Cloud?
- A. You can only migrate an Oracle BI Enterprise Edition 12c Data Model to Oracle Analytics Cloud.
Catalog migration is not allowed. - 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. At this time there is no option to migrate Oracle BI Enterprise Edition llg content to Oracle Analytics Cloud.
- D. You can migrate a snapshot from Oracle BI Enterprise Edition 12c to Oracle Analytics Cloud.
Answer: D
NEW QUESTION 56
You've created an instance with 1 OCPU and 15 GB of RAM. What is this combination of OCPU and RAM called?
- A. Compute shape
- B. Analytics shape
- C. Classic compute
- D. Architecture shape
Answer: A
NEW QUESTION 57
Which is the correct URL for smartview?
- A. /Essbase
- B. / Essbase / sv
- C. /smartview
- D. /Essbase/smartview
Answer: D
NEW QUESTION 58
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?
- A. making the data source as small as possible by eliminating redundancy
- B. loading from the Essbase server
- C. switching from multiple data fields to a single data field
- D. using Parallel load
- E. grouping the data source by sparse-dimension member combination
- F. positioning data in reverse order as the outline
Answer: A,B,D,E
NEW QUESTION 59
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?
- A. Oracle Cloud Infrastructure Compute Classic; Oracle Database Cloud Service; Oracle Cloud Infrastructure Object Storage Classic; Oracle Identity Cloud Service (Oracle Universal Credits required)
- B. 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
- C. Oracle Database Cloud Service; Oracle Cloud Infrastructure Object Storage Classic; Oracle Big Data Cloud
- D. Oracle Cloud Infrastructure Compute Classic; Oracle Cloud Infrastructure Object Storage Classic; Oracle Identity Cloud Service (Oracle Universal Credits required)
Answer: B
Explanation:
Explanation
Reference
https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsam/administering-oracle-analytics-cloud-user-managed (14)
NEW QUESTION 60
Which are the correct steps to download the Autonomous DW wallet?
- A. - Go to Oracle Cloud Infrastructure overview
- Select the compartment where you have the ADW
Click to DB Connection.
- Click Download
- Confirm Download - B. - Go to Oracle Cloud Baremetal overview
- Select the compartment where you have the ADW
- Click to DB wallet download
- Confirm Download - C. - Go to Oracle Cloud Infrastructure overview
- Select the compartment where you have the ADW
- Click to DB Connection.
- Click Download
- Enter appropriate Password.
- Confirm Download - D. - Go to Oracle Cloud Infrastructure overview
- Select the compartment where you have the ATP
- Click to DB Connection.
- Click Download
- Enter appropriate Password.
- Confirm Download - E. - Go to Oracle Cloud Storage overview
- Select the bucket where you have the ADW
- Click to DB Connection.
- Click Download
- Enter appropriate Password.
- Confirm Download
Answer: C
NEW QUESTION 61
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?
- A. Change the model employed by the algorithm.
- B. Combine a polynomial trend line with a suitable reference line.
- C. Add reference lines for the maximum and minimum.
- D. Select the option to highlight the prediction interval for a given percentage.
Answer: D
NEW QUESTION 62
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?
- A. Row Level Data
- B. Data Filters
- C. Permissions
- D. Table filter
Answer: B
Explanation:
Explanation
You can define data filters for fact tables, dimension tables, and columns that provide row-level security for data model objects. For example, you can create a filter that restricts access to the Products table so that only certain brands are visible to users assigned to a particular role.
https://docs.oracle.com/en/cloud/paas/bi-cloud/bilpd/securing-access-data.html
NEW QUESTION 63
Which option is false with respect to the Presentation Catalog?
- A. To prevent corruption of the catalog, storage of objects of different types must be segregated into their own folders.
- B. Catalog Manager is a client administration tool that can be used to view and manage the Presentation Catalog.
- C. Object permissions for Analyses and Prompts can be archived along with the object in the catalog.
- D. Multiple objects can be archived into a single file.
Answer: A
NEW QUESTION 64
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
Answer: B
Explanation:
Explanation
Reference https://www.us-analytics.com/hyperionblog/oracle-unveils-data-lake-edition-for-oac
NEW QUESTION 65
A virtual machine In Compute Classic, created resources defined by a shape is called_____.
- A. Private Gateway
- B. Orchestration
- C. Image
- D. Instance
Answer: D
NEW QUESTION 66
......
Master 2021 Latest The Questions Oracle Business Analytics and Pass 1Z0-1041-20 Real Exam!: https://www.prep4pass.com/1Z0-1041-20_exam-braindumps.html
