Save 15% on 2 packs BUY2 · 20% on 3+ BUY3

Skip to content
Qlik Replicate Exam Practice Questions, practice question pack
Cleared the AZ-104 certification exam on the first attempt. All the credit goes to Certstash as it has 100% questions available.
Aaron MooreAZ-104
Pass, or your money backFail the exam after using this pack and we refund it, or swap it for any other pack. How the guarantee works

Qlik Replicate Exam Practice Questions

Every question comes with the correct answer and a clear explanation.

  • 99% pass rate
  • 60 questions
  • 2 PDFs

US$39Pay in your own currency at checkout

Delivered to your email within 24 hours.

  • Free updates for lifeEvery new version of this pack, emailed to you free.
  • Secure checkoutPayPal or card. Pay once, no subscription.
  • Questions-only copyA second PDF without the answers, for timed practice runs.

What’s insideFAQ

Try before you buy

Five of the 60 questions in this pack

Question 1

Which is the path to add a new column to a single table in task?

Not this one. Try another answer.

Why A is wrong

Table Selection and Schemas are used to pick tables, not add columns.

Not this one. Try another answer.

Why B is wrong

There is no New Transformation path for this.

Right, C is the answer.

Why C is right

In a task you select the table, open its Transform tab and add a new column there.

Not this one. Try another answer.

Why D is wrong

The General tab of Table Settings does not add columns.

Question 2

$AR_H_COMMIT_TIMESTAMP Using Qlik Replicate, how can the timestamp shown be converted to unix time (unix epoch-number of seconds since January 1st 1970)?

Not this one. Try another answer.

Why A is wrong

This converts a fixed unix number into a date and time, which is the opposite direction and ignores the commit timestamp.

Not this one. Try another answer.

Why B is wrong

This works on a fixed number instead of the commit timestamp and does not produce unix time.

Not this one. Try another answer.

Why C is wrong

datetime.datetime is not a SQLite function, so the expression is not valid in Replicate.

Right, D is the answer.

Why D is right

Replicate expressions use SQLite syntax, where strftime with the %s format returns a date as seconds since 1970-01-01. Applying it to $AR_H_COMMIT_TIMESTAMP and subtracting the same function applied to the epoch start gives the commit time as unix time.

Not this one. Try another answer.

Why E is wrong

Time.now.strftime is not SQLite syntax and does not reference the commit timestamp.

Question 3

How should missing metadata be added in a Qlik Replicate task after the task has been stopped?

Not this one. Try another answer.

Why A is wrong

Dropping target tables is not needed to add metadata.

Not this one. Try another answer.

Why B is wrong

Reloading the target reloads the data instead of just the metadata.

Right, C is the answer.

Why C is right

Advanced Run has a metadata only option that refreshes the metadata without reloading data. Stop the task again and resume it.

Not this one. Try another answer.

Why D is wrong

Dropping tables and data is not needed.

Question 4

Which information in Qlik Replicate can be retrieved from the server logs?

Right, A is the answer.

Why A is right

The server log covers server-level matters such as network and performance problems, while task logs hold details of an individual task.

Not this one. Try another answer.

Why B is wrong

Task load status and performance are in the task view and task logs.

Not this one. Try another answer.

Why C is wrong

Specific task information is in the task log, not the server log.

Not this one. Try another answer.

Why D is wrong

Server status is shown in the console, not retrieved from the logs.

Question 5

Which two components are responsible for reading data from the source endpoint and writing it to the target endpoint in Full Load replication? (Choose two.)

Right, A is one of the answers.

Why A is right

During Full Load, SOURCE_UNLOAD covers the source side, where the data is selected from the source tables, and TARGET_LOAD covers the Full Load operations on the target side. These are the two Full Load components.

Not this one. Try another answer.

Why B is wrong

TARGET_APPLY applies changes to the target during change processing, not during Full Load.

Not this one. Try another answer.

Why C is wrong

TARGET_UNLOAD is not one of the Replicate components used for Full Load.

Not this one. Try another answer.

Why D is wrong

SOURCE_CAPTURE is the change capture component on the source side, used in CDC.

Right, E is one of the answers.

Why E is right

During Full Load, SOURCE_UNLOAD covers the source side, where the data is selected from the source tables, and TARGET_LOAD covers the Full Load operations on the target side. These are the two Full Load components.

How much of the Qlik Replicate bank is free?

60 questions in the bank

  • Free sample: 21 questions21 real questions, every answer explained, in one PDF.Download PDF
  • Full pack, US$39All 60 questions. Plus the questions-only PDF, free updates for life, refund if you fail.Get the full pack

Replicate exam questions with answers: all 60 for Qlik Replicate.

  • 60 questions mapped to the Qlik Replicate exam outline
  • Answers and explanations for every question, including the wrong options
  • A questions-only PDF for timed practice runs
  • Email delivery: sent to your email within 24 hours
  • Free updates for life
  • Pass or your money back

This pack is US$39, paid once.

Qlik Replicate exam questions: the short answers

How many questions are on the exam?
Qlik's exam page lists 50 questions in 120 minutes. Qlik says the count and passing score may change.

What score do I need to pass?
Qlik lists a passing score of 54%, and says it may be adjusted to keep a consistent standard.

What makes the Qlik Replicate exam hard

Design is almost half the exam. It is 47% of the topic weights, so know how to set up endpoints, tasks and transformations.

Administration is 23%, troubleshooting 22% and operations 8%.

About the exam

The Qlik Replicate certification tests your skills with Qlik Replicate, the data replication tool. The exam is 50 questions in 120 minutes.

Before you buy

What you get for US$39

  • All 60 questions, each with the correct answer and why the other options are wrong
  • 2 PDFs: the full pack, plus a questions-only copy for timed practice
  • Delivered to your email within 24 hours
  • Updated once a month, with free updates for life, emailed to the address you used at checkout

How a question works

Example: tap an answer, it is marked right or wrong, and the reason for that answer appears under the options.

What do I get?

Every pack comes as 2 PDFs: one with every answer explained, and a questions-only copy for timed practice. Both are delivered to your email within 24 hours, and every pack includes free updates for life.

How often are the questions updated?

Question sets are updated once a month.

Will I receive updates after purchasing?

Yes. All PDF purchases include lifetime updates. Updated versions are emailed automatically to the email address used during checkout.

What if an answer looks wrong?

We correct mistakes as we find them, and the monthly update sends those fixes to you. No question bank this size is ever completely flawless, so if something still looks off to you, check it against the vendor's own documentation and send it to support@certstash.com. We reply to every message, and the fix ships in the next update, free, for life.

Are your materials enough to pass the exam?

Most candidates use them as their main practice source. If you study with them and still fail, we refund you in full.

What happens if I fail my exam?

You get your money back. Sit the exam 7 to 30 days after buying, then email support@certstash.com within 7 days of the exam with your order number and a copy of your official score report showing the fail. Full terms are in the refund policy.

Do you have discount codes?

Yes, when you buy more than one exam pack. For 2 packs, use code BUY2 for 15% off. For 3 or more packs, use code BUY3 for 20% off. Enter the code in the discount box at checkout.

What payment methods do you accept?

Visa, Mastercard and other cards, Apple Pay, Google Pay and PayPal.

Do you offer shipping?

No. All products are digital downloads. There is no physical shipping.

I did not receive my order after payment.

Contact support@certstash.com with your order number and payment confirmation details.