OAC Expert Certification Exam 2022 with complete solution
Extract option in data wrangling function is available for which data type?
- Attribute
- Measure
- Date -Answer>> Date
A bank has a requirement for de
...
OAC Expert Certification Exam 2022 with complete solution
Extract option in data wrangling function is available for which data type?
- Attribute
- Measure
- Date -Answer>> Date
A bank has a requirement for detecting fraudulent transactions in customer accounts. This could be very rare across all customer accounts over a period of time. Which algorithm or approach will you use to accomplish this?
- Support Vector Machine
- Decision Tree
- Anomaly detection
- Logistic Regression -Answer>> Anomaly detection
Which two statements are true about the Oracle Analytics Cloud Explain functionality?
- It can identify hidden groups in data.
- It can be used only for measure columns.
- It can be used only for attribute columns.
- It can enable users with insight on data. -Answer>> It can identify hidden groups in data.
It can enable users with insight on data.
Which three statements about Agents are TRUE?
- They can be run conditionally.
- They can be used to seed the cache.
- There is no method to override the recipient's delivery profile
- They can be configured to run on a schedule. -Answer>> They can be run conditionally.
They can be used to seed the cache.
They can be configured to run on a schedule.
Which three of the following are TRUE about Hierarchies?
- There is a limit to the number of levels you can have in a hierarchy.
- A hierarchy shows relationships among groups of columns in a dimension table.
- All hierarchies for a given dimension must have a common lowest level.
- A dimension table can have one or more hierarchies. -Answer>> A hierarchy shows relationships among groups of columns in a dimension table.
All hierarchies for a given dimension must have a common lowest level.
A dimension table can have one or more hierarchies.
What service do you need to create an OAC instance:
- OAC
- ADW
- OCP -Answer>> OAC
Which two are TRUE about Master View?
- A master view contains a master column, where you set up the interaction that sends master-detail events on a channel.
- The master column can display on the page edge or section slider.
- A channel carries master-detail events to the detail view.
- All of these -Answer>> A master view contains a master column, where you set up the interaction that sends master-detail events on a channel.
A channel carries master-detail events to the detail view.
What are the two data viewing options for paging content on a Table?
- Moving headers with scrolling content.
- Fixed headers with scrolling content.
- Page numbering
- Content Paging -Answer>> Fixed headers with scrolling content.
Content Paging
Which of the following statements are TRUE about an Analysis?
- A compound layout can have many views.
- The maximum amount of views for an Analysis is 8.
- A compound layout can have only a single view.
- An Analysis can have more than one compound layout. -Answer>> A compound layout can have many views.
An Analysis can have more than one compound layout.
You created a sort on the Year Column. What happens If you click Sort Ascending on the Quarter column?
- This would happen if Add Ascending Sort was clicked.
- Clicking Sort Ascending on Quarter will remove the sort on Year.
- The only way to sort is by grouping.
- The analysis will first be sorted on Year and then it will be sorted on Quarter.
- You can only sort on a single column. -Answer>> Clicking Sort Ascending on Quarter will remove the sort on Year.
A well-designed data table should include what?
- Primary keys, Foreign keys, & fact columns
- Primary keys & descriptive columns
- Primary keys & descriptive columns, & Facts
- Primary keys & fact columns -Answer>> - Primary keys & descriptive columns
[Show More]
