Oracle Cloud Platform Data Integration 2020 Specialist — Question 16

You are processing millions of files in an Oracle Cloud Infrastructure (OCI) Object Storage bucket. Each time a new file is created, you want to send an email to the customer and create an order in a database. The solution should perform and minimize cost.
Which action should you use to trigger this email? (Choose the best answer.)

Answer options

• A. Schedule a cron job that monitors the OCI Object Storage bucket and emails the customer when a new file is created.
• B. Use OCI Events service and OCI Notification service to send an email each time a file is created.
• C. Schedule an Oracle Function that checks the OCI Object Storage bucket every minute and emails the customer when a file is found.
• D. Schedule an Oracle Function that checks the OCI Object Storage bucket every second and emails the customer when a file is found.

Correct answer: C

Explanation

The correct answer is C, as it uses an Oracle Function to periodically check for new files in a cost-effective manner. Option A is less efficient because it relies on cron jobs, which may have delays. Option B, while functional, may incur higher costs with both the Events and Notification services. Option D checks too frequently, which could lead to unnecessary costs and resource consumption.