FAW Oracle Exam Questions & Answers 2024/2025
FAW as an application is built on Oracle Cloud Infrastructure (OCI) and is based on which two other Oracle PaaS Cloud Services: - ANSWERSOracle Autonomous Data Warehouse (ADW)
Oracle Analytics Cloud (OAC)
Options for 'intended use' when creatin...
FAW as an application is built on Oracle Cloud Infrastructure (OCI) and is based on which two other
Oracle PaaS Cloud Services: - ANSWERSOracle Autonomous Data Warehouse (ADW)
Oracle Analytics Cloud (OAC)
Options for 'intended use' when creating FAW instance: - ANSWERSDevelopment/Test and Production
FAW schema can be customized in 2 ways: - ANSWERSdata augmentation, custom ETL
You can use the Admin user to connect to ADW, but the embedded ADW provides a user called -
ANSWERSOAX User
OAX User and Admin user share the same _ - ANSWERSpassword
Unlike Admin user, you can use the OAX User to create a _ - ANSWERScustom schema
The OAX User has what level access to the underlying ADW tables that come out of the box? -
ANSWERSRead-only access
Creating a compartment for the Oracle FAW instances allows you to limit what? - ANSWERSTo limit the
access of the Group to only those services within the compartment
It's best practice to create a new compartment before you _ - ANSWERScreate an FAW instance
Best practices to check before creating FAW instance - ANSWERSEnsure pre-requisites are met
Ensure resources with required skills are available during the execution
Confirm instance name and intended use (test/prod)
,Get the source application URL and user's password
Be ready with ADMIN password for ADW
Be ready with a "notification email"/email ID (best to use a dist. list)
Can you change the name of an instance? Can you create a vanity URL? - ANSWERSNo
Can you change the source Fusion Application after you created the instance? - ANSWERSYes you can but
you may need to reset the warehouse
T/F: You cannot change the ADW password once created - ANSWERSFalse
T/F: You can restrict access to FAW by IP Range - ANSWERSTrue
T/F: You can create the instance in a Private Network - ANSWERSTrue
OCI Identity Domains being merged are: - ANSWERSOCI - IAM and IDCS (Both are being merged into a
unified OCI-IAM service)
Within the context of FAW, we call ETL the _ - ANSWERSdata pipeline
Resources/roles required to implement Data Pipeline - ANSWERSFusion Analytics Admin
Fusion Analytics Functional Admin
Fusion Application Admin
Fusion Application Security Admin (for HCM LBAC)
Fusion Application Domain Knowledge Specialist
Fusion Analytics Data Pipeline is _ to the customer - ANSWERSa black box (meaning that underlying tools
used to extract, transform, and load data from the source Fusion app to FAW are not exposed, customers
and implementers do not have any access to it)
, T/F: Customers and Implementers need ETL tool specific skills to configure and execute the prebuilt data
pipeline - ANSWERSFalse
Who is responsible for the smooth operations of the data pipeline 24/7? - ANSWERSOracle Cloud
operations team
T/F: If you change the any of the global Pipeline Parameters, you must reset the data warehouse and
reactivate the functional areas - ANSWERSTrue
T/F: You can change the global Pipeline Parameters at any time after configuring the data pipeline
without any impact - ANSWERSFalse
You would only disable the Data Pipeline Status when: - ANSWERSwhen you want to stop incremental
data loads into FAW
Most implementations will have which upload schedule - ANSWERSdaily (interval field)
Under Reporting Configurations when configuring the data pipeline, set the 'Allow Financial Category
Upload' to Yes (Y), if you want to: - ANSWERSIf you want to upload financial categories in FAW and
manage them in FAW
Request history shows updates made only after _ - ANSWERSThe scheduled incremental refresh is
executed
Executing an on-demand data refresh might cause _ - ANSWERSTemporary data inconsistencies
During the creation of the FAW instance, you have to provide the Fusion Application connection details
and authentication information.
Which method of authentication is recommended by Oracle?
A.
JSON Web Token
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Bensuda. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.
