This post covers the Q/A’s from Day1 of DBA to Oracle Certified Cloud DBA [1Z0-160] Training. This will help you to understand what you should learn or look for when appearing for Oracle Cloud Database Certification (1Z0160).
Infrastructure as a Service (IaaS): Infrastructure as a Service (IaaS) contains the basic building blocks for cloud IT and it provides access to networking features, computers (virtual or on dedicated hardware), and data storage space.
Platform as a Service (PaaS): Platform as a Service (PaaS) removes the need for your organization to manage the underlying infrastructure (hardware and operating systems) and allows you to focus on the deployment and management of your applications.
Software as a Service (SaaS): is a software distribution model in which a third-party provider hosts applications and makes them available to customers over the Internet. In most cases, people referring to Software as a Service are referring to end-user applications.
Q1). Please elaborate pricing model. If the initial signup is available only for 30 Days. How we can continue to use it for personal use without spending too much as it is in AWS.
Ans: You can terminate your cloud account & extend it to pay as you go account.
Note: In the free trail cloud account you will get $300 for 30 days (depends on your region & location). You can create a new free cloud account with new email id & Phone number. Please, Shutdown all the services when not in use so that your free credit will not expire before date.
Q2). In the SaaS model if we face any issue with the database/application and if any patch/bug fix needs to be applied. Who would take care of it? Customer or Cloud vendor?
Ans: For SaaS & Oracle Managed PaaS, Oracle will apply patches whereas for Customer Managed PaaS & IaaS patching is Customer’s responsibility.
Q3). How application will connect to the database if it is running as DBCS and who will manage the firewall.
Ans: You as DBA will have access to configure the firewall (Security Rule). It’s same like on-premise and depends on where Application hosts, and you can connect using VPN, Fast Connect, or over the internet.
Q4). Please explain little more on the difference between Oracle Exadata cloud service and Exadata service.
Ans: Oracle Database Exadata Cloud Service enables you to leverage the combined power of Exadata and Oracle Cloud. You have full access to the features and operations available with Oracle Database, but only with Oracle owning and managing the Exadata infrastructure. Wherein Exadata Service, Exadata box will be deployed on your company premise and either you or Oracle will be managing the things based on your plan.
Q5). As we can create more than one DB in DBCS Exadata system, How is pricing done is it per DB or per bare metal host.
Q6: What is user OPC (Oracle Public Cloud)?
Ans: The system administrator account you use to connect to the compute node using SSH. This user can use the sudo command to perform operations that require root-user access.
Q8). If I need multiple database instances. Do I need to provision multiple DBaaS?
Ans: Yes you need to provision multiple DBaaS wherein as of NOV 2018 multiple database creation is only supported in Bare Metal & Exadata Cloud Service.
Q9). Is it possible to add more PDBs to the existing CDB on DBaaS, will the price change? If yes then what’s the advantage of adding more PDB to the existing CDB, then to create a new CDB with PDB.
Ans: Yes you can add more PDBs as long as you are using the correct edition if you are using enterprise edition & above you can add more PDB’s. You can’t create 4 PDBs in a system which has only 1 CPU & only 7.5 GB of RAM so you have to use a better infrastructure. That’s the advantage & the disadvantage. You have to look for an essentially good system which has more memory & compute to create more PDB’s & if you do not scale then there is no point in creating more PDB’s.
Q10). In a private cloud, whether we will have the option of pay as we use.
Ans: There is no pay as you go for cloud at customer, You will subscribe for minimal hardware & then you will pay for cloud services.
Keep an eye on our next post. Many things to learn in Oracle Cloud!!
How To Become Oracle Database Cloud Certified?
Beginner to Expert Oracle Cloud DBA, 12 Point Check List, Even If You Are Not a DBA?
Have You Started Your Journey for Oracle Cloud Services DBCS Certification[1Z0-160]?