[Mar-2023] QSDA2022 Pre-Exam Practice Tests Exam Questions and Answers for Qlik Sense Data Architect Study Guide [Q43-Q62]

[Mar-2023] QSDA2022 Pre-Exam Practice Tests | Exam Questions and Answers for Qlik Sense Data Architect Study Guide

Qlik Sense Data Architect Certification Exam - 2022 Certification Sample Questions

NEW QUESTION 43
Refer to the exhibits.

While debugging an app, a developer loads data from an application layer QVD file.
In the process of separating a concatenated key into two parts, some split results are missing data What should the data architect do?

A. Wrap an IF() function around the SUBFIELDQ functions to check and adapt to null values character
B. In the SUBFIELDfunction, replace the '- with a '|' or '-' character
C. Utilize a combination of LEFT(), MID(), and RIGHT() functions to capture the key components
D. In the SUBFIELD function, replace the '_' with a '|' or '_' character.
While debugging an app, a developer loads data from an application layer QVD file.
In theprocess of separating a concatenated key into two parts, some split results are missing data What should the data architect do?
E. Wrap an IF() function around the SUBFIELD() functions to check and adapt to null values
F. Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field
G. Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field
H. Utilize a combination of LEFT(), MID(), and RIGHTO functions to capture the key components

Answer: B

NEW QUESTION 44
Refer to the exhibits.

A music teacher needs to know which artists are eligible to enter this year's competition.
The teacher needs to find only the artists who have a music grade rank above two and play more than one instrument.
Which expression is needed for the Number of Instruments measure in the table?

