OAC CERTIFICATION PRACTICE QUESTIONS |GUARANTEED PASS, Exams of Nursing

Download OAC CERTIFICATION PRACTICE QUESTIONS |GUARANTEED PASS and more Exams Nursing in PDF only on Docsity!

OAC CERTIFICATION PRACTICE

QUESTIONS |GUARANTEED PASS

Oracle Data Visualization Cloud Service is a:

• Desktop tool
• Browser/web-based tool - ACCURATE ANSWERS✔✔ Browser/web- based tool Choose what is NOT true about instant mobile access that the DVCS provides.
• You can just view the content on your mobile device
• Interface is optimized for the layout of mobile devices
• No coding is required to view the content on mobile devices
• You can enhance the existing visuals on your mobile device - ACCURATE ANSWERS✔✔ You can just view the content on your mobile device What is automatic correlating of data in Oracle DVCS?
• Selecting data in one visualization highlights related data in others
• Blending of data
• Automatic creation of visualizations based on scenario - ACCURATE ANSWERS✔✔ Selecting data in one visualization highlights related data in others

DVCS automatically decides the best visualization based on the scenario.

• True
• False - ACCURATE ANSWERS✔✔ True DVCS is available as part of Oracle Analytics Cloud Service.
• True
• False - ACCURATE ANSWERS✔✔ True Same visualizations are available across the following services: (choose three)
• Oracle BDCS
• Oracle DVCS
• Oracle BICS
• Oracle BI 12c
• Oracle BDPCS - ACCURATE ANSWERS✔✔ - Oracle DVCS
• Oracle BICS
• Oracle BI 12c Column names in an uploaded Excel file cannot be duplicate.
• True
• False - ACCURATE ANSWERS✔✔ True What is true in case of external data set? (Choose two)

• Data set can contain facts that extend measures.
• Data set can contain pivoted data.
• Data set should not contain any column headings.
• Data set can contain attributes that extend dimension. - ACCURATE ANSWERS✔✔ - Data set can contain facts that extend measures
• Data set can contain attributes that extend dimension Hierarchies can be defined in external data sets.
• True
• False - ACCURATE ANSWERS✔✔ - False What is the maximum size limit for Microsoft Excel data files that I want to upload?
• 100 MB
• 15 MB
• 50 MB
• 75 MB - ACCURATE ANSWERS✔✔ 50 MB The default query mode for a database table in create source dialog box is:
• Stale
• Cached
• Live
• Auto - ACCURATE ANSWERS✔✔ Live

An external data source that can be added to DVCS can be of type: (Choose two)

• Excel
• csv
• PPT
• PDF - ACCURATE ANSWERS✔✔ - Excel
• csv You can update the details of an added external data set using:
• Inspect
• Update
• Show
• Check - ACCURATE ANSWERS✔✔ Inspect The "Remove from Project" option for a data set deletes it permanently.
• True
• False - ACCURATE ANSWERS✔✔ False Data blending in Oracle DVCS is done through which option?
• Data Synchronization
• Data Combine
• Data Diagram

• Data Correlation - ACCURATE ANSWERS✔✔ Data Diagram Extract option in data wrangling function is available for which data type?
• Attribute
• Measure
• Date - ACCURATE ANSWERS✔✔ Date Execute Data Flow option will:
• Just save the data flow without running it
• Just run the data flow
• Run the data flow and save it - ACCURATE ANSWERS✔✔ Just run the data flow Expressions that you create for expression filters must be Boolean.
• True
• False - ACCURATE ANSWERS✔✔ True What is the criteria if you want to add trendline to your visualization?
• Visualization should have a period column in both of its axes
• Visualization should have a period column in one of its axes
• Visualization should not contain any period column in either of its axes
• None of the above - ACCURATE ANSWERS✔✔ Visualization should have a period column in one of its axes

Choose analytic actions that produce filtering. (Choose three)

• Remove Selected
• Drilling
• Sorting
• Keep Selected - ACCURATE ANSWERS✔✔ - Drilling
• Remove Selected
• Keep Selected Select the function that is used to execute any custom R-script in the script repository.
• EVALUATE_AGGR
• EVALUATE
• EVALUATE_SCRIPT - ACCURATE ANSWERS✔✔ EVALUATE_SCRIPT You can create your own custom palette in visualizations
• True
• False - ACCURATE ANSWERS✔✔ True Advanced filtering using multiple data elements can be achieved by using:
• Expression Filters
• List Filters

