Format: Multiple Choice
Duration: 90 Minutes
Exam Price: $
Number of Questions: 55
Passing Score: 68%
Validation: This exam has been validated against Oracle Cloud Infrastructure 2023.
Policy: Cloud Recertification
Earn associated certifications Passing this exam is required to earn these certifications. Select each certification title below to view full requirements.
Oracle Cloud Data Management 2023 Certified Foundations Associate
Prepare to pass exam: 1Z0-1105-23
The Oracle Cloud Data Management Foundations certification is intended for individuals looking to demonstrate fundamental knowledge of data management services provided by Oracle. This certification is targeted towards candidates with non-technical backgrounds such as those involved in selling or procuring cloud solutions, as well as those with a technical background who want to validate their foundational-level knowledge around core Oracle Data Management services. This exam does not require any hands-on technical experience and is not a prerequisite for taking any other Oracle certifications.
Examkingdom Oracle 1Z0-1105-23 Exam pdf,
Best Oracle 1Z0-1105-23 Free downloads , Oracle 1Z0-1105-23 Dumps at Certkingdom.com
Take recommended training
Complete one of the courses below to prepare for your exam (optional):
Become an Oracle Cloud Data Management Foundations Associate (2023)
Practice Exam
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience), in the learning subscription, provides the best preparation for passing the exam.
Review exam topics
Data Management Introduction
Explain Oracle’s Data Management Strategy
Discuss the different Oracle database offerings and deployment options (on-premises, DBCS, ADB, Exa, 3rd party cloud)
Discuss multi-cloud and hybrid cloud options for managing data using Oracle Cloud
Oracle Cloud Free Tier Account
Explain Oracle Cloud Free Tier Sign-up processes
Discuss the functionality of the OCI Console
Explain the differences and uses of Free vs Always Free
Autonomous Database and Tools
Explore Autonomous Database, the various offerings, and deployment options
Discuss ADB Instance Creation – provision, scale CPU and storage, start, stop, and clone
Describe ADB Tools and how to load data into ADB
Exadata and DBCS
Describe the use cases and business problems Exadata solves
Explain the various Exadata deployment options (C@C, Cloud Service, etc)
Discuss Lifecycle Management (patching, backup & recovery)
Describe DBCS offerings and when to use one over the other
MySQL and NoSQL
Describe MySQL Database Service
Describe NoSQL Service
Converged Database
Describe multi-model and converged database use cases
Explain JSON, graph, and spatial in the Oracle Database
Resiliency
Explain Oracle’s Maximum Security Architecture
Explain Oracle’s Maximum Availability Architecture
Developing an Oracle Database
Explain the processes and concepts to Manage Autonomous Databases: REST, APIs
Describe using database tools, SQL Developer, SQL Worksheet
Describe low-code APEX
Describe CI/CD SQLCl
Data Lake, Data Warehouse and Machine Learning
Discuss concepts and uses of OCI Analytics and AI Data Services
Discuss concepts and uses of Oracle Machine Learning
Explain the data mesh architecture
Upgrades and Migrations
Describe various migration strategies to the cloud
Explain Oracle’s upgrade options
QUESTION 1
Oracle & Automated Machine Learning (AutoML) has options for using in-database and opensource algorithms.
Which is an example of an in-database option?
A. Tuning of hyperparameter
B. Oracle Machine Learning for Python (OML4Py) APIs
C. REST Interface
D. Cognitive text
Answer: B
QUESTION 2
Which feature allows you to logically group and isolate your Oracle Cloud Infrastructure re-sources?
A. Availability Domain
B. Tenancy
C. Identity and Access Management Groups
D. Compartments
Answer: D
Explanation:
Compartments are a feature that allows you to logically group and isolate your Oracle Cloud
Infrastructure resources. According to the Oracle documentation2, “Compartments are a
fundamental component of Oracle Cloud Infrastructure that allow you to create a heterogeneous
collection of resources for organization, security isolation, and access control. To learn more about
compartments, see Managing Compartments . Organize your cloud resources in logically separate
compartments, for the purposes of measuring usage and billing, controlling access, and isolating
resources.
QUESTION 3
What are two important reasons to upgrade and patch? (Choose all correct answers)
A. Restructure the database
B. Security
C. Validation of application
D. Support Compliance
Answer: B, D
Explanation:
Security and support compliance are two important reasons to upgrade and patch your Oracle
Database. According to the Oracle blog3, “Security is one of the most important reasons to patch
your database. Every quarter Oracle releases security patches as part of the Critical Patch Update
(CPU) program. These patches fix vulnerabilities in the database software that could be exploited by
malicious attackers.” Additionally, according to the Oracle blog4, “Support compliance is another
reason to patch your database. Oracle provides different levels of support for different versions of
the database software. To be eligible for certain support services, such as Extended Support or
Sustaining Support, you need to apply the latest patches available for your version.”
QUESTION 4
Which is NOT an option in Database Actions to load data into Autonomous Database?
A. Load data from a local file such as text or Excel
B. Load data using FTP
C. Load data from cloud storage (Oracle, S3, Azure, Google)
D. Load data from a remote database
E. Load data using Data Pump
Answer: B
Explanation:
Loading data using FTP is not an option in Database Actions to load data into Autonomous
Database. According to the Oracle documentation5, “On the Database Actions Data Load page you
can choose to load data from a file on your local device, from cloud storage, or from a database. You
can also choose to explore the data in your Oracle Autonomous Database.” There is no mention of
FTP as a source for loading data.
QUESTION 5
The Oracle Cloud Infrastructure (OCI) Data Catalog is an integral part of the Lakehouse so-lution.
What level of data detail does Data Catalog provide when integrated with Autonomous Databases and Object storage?
A. View of data for discovery
B. Data Warehouse
C. Source of managed services
D. Analytic environments
Answer: A
Explanation:
View of data for discovery is the level of data detail that Data Catalog provides when integrated with
Autonomous Databases and Object storage. According to the Oracle documentation6, “Oracle Cloud
Infrastructure Data Catalog is a fully managed, self-service data discovery and governance solution
for your enterprise data. Data Catalog helps you maximize the value of your data assets by providing
a rich set of capabilities that enable you to discover, explore, organize, enrich, and trace data lineage
on various types of data sources.” Data Catalog provides a view of data for discovery by using
metadata to create an informative and searchable inventory of all data assets in an organization.