A. Count({S<Count(Instrument)={">=2"}, Grades={">2"}>}Instrument)
B. Count ({S<Artist={"=Count(Instrument)>=2M}, Grades={">2"}>}Instrument)
C. Count({$<Artist={"=Count(Instrument)>=2"}, Artist={"=Grade>2"}>}Instrument)
D. Count({$<Instrument={">=2"}, Artist={"=Grade>2"}>}Instrument)

Answer: C

Explanation:
Explanation
The correct expression to use for the Number of Instruments measure in the table is Option A.
This expression will count the number of instruments played by artists with a music grade rank greater than two.
How to build a data architecture to drive innovation--today and ...
https://www.mckinsey.com/capabilities/mckinsey-digital/our-insights/how-to-build-a-data-architecture-to-drive- Big data in healthcare: management, analysis and future prospects ...
https://journalofbigdata.springeropen.com/articles/10.1186/s40537-019-0217-0 Obtaining Data From Electronic Health Records - Tools and ...
https://www.ncbi.nlm.nih.gov/books/NBK551878/

NEW QUESTION 45
A data architect needs to write theexpression for a measure on a KPI to show the sales person with the highest sales The sort order of the values of the fields is unknown When two or more sales people have sold the same amount, the expression should return all of those sales people Which expression should the data architect use?

A. Concat (DISTINCT IF (Aggr (Rank (Sum (Sales) , 1) , Salesperson) =1, Salesperson) , ' ')
B. Concat(DISTINCT IF (Aggr (Rank (Sum (Sales) , 4) , Salesperson) =1, Salesperson) , ' ')
C. FirstSortedValue (Salesperson, -Aggr (Sum(Sales) , Salesperson) )
D. FirstSortedValue (DISTINCT Salesperson, -Aggr (Sum(Sales) , Salesperson) )

Answer: A

NEW QUESTION 46
A data architect is building a model to show trends in visualizations across seven date fields. The seven date fields reside in different tables. The data architect must efficiently build this data model.
Requirements:
* A single date selector
* Show all dates, even those with NO activity
* Minimize the impact on server resources and p
Which two solutions should the data architect use? (Select two.)

A. Canonical calendar
B. Multiple calendars
C. Data island
D. Generic load
E. Link table

Answer: A,E

Explanation:
Explanation
A canonical calendar should be used to create a single date selector that can be used to show all dates, even those with no activity. A link table should be used to join the seven date fields from different tables, which willminimize the impact on server resources and performance.Source: Qlik

NEW QUESTION 47
A company has a stream with multiple apps One of the apps is a multi-regional sales app.
A data architect must set up security for users to access the stream, enter the app, and view specific sheets and data.
Whichfeatures should the data architect use to meet these requirements?

A. QMC security rules and section access
B. QMC security rules and custom properties
C. Section access and sheet properties
D. Section access and set analysis

Answer: A

NEW QUESTION 48
Refer to the exhibit.

A data architect needs to add a Budget table to the current Qlik Sense app. A Budget table with the fields Budget, CustomerlD, and ProductlD is loaded into the model. What will be created?

A. A synthetic table and one synthetic key
B. A circular reference with one table disconnected
C. A synthetic table with two synthetic keys
D. A synthetic table with three synthetic keys

Answer: B

NEW QUESTION 49
A human resources (HR) team manager is due to go on leave. The manager needs to assign permissions to colleague to help the HR team publish apps. Which action(s) should the manager assign to the colleague before going on leave?

A. Owner Publish, Read
B. Publish
C. Publish, Read
D. Owner Publish

Answer: D

Explanation:
Explanation
The Owner Publish permission allows the colleague to publish apps on behalf of the manager, allowing the HR team to continue to publish apps while the manager is away. The other options, Publish, Owner Publish, Read, and Publish, Read, do not provide the colleague with the necessary permissions to publish apps on behalf of the manager.

NEW QUESTION 50
Multiple department fields in a dataset require a description
A data architect needs to add the department descriptions or a default value when the department does NOT have a description Which strategy should the data architect use to meet these requirements?

A. ApplyMap with three parameters after the Mapping load
B. Left Join between tables and Description xlsx in every Department table
C. Enter "Missing description" in the blank rows for Description xlsx then Mapping Load
D. ApplyMap with two parameters after the Mapping load

Answer: A

Explanation:
Explanation
This strategy involves using the ApplyMap function with threeparameters after the Mapping load. This will allow the data architect to add the department descriptions or a default value when the department does not have a description.Source: Qlik

NEW QUESTION 51
Refer to the exhibit.

A data architect loads sales data and creates a table which shows only customers who made purchases in 2018 and 2019. The data architect applies the following set analysis expression on the sales measure.
Count<{<Year={'2 018'}, CustomerID=P({<Year={'2019*}>})>} Customer ID)
Which option shows the resulting table after the expression is applied?
A)

B)

C)

D)

A. Option D
B. Option A
C. Option C
D. Option B

Answer: A

NEW QUESTION 52
Refer to the exhibit.
A data architect is loading two tables into a data model from a SQL database These tables are related on key fields CustomerlD and CustomerKey.
Which script is valid to load the tables and maintain the correct association?
A)

B)

C)

D)

A. Option A
B. Option D
C. Option B
D. Option C

Answer: D

NEW QUESTION 53
A data architect of an organization that has implemented Qlik Sense on Windows needs to load large amounts of data from a database that is continuously updated New records are added, and existing records get updated and deleted. Each record has a LastModified field.
All existing records are exported into aQVD file. The data architect wants to load the records into Qlik Sense efficiently.
Which steps should the data architect take to meet these requirements?

A. 1 Load the existing data from the QVD
2. Load the new and updated data from the database without the rows that have just been loaded from the QVD and concatenate with data from the QVD
3. Load all records from the key field from the database and use an INNER JOIN on the previous table
B. 1 Load the new and updated data fromthe database.
2. Load the existing data from the QVD without the updated rows that have just been loaded from the database and concatenate with the new and updated records.
3. Load all records from the key field from the database and use an INNER JOIN onthe previous table.
C. 1. Use a partial LOAD to load new and updated data from the database.
2.Load the existing data from the QVD without the updated rows that have just been loaded from the database and concatenate with the new and updated records
3. Use the PEEK function to remove the deleted rows
D. 1. Load the existing data from the QVD
2. Load new andupdated data from the database Concatenate with the table loaded from the QVD.
3. Create a separate table for the deleted rows and use a WHERE NOT EXISTS to remove these records

Answer: B

NEW QUESTION 54
Refer to the exhibits.

A business analyst needs to see the currency conversion provided by a third party process, and only contains a record when the rate changes in a chart. The currency conversion rate data is An existing master calendar exists in the data model that contains a full set of dates.
Which technique should the data architect use to meet this requirement?

