CTFA Sample Exam Questions

The following questions are representative of the types of questions you will find on the examination.

a. Tell the advisor he must first obtain the consents of the current beneficiary and presumptive remaindermen.b. Confront the advisor and, if the situation cannot be remedied, seek court guidance.c. Follow the advisor's directions nonetheless.d. Obtain the written consent of all fiduciaries. 

a. Leave everything to his wife in his will.b. Give $14,000 per year to each of his two children.c. Incorporate a credit shelter trust provision in his will.d. Transfer the house ownership completely to his wife.

a. 401(k)b. Money Purchase Pension Planc. Profit Sharing Pland. Rabbi Trust

a. John's deathb. Sam's deathc. The creation of the trustd. The appointment of the executor or administrator of Sam's estate

a. A 10% Treasury bond is more attractive than a 7.2% municipal bond issued by a state of which the client is not a resident.b. A 6.0% bond issued by the client's state of residence is more attractive than a 7.2% municipal bond issued by another state.c. An 18% corporate bond is more attractive than a 12% municipal bond issued by the client's state of residence.d. A 6.75% municipal bond issued by the client's state of residence is more attractive than a 7% municipal bond issued by a U.S. territory.

1. b2. c3. d4. a5. a​

Best Database (DBA) and SQL Certifications for 2023

While database platforms have come and gone through the decades, database technology is still critical for multiple applications and computing tasks. IT professionals often seek database certifications to demonstrate their knowledge and expertise as they navigate their career paths and pursue professional growth. 

While database certifications may not be as bleeding edge as Google cloud certifications, cybersecurity certifications, storage certifications or digital forensics certifications, database professionals at all levels possess in-demand career skills — and a plethora of database-related jobs are waiting to be filled.

We’ll look at some of the most in-demand certifications for database administrators, database developers and anyone else who works with databases.

To get a better grasp of available database certifications, it’s helpful to group these certs around job responsibilities. This reflects the maturity of database technology and its integration into most aspects of commercial, scientific and academic computing. As you read about the various database certification programs, keep these job roles in mind: 

These database job roles highlight two critical issues to consider if you want to be a database professional:

NoSQL databases — called “not only SQL” or “non-relational” databases — are increasingly used in big data applications associated with some of the best big data certifications for data scientists, data mining and warehousing, and business intelligence.

Here are details on our five best database certification picks for 2023.

IBM is one of the leaders in the worldwide database market by any objective measure. The company’s database portfolio includes industry-standard DB2, as well as the following:

IBM also has a long-standing and well-populated IT certification program that has been around for more than 30 years and encompasses hundreds of individual credentials. 

After redesigning its certification programs and categories, IBM now has a primary data-centric certification category called IBM Data and AI. It includes a range of database credentials: 

IBM’s is a big and complex certification space, but one where particular platform allegiances are likely to guide readers toward the handful of items most relevant to their interests and needs. 

Database professionals who support DB2 (or aspire to) on IBM’s z/OS should check out the IBM Associate Certified DBA — Db2 12 certification. It’s an entry-level exam that addresses routine planning, working with SQL and XML, security, operations, data concurrency, application design, and concepts around database objects.

This certification requires candidates to pass one exam. Pre-exam training and familiarity with concepts, or hands-on experience, are recommended but not required. 

Certification name

IBM Certified Database Administrator — Db2 12 (z/OS)

Prerequisites and required courses

None required; recommended courses are available.

Number of exams

One: C1000-122: Db2 12 for z/OS DBA Fundamentals (63 questions, 90 minutes)

Cost per exam

$200 (or local currency equivalent) per exam. Sign up for exams at Pearson VUE.

URL

https://www.ibm.com/training/certification/C8003803

Self-study materials

The certification page includes self-study materials, including a study guide and a learning path. 

Did you know? IBM’s certification offerings are among the best system administrator certifications IT professionals can achieve.

Microsoft Azure offers a broad range of tools and add-ons for business intelligence. Azure is a cloud computing platform for application management and Microsoft-managed data centers. Microsoft certifications include various Azure offerings based on job role and experience level.

Microsoft’s certification program is role-centric, centered on the skills you need to succeed in specific technology jobs. Because Azure has such a broad scope, Azure certifications span multiple job roles. However, specific certifications exist for the following positions:

There are also certifications for learners at different experience levels. 

For those looking to take their Azure knowledge to the next level, the Microsoft Certified: Azure Data Fundamentals certification is the perfect place to start. This certification is for beginner database administrators interested in using Azure and mastering data in the cloud. It offers foundational knowledge of core concepts while reinforcing concepts for later use in other Azure role-based certifications, such as those listed below: 

Certification name

Microsoft Certified: Azure Data Fundamentals

Prerequisites and required courses 

This certification does not have any prerequisites. However, for absolute beginners, Microsoft offers an Azure Fundamentals certification. 

Number of exams

One exam, DP-900, which is administered via Pearson VUE or Certiport.

Cost per exam

The exam costs $99 in the United States, though the cost changes based on where it is proctored. 

URL

https://learn.microsoft.com/en-us/certifications/exams/dp-900

Self-study materials

Microsoft offers one of the world’s largest and best-known IT certification programs, so the exam is well supported with books, study guides, study groups, practice tests and other materials. Microsoft also offers a free online learning path.

Oracle runs its certifications under the auspices of Oracle University. The Oracle Database Certifications page lists separate tracks depending on job role and product. MySQL is perhaps the leading open-source relational database management system (RDBMS). Since acquiring Sun Microsystems in 2010 (which had previously acquired MySQL AB), Oracle has rolled out a paid version of MySQL and developed certifications to support the product. 

If you’re interested in pursuing an Oracle MySQL certification, you can choose between MySQL Database Administration and MySQL Developer. 

The Oracle Certified Professional, MySQL 5.7 Database Administrator (OCP) credential recognizes professionals who can accomplish the following tasks:

The certification requires candidates to pass a single exam (the same exam can be taken to upgrade a prior certification). Oracle recommends training and on-the-job experience before taking the exam.

Did you know? According to Oracle, approximately 1.8 million Oracle Certified professionals globally hold certifications to advance their networking careers and professions to validate their IT expertise. 

For individuals interested in working in the Oracle environment who have the necessary experience to become a database administrator, Oracle’s Database SQL Certified Associate Certification is another top Oracle certification and an excellent starting point. This exam encompasses an understanding of fundamental SQL concepts that individuals must grasp for database projects. 

By earning the certification, individuals demonstrate that they have a range of knowledge in core SQL concepts:

This certification also requires candidates to pass a single exam. While Oracle does not specify any prerequisites, the company does state candidates should have familiarity working with the command line. 

SAP SE has an extensive portfolio of business applications and analytics software, including cloud infrastructure, applications and storage. The SAP HANA platform’s foundation is an enterprise-grade relational database management system that can be run as an appliance on-premises or in the cloud. The cloud platform lets customers build and run applications and services based on SAP HANA. 

SAP offers a comprehensive certification program built to support its various platforms and products. We’re featuring the SAP Certified Technology Associate — SAP HANA cert because it aligns closely with other certifications we’ve highlighted and is in high demand among employers, according to job board surveys. 

This certification ensures database professionals can install, manage, monitor, migrate and troubleshoot SAP HANA systems. It covers the following skills:

SAP recommends that certification candidates get hands-on practice through formal training or on-the-job experience before attempting this exam. The SAP Learning Hub is a subscription service that gives certification candidates access to a library of learning materials, including e-learning courses and course handbooks. 

The annual subscription rate for individual users on the Professional certification track is $2,760. This online training program is designed for those who run, support, or implement SAP software solutions. Though this may seem like a steep price for online training, you will likely be able to pass any SAP certification exams you put your mind to by leveraging all the learning resources available to SAP Learning Hub Professional subscribers. 

Typically, SAP certifications achieved on one of the two most recent SAP solutions are considered current and valid. SAP contacts professionals whose certifications are nearing end-of-life status and provides information on maintaining their credentials.

Certification name

SAP Certified Technology Associate — SAP HANA 2.0 SPS05

Prerequisites and required courses    

None required.

Recommended: Hands-on experience and the following courses: 

Number of exams

One exam: SAP Certified Technology Associate — SAP HANA 2.0 SPS05, exam code C_HANATEC_17 (80 questions, 180 minutes)

Cost per exam

$500

URL

https://training.sap.com/certification/c_hanatec_17-sap-certified-technology-associate—sap-hana-20-sps05-g/

Self-study materials

The certification web page includes a link to sample questions. SAP HANA trade books and certification guides are available on Amazon. The SAP Help Center offers product documentation and a training and certification FAQs page. The SAP Learning Hub (available on a subscription basis) provides access to online learning content.

Tip: To broaden your skill set, consider pursuing the best sales certifications to better sell and implement various IT solutions, including databases.

Additional database certification programs can further the careers of IT professionals who work with database management systems. 

While most colleges with computer science programs offer database tracks at the undergraduate, master and Ph.D. levels, well-known vendor-neutral database certifications exist, including the following: 

These are some additional certifications: 

These credentials represent opportunities for database professionals to expand their skill sets — and salaries. However, such niches in the database certification arena are generally only worth pursuing if you already work with these platforms or plan to work for an organization that uses them.

Key takeaway: Pursuing additional database certifications can be helpful for professional development if you already work with these platforms or plan to work with them in the future. 

Before pursuing certifications, consider their popularity with employers to gain a helpful perspective on current database certification demand. Here’s a job board snapshot to give you an idea of what’s trending.

Certification

SimplyHired

Indeed

LinkedIn Jobs

LinkUp

Total

IBM Certified Database Administrator — DB2

867

1,337

1,911

753

4,868

Azure Data Fundamentals

2,052

4,154

283

2,322

8,811

Oracle Certified Professional, MySQL Database Administrator

339

473

143

23

978

Oracle Database SQL Certified Associate Certification

138

177

10

273

598

SAP HANA

32

37

57

466

592

If the sheer number of available database-related positions isn’t enough motivation to pursue a certification, consider average salaries for database administrators. SimplyHired reports $91,949 as the national average in the U.S., ranging from $64,171 to over $131,753. Glassdoor’s reported average is somewhat lower at $84,161, with a top rung for experienced senior DBAs right around $134,000.

Choosing the best IT certifications to enhance your skills and boost your career can be overwhelming, especially as many available certifications are for proprietary technologies. While picking a database certification can feel like locking yourself into a single technology family, it is worth remembering that many database skills are transferable. Additionally, pursuing any certification shows your willingness to learn and demonstrates competence to current and future employers. 

Ultimately, choosing which certification to pursue depends on the technologies you use at work or would like to use at a future employer.

Jeremy Bender contributed to the reporting and writing in this article. 

Sample exam questions - space physics

Multiple choice questions are perhaps the easiest to complete - you simply put a cross in a box - however, the questions often have two answers that could, at first glance, be correct. Don’t make the mistake of reading the first answer and thinking this is correct without checking all the others.

If it says 'Tick one box', you must tick one box. If you leave it blank or tick two or more boxes, you will get zero marks. These multiple choice questions will not start with command words like ‘Describe...’ or ‘Explain...’. They will be written in the form of a question like ‘What...?’ or ‘Why...?’.

There will be more multiple choice questions on the Foundation paper.

This page contains AQA material which is reproduced by permission of AQA.