- Read Me First!
-
Exam Instructions
- Exam
-
Quickbase Pipelines Builder Certification Exam
- Survey
-
What Do You Think?
2023 Certification - Pipelines Builder
Exam has 60 questions, a 75 minute time limit, and a passing score of 73%
This Pipelines Builder exam is designed to validate core skills for Quickbase builders who are building data integrations using Pipelines. It covers pipeline designing and building, data transformation, testing, and troubleshooting. It focuses primarily on the Quickbase channel and Bucket channel, but includes concepts around working with other channels and files.
Exam details
Exam Price: $150 Note: This exam will be offered at $99 for a limited time.
Exam Time: 1.25 hours
Exam Question Items: 60
Passing Score: 73
Exam Prerequisites: Either success on the App Builder Certification Exam or Combined App/Expert Certification Exam are required before this exam can be attempted.
Sample Questions: This document shows the general approach of questions on the exam, but is not intended to show its full scope. Please see "Exam topics" below for this.
Taking the exam
- No references or resources should be used while taking the exam
- Once you start, you must complete your exam in 75 minutes
- The purchased exam is for your use and may not be distributed in any format
You must disable pop-ups prior to beginning the exam. Select for instructions.
Recommended preparation
The designated learning path at Quickbase University: Path to Pipelines Builder Certification
This comprehensive path includes the following courses: Getting Started with Pipelines, Managing Pipelines in the My pipelines Page, Building Powerful Pipelines Using included Features, Pipeline Building and Editing, Pipeline Best Practices, Testing, Tips, and Tricks, and Managing Files with Pipelines.
Pipelines Help documentation, especially around basic Jinja filters for transforming dates and data.
Exam topics
The exam content consists of multiple-choice questions that cover the topics and job tasks expressed in the following table.
| Pipeline Concepts and Design | Explain pipeline concepts | Explain the differences between a dynamic versus a static schema; Describe the order of results in a search or query; Understand triggers and pollers: If a pipeline's record created doesn't trigger immediately, why would that be? |
| Plan your pipeline | Plan your pipeline | |
| Pipeline Building and Editing | Perform basic tasks | Create a new pipeline; Add a step to a pipeline; Use a trigger to start a pipeline; Schedule a pipeline; Turn on a pipeline; Run a pipeline; Refresh schemas; Sync a pipeline |
| Edit a pipeline | Add a description to a pipeline; Rename a pipeline; Duplicate a pipeline; Add steps to an existing pipeline | |
| Use conditions | Add conditions to a query step in a pipeline; Insert a condition in a pipeline and define the if, then, and else blocks; Add conditions to an action or a trigger (and also to a checkbox field); Describe the execution of steps in a pipeline that contains a condition with the if, then, and else blocks defined (both within and outside the branches) | |
| Limit returned records | Limit returned records | |
| Link and fetch records | Link records between pipelines; Fetch records from another pipeline; When fetching a record, check if the fetched record exists; Describe the concepts of linking and fetching; Sync a Quickbase record with a record in a 3rd party system | |
| Work with files and attachments | Work with files and attachments in channels; Describe when to use download_url vs file_transfer_handler when working with files and attachments | |
| Data Transformation | Transform data using the jinja expression language | Convert the date to a future or past date/Set a relative time; Specify the date format; Use a numeric calculation; Clear a field; Modify variables using filters; Add a time zone filter |
| Quickbase Channel | Create records | Create a new record if it does not already exist; Create child records; Create child records from template records; Create child records from template records based on a condition; |
| Delete records | Delete child records when a Parent is deleted | |
| Import records | Use the Quickbase channel's Import with CSV action to import bulk record sets | |
| Update records | Update a record | |
| Included Channels | Use the Bucket Channel | Create a temporary table; Add rows to a temporary table; Use the Download CSV action |
| Pipeline Administration and Management | Activate and connect to channels | Activate a channel; Create a Quickbase user token; Connect to the Quickbase channel; Connect to 3rd party channels; Search for pipelines |
| Pipeline Best Practices, Testing, and Troubleshooting | Build for efficiency | Avoid an infinite loop; Build pipelines for later manageability; Optimize a pipeline for number of stepruns; Optimize a pipeline for faster execution |
| Test a pipeline | Test a pipeline | |
| Troubleshoot a pipeline | Access the activity log; Allow CSR access to a pipeline; Search the activity log and evaluate the returned data; Define and handle a transient error; Understand what a pipeline run is and use this information to help debug a pipeline |
Exam ID: CV017