A. OUTER JOIN the calendar with the currency conversion table
ORDER BY the date and use the PEEK function to fill in blank values
B. Utilize INTERVALMATCH to load the currency conversion rate between dates theconversation changed INNER JOIN the resultant table back into the master calendar
C. Leverage a FOR loop between the start date and end date of the master calendar Use the MATCH function to add the currency conversion rates to the master calendar
D. Use ITERNO and AUTOGENERATE to create a new calendar from max and min dates of the currency conversion table

Answer: A

NEW QUESTION 55
Refer to the exhibit.

What are the values of the variables vLoadStart and vLoadComplete after the script executes?

A. vLoadStart; 'NOW{)'
vLoadComplete: current system date and time when the script ended
B. vLoadStart: current system date and time when the script started vLoadComplete: 'now()'
C. vLoadStart: system date when the app was opened vLoadComplete 'now()'
D. vLoadStart: system date when the app was opened vLoadComplete: current system date and time when the script ended

Answer: B

Explanation:
Explanation
vLoadStart variable is assigned the current system date and time when the script starts, and vLoadComplete variable is assigned the current system date and time when the script ends.

NEW QUESTION 56
A data architect executes the following script:

Whatwill be the result of Table A?
A)

B)

C)

D)

A. Option D
B. Option A
C. Option C
D. Option B

Answer: A

NEW QUESTION 57
Refer to the exhibit.

A data architect must classify each product into a price group. The price groups must be the same width by default and allow users to dynamically change the width of the bucket duringanalysis.
Which feature should the data architect use to meet these requirements?

A. IntervalMatch and use variables
B. Class function in a calculated dimension
C. Nested IFs in a calculated dimension
D. Class function in the script and use variables

Answer: B

NEW QUESTION 58
ITALY IT001 HR
GERMANY DE002 HR
SPAIN SP03 FINANCE
FRANCE FRO04 SALES
Refer to the exhibit
A company stores the employee data within a key composed of Country UserlD, and Department. These fields are separated by a blank space. The UserlD field iscomposed of two characters that indicate the country followed by a unique code of two or three digits. A data architect wants to retrieve only that unique code.

A. MID ( SUBFIELD (Key , ' ', 2), 3)
B. LEFT(SUBFIELD(Key, ' ', 2), 2)
C. RIGHT(SUBFIELD (Key,' ', 2), 3)
D. LTRIM (SUBFIELD (Key, ' ', 2), 2)

Answer: B

Explanation:
Explanation
This expression will extract the unique code from the key by using the SUBFIELD function to separate the key into its components, and then using the LEFT function to extract the first two characters of the second component.Source: Qlik

NEW QUESTION 59
A company generates 1 GB of ticketing data daily. The data is stored in multipletables Business users need to see trends of tickets processed for the past. 2 years Users very rarely access the transaction-level data for a specific date. Only the past 2 years of data must be loaded which is 720 GB of data Which method should a data architect use to meet these requirements?

A. Load only aggregated data for 2 years and apply filters on a sheet for transaction data
B. Load only 2 years ofdata in an aggregated app and create a separate transaction app for occasional use
C. Load only 2 years of data and use best practices in scripting and visualization to calculate and display aggregated data
D. Load only aggregated data for 2 years and use On-Demand App Generation (ODAG) for transaction data

Answer: D

NEW QUESTION 60
A data architect needs to upload different data sources. To properly handle null values, the data architect decides to set all of these values to "Missing Value".
Which syntax should the data architect use?

A. NullasNull *;
Set NullValues = 'Missing Value';
B. NullAsValue*; Set NullValues = 'Missing Value';
C. NullasNull *;
Set NullValue = 'Missing Value';
D. NullAsValue*;
Set NullValue = 'Missing Value';

Answer: B

Explanation:
Explanation
This syntax will set all null values to "Missing Value" in the data sources. The other options are not valid syntax and will not achieve the desired result.

NEW QUESTION 61
A dataarchitect needs to load data from two different databases Additional data will be added from a folder that contains QVDs. text files, and Excel files.
What is the minimum number of data connections required?