• Date Filters
• Range Filters - ACCURATE ANSWERS✔✔ Expression Filters Oracle DVCS provides instant mobile access with the following OS: (Choose three)
• Windows
• iOS
• Linux
• Android - ACCURATE ANSWERS✔✔ - Windows
• iOS
• Android When you search for a date attribute using search field, which format will you use?
• year-month-date
• month-date-year
• date-month-year - ACCURATE ANSWERS✔✔ year-month-date Interaction between visualizations in the canvas is controlled by the following visual analyzer option:
• Control Visualizations
• Match Visualizations
• Synchronize Visualizations

• Manage Visualizations - ACCURATE ANSWERS✔✔ Synchronize Visualizations You can choose to hide or show visuals from each canvas in story navigator.
• True
• False - ACCURATE ANSWERS✔✔ True You can share your story using the following file formats: (Choose four)
• txt
• PDF
• dva
• csv
• Excel
• PPT - ACCURATE ANSWERS✔✔ - PDF
• dva
• csv
• PPT The Narrate tab is used to:
• Create Application folder
• Create visualizations
• Build a story using the canvases in visualizations

• Prepare data for visualizations - ACCURATE ANSWERS✔✔ Build a story using the canvases in visualizations Administrators can check the status of crawl jobs using:
• Show Crawls
• Investigate Crawls
• Monitor Crawls
• Check Crawls - ACCURATE ANSWERS✔✔ Monitor Crawls You can get back to your deleted project by restoring an earlier version o the catalog.
• True
• False - ACCURATE ANSWERS✔✔ True You can check the physical query executed for a particular report using:
• Check Log
• Monitor Log
• View Log
• Show Log - ACCURATE ANSWERS✔✔ View Log By default, what is the frequency of catalog crawling?
• Every alternative day
• Twice in a day
• Once in a day

• Once in a week - ACCURATE ANSWERS✔✔ Once in a day By default, Logging level is set to:
• Deployer
• Incident
• Trace
• Information
• Anonymous
• Disabled - ACCURATE ANSWERS✔✔ Disabled When you reload an Excel or csv file with new columns, then the following happens:
• New columns will be shown immediately after reloading
• New columns will not contain any data
• You will get an error
• New columns will be marked as hidden - ACCURATE ANSWERS✔✔ New columns will be marked as hidden Exporting a visualization project creates a:
• txt file
• dva file
• csv file
• bar file - ACCURATE ANSWERS✔✔ dva file

Importing a project can include:

• Associated data sets
• Connection Credentials
• Stored data
• All of the above - ACCURATE ANSWERS✔✔ All of the above You can select the following option to search for hidden items in the catalog:
• Search Hidden Items
• Show Hidden Items
• Inspect Hidden Items
• View Hidden Items - ACCURATE ANSWERS✔✔ Show Hidden Items You can assign the ownership of an item that you created to others.
• True
• False - ACCURATE ANSWERS✔✔ True You can enable other users to access your projects.
• True
• False - ACCURATE ANSWERS✔✔ True Migrating content from one catalog to another is done by:
• Archive and Unarchive

• Download and Upload
• Copy and Paste - ACCURATE ANSWERS✔✔ Archive and Unarchive Maximum number of snapshots that can be kept online:
• 15
• 20
• 5
• 10 - ACCURATE ANSWERS✔✔ 10 Users with the following application role can manage data models:
• BI Consumer
• BI Data model author
• DV Data model author
• DV consumer - ACCURATE ANSWERS✔✔ BI Data model author Predefined application roles can be deleted
• True
• False - ACCURATE ANSWERS✔✔ False Artifacts saved in a snapshot include: (Choose three)
• Catalog
• Data sets
• Application Roles

• Connection string
• Model - ACCURATE ANSWERS✔✔ - Catalog
• Application Roles
• Model Members of application roles can be:
• Users
• Roles
• Application Roles
• All of the above - ACCURATE ANSWERS✔✔ All of the above What is NOT true about a snapshot?
• When you upload a snapshot, the artifacts stored inside will not be immediately available in the environment
• You can download a snapshot to your local system
• Restoring a snapshot will override the existing application roles, catalog, and data model
• A snapshot cannot be migrated from one instance environment to another - ACCURATE ANSWERS✔✔ A snapshot cannot be migrated from one instance environment to another Which of the following features of OAC are in Oracle Cloud?
• timeliness, economical, and flexible
• rapid production innovation

