Qlik Exam QREP Topic 2 Question 3 Discussion

Actual exam question for Qlik's QREP exam

Question #: 3
Topic #: 2

[All QREP Questions]

A Qlik Replicate administrator is replicating data from a source system with some columns with large PDFs. Which data type should be used?

ADLOB

BNCLOB

CNVARCHAR(IOOO)

DBLOB

Show Suggested Answer

Suggested Answer: D

For replicating columns that contain large PDFs, the appropriate data type to use in Qlik Replicate is:

D . BLOB: This stands for Binary Large Object and is the data type used for storing large binary data such as PDF files. The BLOB data type is suitable for handling the size and binary nature of PDF files1.

The other options are not suitable for the following reasons:

A . DLOB: This is not a recognized data type in Qlik Replicate.

B . NCLOB: NCLOB, or National Character Large Object, is used for storing large text data in the national character set and is not optimal for binary data like PDFs.

C . NVARCHAR(1000): NVARCHAR is a character data type with a specified length, which would not be suitable for large binary objects like PDFs due to size limitations and the nature of the data.

For more information on data types and their usage in Qlik Replicate, you can refer to the official Qlik Replicate documentation on Replicate data types.

by Kristel at Aug 06, 2024, 09:09 PM

Limited Time Offer

25%

Off

Get Premium QREP Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Val

10 months ago

Hmm, BLOB sounds like the obvious choice here. Unless the PDFs are secretly encoded in alien hieroglyphics, in which case NCLOB might be the way to go.

upvoted 0 times

...

Sherell

10 months ago

NVARCHAR(1000)? Really? That's not going to cut it for PDFs, unless they're all under 1KB. BLOB is the way to go, no doubt.

upvoted 0 times

Coletta

9 months ago

Yeah, NVARCHAR(1000) is definitely not suitable for that kind of data.

upvoted 0 times

...

Pete

9 months ago

I agree, BLOB is definitely the best choice for large PDFs.

upvoted 0 times

...

Edda

10 months ago

That's a good point, but I still think DLOB is more suitable for this scenario.

upvoted 0 times

...

Leonida

10 months ago

I disagree, I believe the correct answer is BLOB as it is commonly used for storing binary large objects.

upvoted 0 times

...

Edda

10 months ago

I think the answer is DLOB because it is specifically designed for large PDFs.

upvoted 0 times

...

Val

10 months ago

I think NCLOB might also be a good option for handling large PDFs, as it is designed for character data.

upvoted 0 times

...

Ezekiel

10 months ago

DLOB? What is that, some kind of new data type I haven't heard of? I'm going with BLOB, the classic choice for handling large binary data.

upvoted 0 times

Alesia

9 months ago

I think NVARCHAR(IOOO) is for handling large Unicode character data, so it might not be the best option for large PDFs.

upvoted 0 times

...

Chantell

9 months ago

I've used NCLOB before for handling large character data, but I'm not sure if it's the best choice for large PDFs.

upvoted 0 times

...

Anika

9 months ago

I agree, but I'm still going with BLOB for handling large binary data.

upvoted 0 times

...

Georgeanna

10 months ago

I think DLOB stands for Data Large Object, it might be a new data type for handling large PDFs.

upvoted 0 times

...

Augustine

10 months ago

But DLOB is specifically designed for large objects like PDFs, so it should be the most suitable choice.

upvoted 0 times

...

Jamal

10 months ago

NCLOB seems like the best option to me. It's designed for storing large character data, and PDFs are basically just text, right?

upvoted 0 times

Kattie

10 months ago

Yes, NCLOB is specifically designed for handling large amounts of character data, so it would be the most suitable option for storing PDFs.

upvoted 0 times

...

Raymon

10 months ago

I agree, NCLOB is the best choice for storing large character data like PDFs.

upvoted 0 times

...

Linwood

10 months ago

I disagree, I believe the best option is BLOB for large PDFs.

upvoted 0 times

...

Thomasena

11 months ago

I think BLOB is the way to go here. It's made for handling large binary data like PDFs.

upvoted 0 times

Kaycee

10 months ago

I would go with BLOB as well, it's specifically designed for handling binary data.

upvoted 0 times

...

Jules

10 months ago

I think DLOB could also work well for this situation.

upvoted 0 times

...

Daren

10 months ago

I agree, BLOB is the best choice for handling large PDFs.

upvoted 0 times

...

Augustine

11 months ago

I think the correct data type to use is DLOB.

upvoted 0 times

...