Infosys Certified Oracle Analytics Cloud Consultant
Practice with real exam-pattern questions for Infosys Certified Oracle Analytics Cloud Consultant. Each question includes a detailed explanation to help you understand the concept, not just memorise the answer. Try 10 questions free — no login required.
Full question bank for this exam + 1,357+ others. Cancel anytime.
Join Premium10 Infosys Certified Oracle Analytics Cloud Consultant practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Oracle Analytics Cloud Consultant certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
The system automatically assigns data blending according to the which of the following rules:
I. If the visualization contains a match column, then the system sets sources with the match column to All Rows.
II. If the visualization contains an attribute, then the system sets its source to All Rows and sets the other sources to Matching Rows.
III. If attributes come from multiple sources, then the system sets the source listed first in the project's elements panel to All Rows and sets the other sources to Matching Rows.
IV. If attributes in the visualization come from the same source, then the system sets the source to All Rows, and sets the other sources to also to All Rows.
- ✓ I only Correct
- B I,II only
- C I,II and III only
- D I,II,III and IV only
- Question 2
Which among the following is False for Oracle Day by Day?
- ✓ Day by Day is an app that will learn what users are interested in, when & where they are interested in it and who they collaborate with Correct
- B Day by Day will anticipate what users need and deliver appropriate information to help them make better informed decisions throughout the day
- C Day by Day's smart feed continuously delivers meaningful analytics throughout the day based on what’s going on in the business, on that day, and the people collaborated with.
- D Day by Day covers Dashboard, Answers Reports,DV
- Question 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?
- ✓ Create a custom calculation based on the revenue metric. Correct
- 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.
- Question 4
Which function can be used to compute sales for a period that starts at a quarter before and ends at a quarter after the current quarter?
- ✓ Forecast Correct
- B Periodrolling
- C Periodago
- D Timeset
- Question 5
Which of the below elements cannot be migrated from on-premise to Essbase Cloud?
- ✓ Transparent partitions and Replicated partitions Correct
- B @XREF function formulas
- C Excel worksheets and Macro-enabled Excel files
- D Substitution variables
- Question 6
Which of below is not true for cloud sandboxing?
- ✓ Sandbox data is also called Scenario data Correct
- B The members in the sandbox dimension can be at various levels
- C All members in the sandbox dimension are level-0
- D The DATAEXPORT calculation command isn’t supported on sandbox members
- Question 7
Suppose I Have a Dimension A with Members B and C and I Do Not Want B And C To Roll Up To A. How Can I Do This?
- ✓ Through never consolidate operator (^) Correct
- B Through (+) operator
- C Using (~) exclude from consolidation operator
- D None of the Above
- Question 8
Which feature does the data lake edition uniquely offers?
- ✓ Execute data flows on apache spark Correct
- B Use the day by day mobile app
- C Migrate content from your existing on premise environment
- D Live optimized connectivity to your on premised database
- Question 9
Suppose your revenue table contains both product and customer attributes, as well as revenue measures. What is the correct way to model it in OAC?
- ✓ 'Add as Fact table' since it contains one or more measures Correct
- B 'Add as dimension table' since it contains one or more attributes
- C Use 'Add as Fact and Dimension Tables' option
- D None of the choices
- Question 10
Which is the incorrect statement about Spreadsheet Data Sets?
- ✓ Tables must start in Row 1 and Column 1 of the Excel file. Correct
- B Row 1 must contain the table’s column names.
- C Excel spreadsheets can have pivoted data.
- D Excel spreadsheets cannot be larger than 100 MB.
More in Oracle Enterprise Applications
Infosys Certified PL-SQL Associate
Infosys Certified Oracle B2B Service Cloud Consultant
Infosys Certified Oracle Financial Consolidation and Close Cloud Services Consultant
Pay once. Clear every cert this year.
One subscription, full Telegram channel access, every PDF posted during your membership.
- Full access to all 1,357+ certifications
- Monthly updated question banks
- Telegram private channel access
- Cancel anytime
- Everything in Monthly
- Save ₹2,100 vs monthly billing
- Priority answer key requests
- Best for increasing DQ score fast
- Everything in Quarterly
- Lifetime channel access — no renewals
- All future certifications included
- Priority response from admin team
Common questions, straight answers.
A monthly-updated Telegram channel where we post real exam-pattern question banks and detailed answer keys for 1,357+ Infosys Lex certifications. You join once, you get every PDF posted during your membership.
Right after payment on our Graphy page, you'll receive a private invite link to the Telegram channel. Access is instant — usually under 30 seconds.
We compile question banks from the actual Lex test pattern, sourced and verified by 180K+ community members who've recently cleared these exams. Match rate is consistently 85–95%.
Every single month. When Infosys rolls out new versions of certifications, we post updated dumps within 7–10 days. You'll see channel activity weekly.
Clearing certifications is one of the highest-weighted DQ factors. Members typically clear 3–5 certifications in their first 3 months, which moves DQ scores up by a full band.