• enterprise-grade reliability
• all of the above - ACCURATE ANSWERS✔✔ all of the above On the home page navigation, how can you access data visualization?
• Click Data
• Click Projects
• none of the above
• Click Console - ACCURATE ANSWERS✔✔ Click Projects Data Visualization allows Data Elements to be added by:
• Drag and drop data elements to a blank canvas
• Drag and drop data elements to drop targets in the Explore pane
• Drag and drop data elements to a visualization
• All of the above - ACCURATE ANSWERS✔✔ All of the above Which service model contains the service "Oracle Analytics Cloud Service" in Oracle Cloud?
• DaaS
• PaaS
• IaaS
• SaaS - ACCURATE ANSWERS✔✔ PaaS What will you do if you aren't sure where to drag and drop any data element over the visualization?

• You can drag and drop element anywhere over the visualization
• You must know the specific drop target
• You cannot drag and drop as it is always automatic
• None of the above - ACCURATE ANSWERS✔✔ You can drag and drop element anywhere over the visualization Which user interface takes a few, simple inputs then automatically creates rich, compelling graphics?
• Data Visualization
• Dashboard
• Analysis
• All of the above - ACCURATE ANSWERS✔✔ Data Visualization How can you change the visualization type?
• In the Explore pane, select another visualization type from the drop- down list
• In the Visualizations pane, select another visualization type
• In the Canvas pane, click Change Visualization type and select another visualization
• All of the above - ACCURATE ANSWERS✔✔ All of the above OAC can integrate any data source quickly.
• True
• False - ACCURATE ANSWERS✔✔ True

How can you customize the pixel height and pixel width of the canvas?

• Access canvas properties
• Access data source properties
• Access visualization properties
• Access data element properties - ACCURATE ANSWERS✔✔ Access canvas properties You might have a project where you added two data sources. Which of the following statements are true? (Choose two)
• You can blend data from one data source with data from another data source
• When you add more than one data source to a project, the system tries to find matches for the data that's added
• All of the above
• You must manually match external dimensions - ACCURATE ANSWERS✔✔ - You can blend data from one data source with data from another data source
• When you add more than one data source to a project, the system tries to find matches for the data that's added Which of the following statements are true?
• You can add data elements to Drop Targets in the Explore pane
• You can add data elements to Visualization Drop Targets
• You can add data elements to a blank canvas

• All of the above - ACCURATE ANSWERS✔✔ All of the above When you save a project, the permissions are synchronized between the project and the external sources that it uses.
• True
• False - ACCURATE ANSWERS✔✔ True Which of the following is required before adding data elements to a blank canvas?
• You cannot add data elements to a blank canvas
• Create a project or open an existing project
• Create a project
• Open an existing project - ACCURATE ANSWERS✔✔ Create project or open an existing project Which permission is required on a data set, for viewing and creating projects?
• Modify
• View
• Write
• Read - ACCURATE ANSWERS✔✔ Read You cannot create a data source from Oracle Applications or Databases by using an existing connection.

• True
• False - ACCURATE ANSWERS✔✔ False Which of the following Data Wrangling Functions are valid for Date Columns? (Choose two)
• Date
• Year
• Month
• Quarter - ACCURATE ANSWERS✔✔ - Year
• Quarter How can you refresh data that you already added?
• You cannot refresh data that you added
• Right click the data source and select reload data
• You must delete the data source and upload again
• None of the above - ACCURATE ANSWERS✔✔ Right click the data source and select reload data Data wrangling does not modify the original columns in the data set. Instead, it creates a new column
• True
• False - ACCURATE ANSWERS✔✔ True

Which of the following methods are true for adding data elements to Visualization Drop Targets? (Choose two)

• Remove data source
• Drag and drop data elements
• Replace a data element
• Swap data source - ACCURATE ANSWERS✔✔ - Drag and drop data elements
• Replace a data element When uploading data from external sources, which are valid data sets?
• File-based data
• Google Analytics
• Oracle Applications Data
• All of the above - ACCURATE ANSWERS✔✔ All of the above A data source either extends a dimension by adding attributes or extends facts by adding measures and optional attributes.
• True
• False - ACCURATE ANSWERS✔✔ True What is the purpose of "Conditional Group" from Column Options menu?
• For applying Group by Functionality on Measures
• For applying Data Wrangling Functions for Attributes

• For applying Group by Functionality on Attributes
• For applying Data Wrangling Functions for Measures - ACCURATE ANSWERS✔✔ For applying Data Wrangling Functions for Measures If you share the project with other users, then the external sources are also shared with those same users.
• True
• False - ACCURATE ANSWERS✔✔ True Which of the following are true about "Subject Area"?
• Contain information about your organization's business areas
• Are named to correspond to the type of information they contain
• Are organized into folders and columns
• All of the above - ACCURATE ANSWERS✔✔ All of the above You cannot link views such that one view drives changes in one or more other views.
• True
• False - ACCURATE ANSWERS✔✔ False You use conditional expressions to create expressions that convert values.
• True
• False - ACCURATE ANSWERS✔✔ True

