QlikView QSDA2019 Online Practice Questions and Exam Preparation

QlikView QSDA2019 Online Questions & Answers

• Question 41:

  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({$}Instrument)
  B. Count({S}Instrument)
  C. Count({$}Instrument)
  D. Count ({S2"}>}Instrument)
  A. Count({$}Instrument)

• Question 42:

  A company decides to migrate all apps from QlikView to Qlik Sense. After converting an apps: there are several unconverted objects. What should the data architect do?

  A. Save the unconverted objects as extensions and import them into Qlik Sense
  B. Remove the set analysis statements from the unconverted objects
  C. Re-create the unconverted objects
  D. Save the unconverted objects as master items
  A. Save the unconverted objects as extensions and import them into Qlik Sense

• Question 43:

  Refer to the exhibit.

  

  A business analyst reports that the 'CompanyAge' field does NOT display for users The data architect examines the LOAD script and wants to place the breakpoint in the script to check the field name. Which line number should the data architect use?

  A. 242 because field name appears in the output Panel of the debugger
  B. 251 because the field name appears in the Variable panel of the debugger
  C. 251 because the field name appears in the Qlik Log files
  D. 251 because the field name appears in the Output panel of the debugger
  D. 251 because the field name appears in the Output panel of the debugger

• Question 44:

  A data architect needs to load Table_A from an Excel file and sort the data by Field_2. Which script should the data architect use?

  

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

• Question 45:

  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
  B. Publish
  C. Owner Publish, Read
  D. Publish, Read
  D. Publish, Read

• Question 46:

  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?

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

• Question 47:

  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: system date when the app was opened vLoadComplete 'now()'
  C. vLoadStart: system date when the app was opened vLoadComplete: current system date and time when the script ended
  D. vLoadStart: current system date and time when the script started vLoadComplete: 'now()'
  B. vLoadStart: system date when the app was opened vLoadComplete 'now()'

• Question 48:

  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. NullAsValue*; Set NullValues = 'Missing Value';
  B. NullasNull *; Set NullValues = 'Missing Value';
  C. NullasNull *; Set NullValue = 'Missing Value';
  D. NullAsValue*; Set NullValue = 'Missing Value';
  C. NullasNull *; Set NullValue = 'Missing Value';

• Question 49:

  Users of a published app report incomplete visualizations. The data architect checks the app multiple times and cannot replicate the error. The error affects only one team. What is the most likely cause?

  A. An Omit field has been applied
  B. A security rule has been applied to the sheet object
  C. Section access restricts too many records
  D. The affected users were NOT added to the Section Access table
  A. An Omit field has been applied

• Question 50:

  A data architect creates a collection of large QVD files that propagate data into their apps This solution works well.

  However, a new app that uses a subset of the data in a QVD takes much longer than expected to reload The LOAD statement is

  

  Which two changes should be made to improve load performance? (Select two ) A)

  

  B)

  C)

  D)

  

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