ExamTopics Logo
Mail Us[email protected]
Menu
Qlikview Discussions
exam questions

Exam QSDA2024 All Questions

View all questions & answers for the QSDA2024 exam
Go to Exam

Exam QSDA2024 topic 1 question 44 discussion

Actual exam question from QlikView's QSDA2024
Question #: 44
Topic #: 1
[All QSDA2024 Questions]

A data architect needs to develop a script to export tables from a model based upon rules from an independent file.
The structure of the text file with the export rules is as follows:
TableToExport, StoreAsFilename, NumberOfCopies

Customers, Clients,3 -

Orders, SalesOrders,1 -

Regions, Countries,2 -
These rules govern which table in the model to export, what the target root filename should be, and the number of copies to export.
The TableToExport values are already verified to exist in the model.
In addition, the format will always be QVD, and the copies will be incrementally numbered.
For example, the Customers table would be exported as:

Clients1.qvd -

Clients2.qvd -

Clients3.qvd -
What is the minimum set of scripting strategies the data architect must use?

  • A. One loop and two IF statements
  • B. One loop and one SELECT CASE statement
  • C. Two loops and one IF statement
  • D. Two loops without any conditional statements
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by Jdossa91 at Jan. 20, 2025, 2:23 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Jdossa91
2 weeks, 1 day ago
Selected Answer: C
FOR EACH row IN ExportRulesFile LET vTable = row.TableToExport; LET vFileName = row.StoreAsFilename; LET vCopies = row.NumberOfCopies; FOR i = 1 TO vCopies IF FileExists(vTable) THEN STORE $(vTable) INTO $(vFileName)$(i).qvd (qvd); END IF NEXT i NEXT row
upvoted 1 times
...
Jdossa91
2 weeks, 1 day ago
Selected Answer: C
o meet the requirements, the script needs to: Loop through the export rules file to process each row (TableToExport, StoreAsFilename, NumberOfCopies). Create multiple copies of the exported files based on the NumberOfCopies value. Use incremental numbering to name the exported files (Clients1.qvd, Clients2.qvd, etc.). The implementation requires two loops: Outer loop: To iterate over each row in the export rules file. Inner loop: To handle the creation of multiple copies for the current table. An IF statement is used to ensure that each table export is handled correctly.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago