Free Qlik Sense Data Architect Certification Exam QSDA2019 Exam Practice Test

A data architect needs to write the expression 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?

• Concat(DISTINCT IF{Aggr{Rank{Sum(Sales),4),Salesperson)=1,Salesperson),' ')
• FirstSortedValue{DISTINCT Salesperson,-Aggr{Sum(Sales),Salesperson))
• Concat(DISTINCT IF{Aggr{Rank{Sum(Sales),1),Salesperson)=1, Salesperson) , ' ')
• FirstSortedValue {Salesperson, -Aggr (Sum{Sales), Salesperson))

A data architect 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?

• Two
• Four
• Five
• Three

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?

• Owner Publish
• Publish
• Owner Publish, Read
• Publish, Read

A data architect executes the following script:What will Field_1 contain after this script is executed?

• Abcd, abcd
• abed
• Abed. abed. ABCD, ABCDABCD
• Abcd, abcd. ABCD

A data architect builds a data model for a large user group. Some sheets will be published, and the app will allow users to create their own visualizations and analyze data. Some fields must NOT appear in any field list.How should a data architect meet these requirements?

• Use HidePrefix variable
• Add fields to master items
• Use security rules
• Use HideField variable

A data architect needs to create an app to analyze 30-day re-admissions at a hospital.* The medical record system does NOT calculate re-admission data* The business rule to follow: if a patient is admitted to a hospital within 30 days after being discharged from a previous hospital stay, that event should be captured in the app with a flag called '30-day Re-admission'* Data being used from the patient record includes hospital account ID, patient ID, admission dater and discharge dateWhich action should the data architect perform first to meet these requirements?

• Sequence patient records by hospital account ID and patient ID using the Peek function
• Sequence patient records by patient ID using the Peek function
• Calculate the days since previous discharge using admission date and discharge date
• Order patient records by patient ID and admission date

A data architect is developing an app that will generate QVDs for multiple business analysts. The field naming conventions on the source data are NOT business friendly. For every table loaded, multiple fields will require a name change.An Excel file is maintained centrally that lists all source data field names and the appropriate names as they should appear in the QVDsWhich strategy should the data architect use to meet these requirements?

• Use the Rename function and a mapping load
• Create master items using business-friendly names
• Use the Alias function and a mapping load
• Load in the Excel file as a data island and use the Peek function

A data architect is using an Include statement to load the collection of variables from a TextFiles folder connection into an app. The data architect needs to load the data and generate an error if it fails.Which statement should the data architect use?

• $<Include=lib://TextFiles/Variables.txt);
• $(Must_Include=lib://TextFiles/Variables.txt);
• (Must_Include=lib://TextFiies/Variables.txt);
• (Includs=lib://TextFiles/Variables.txt);

A data architect needs to upload data from ten different sources, but only if there are any changes after the last reload When data is updated, a new file is placed into a folder mapped to E:\373948870. The data connection points to this folder.The data architect plans a script which will:1. Verify that the file exists2. If the file exists, upload it. Otherwise, skip to the next piece of code.The script will repeat this subroutine for each source. When the script ends, all uploaded files will be removed with a batch procedure. Which option should the data architect use to meet these requirements?

• FilePath, IF, THEN, Drop
• FileSize, IF, THEN, END IF
• FilePath, FOR EACH, Peek, Drop
• FileExists, FOR EACH, IF

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?

• ApplyMap with two parameters after the Mapping load
• Left Join between tables and Description.xlsx in every Department table
• Enter 'Missing description' in the blank rows for Description.xlsx, then use Mapping Load
• ApplyMap with three parameters after the Mapping load