Which Visualization Type focuses on a single piece of aggregate data?

• Treemap
• Donut Chart
• Performance Tile
• Trends - ACCURATE ANSWERS✔✔ Performance Tile What is the reason for the filters to be displayed in a small gray filter bar within each visualization?
• Auto-Apply Filters is on
• Auto-Apply Filters is off
• Synchronize Visualizations is on
• Synchronize Visualizations is off - ACCURATE ANSWERS✔✔ Synchronize Visualizations is off Which statement is most appropriate about the filter bar?
• Any filters that are added to the filter bar are applied to a particular visualization on all canvases in the project
• Any filters that are added to the filter bar are applied to a particular visualization on a particular canvas in the project
• Any filters that are added to the filter bar are applied to all visualizations on all canvases in the project
• Any filters that are added to the filter bar are applied to all visualizations on a particular canvas in the project - ACCURATE

ANSWERS✔✔ Any filters that are added to the filter bar are applied to all visualizations on a particular canvas in the project How do you create profit that uses the Revenue and Discount Amount measures on Visualization?

• Create Calculated Data Element
• Create attribute
• Modify existing attribute
• Modify existing measure - ACCURATE ANSWERS✔✔ Create Calculated Data Element Which of the following statements is true?
• Filters that you specify on an individual visualization are applied to that canvas after the filters on the filter bar are applied
• Filters that you specify on an individual visualization are applied to all visualizations after the filters on the filter bar are applied
• Filters that you specify on an individual visualization are applied to all canvases after the filters on the filter bar are applied
• Filters that you specify on an individual visualization are applied to that visualization after the filters on the filter bar are applied - ACCURATE ANSWERS✔✔ Filters that you specify on an individual visualization are applied to that visualization after the filters on the filter bar are applied Which of the following statements are true about "Narrate"?
• Narrate can capture key information

• Narrate can contain real time reports
• Narrate enables us to take a snapshot of the report at specific point in time
• All of the above - ACCURATE ANSWERS✔✔ All of the above After you save a story, you can share it with others using the project URL
• True
• False - ACCURATE ANSWERS✔✔ True Which of the following statements are true about "Shaping Stories"? (Choose two)
• You can hide or show Canvas Pages
• You cannot show or hide Narrate title and descriptions
• You can rearrange the Narrate within a story
• All of the above - ACCURATE ANSWERS✔✔ - You can hide or show Canvas Pages
• You can rearrange the Narrate within a story What are the various ways to compose an expression?
• Directly enter text and functions in the Expression Builder
• Add data elements from the Data Elements pane (drag and drop, or double click)
• Add functions from the function panel (drag and drop, or double click)

• All of the above - ACCURATE ANSWERS✔✔ All of the above Which statement is most appropriate about "Keep Selected" option?
• It removes all other members and the linked visualizations
• It keeps only the selected members and the linked visualizations
• It keeps only the selected members and removes all other members
• It keeps only the selected members and removes all other members and the linked visualizations - ACCURATE ANSWERS✔✔ It keeps only the selected members and removes all other members and the linked visualizations Which of the following are true about "Hierarchies"? (Choose three)
• Correspond to the rollup of measure values
• Are either level-based or parent/child (value-based)
• Define member relationships
• Cannot contain nested levels - ACCURATE ANSWERS✔✔ - Correspond to the rollup of measure values
• Are either level-based or parent/child (value-based)
• Define member relationships If you accidentally place a data element in the wrong drop target in a visualization, you cannot reverse your changes easily.
• True
• False - ACCURATE ANSWERS✔✔ False

You can use many options to sort in views. Which of the following are valid options for applying sort on a column? (Çhoose two)

• Sort Ascending
• Add Ascending
• Add Ascending Sort
• Add Descending - ACCURATE ANSWERS✔✔ - Sort Ascending
• Add Ascending Sort Which of the following are true about "Expression Filter"? (Choose two)
• An expression filter becomes a new data element that you can add to your visualization
• You cannot create an expression filter from a calculation
• You can create an expression filter from a calculation
• It appears only in the filter bar and can't be added as a data element to a visualization - ACCURATE ANSWERS✔✔ - You can create an expression filter from a calculation
• It appears only in the filter bar and can't be added as a data element to a visualization Which of the following statements are true about "Analysis"?
• You can quickly create an analysis to query against your organization's data
• The analysis results help you answer your business questions