OAC Expert Certification Exam 2022 with complete solution

Document Content and Description Below

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]

Last updated: 3 years ago

Preview 1 out of 24 pages