QlikView QlikView Certifications QSDA2019 Questions & Answers

• Question 11:

  A data architect executes the following script:

  

  What will be the result of Table_A?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C

• Question 12:

  Refer to the exhibit.

  

  The data architect needs to create a KPI that displays the average amount of orders per customer. This aggregated field should be added to the existing orders table.

  Which script should the data architect use?

  

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C

• Question 13:

  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<{})>} Customer ID) Which option shows the resulting table after the expression is applied?

  A)

  

  B)

  

  C)

  

  D)

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: D

• Question 14:

  A company needs to analyze sales data based on the exchange rate of the different countries every day

  About 30 reports must be produced with an average of 20r000 rows each. This process is estimated to

  take about three hours.

  Reports will be in Excel and distributed to business users according to defined security rules.

  Which two products should the data architect use to build this solution? (Select two.)

  A. OQIikGeoAnalytics

  B. ODAG

  C. QIikDataMarket

  D. Qlik Storytelling

  E. QIik NPrinting

  Correct Answer: AE

• Question 15:

  Refer to the exhibit.

  

  An app has been built to analyze salesperson performance by department. Salespeople often move

  between departments. There is a strict business rule which states a salesperson must be associated with

  ONLY one department at all times.

  The data architect creates a summary of department performance and notices the values are incorrect.

  The KPI showing the total sales shows the correct result.

  How should the data architect modify the data model to correct the issue?

  A. Create a bridge table between the Departments and Salespeople tables to resolve the many-to- many relationship

  B. Create a bridge table between the Transactions and Salespeople tables to resolve the many-to- many relationship

  C. Join the Transactions and Salespeople tables to resolve the many-to-many relationship

  D. Join the Departments and Salespeople tables to resolve the many-to-many relationship

  Correct Answer: D

• Question 16:

  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 Readmission"

  •

  Data being used from the patient record includes hospital account ID, patient ID, admission dater and discharge date

  Which action should the data architect perform first to meet these requirements?

  A. Sequence patient records by hospital account ID and patient ID using the Peek function

  B. Sequence patient records by patient ID using the Peek function

  C. Calculate the days since previous discharge using admission date and discharge date

  D. Order patient records by patient ID and admission date

  Correct Answer: A

• Question 17:

  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?

  A. Two

  B. Four

  C. Five

  D. Three

  Correct Answer: A

• Question 18:

  A customer has a dataset that contains latitude and longitude data for service points around the country. The data is retrieved using the following statement:

  

  It must be clear to the end user that this is geographic data.

  A. Define Location as a master item, and set the tag to Sgeodata

  B. Add GeoProject{' Point' , LatandLong) AS Point to the preceding load

  C. Add GeoKakePoint (Lat, Long} as Point to Location's preceding load

  D. Add the following to the end of the script: TAG FIELD LocationName With 'Sgeodata1, 'Srelated'; TAG FIELD Point With 'Sgeodata', 'Srelated1;

  E. Add the following to the end of the script: TAG FIELD LocationName With 'Sgeoname', @relates_Pt'; TAG FIELD Point With 'Sgeopoint*f 'Srelates Location', '$hidden';

  Correct Answer: D

• Question 19:

  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()'

  Correct Answer: B

• Question 20:

  Refer to the exhibit.

  

  A business department is forecasting revenue within an Excel spreadsheet. A data architect needs to

  include this forecast into the existing data model, and without losing any data.

  Which two sets of steps will meet these requirements? (Select two.)

  A. 1. Load the Excel spreadsheet using the data load editor

  2.

  Use the Unpivot function

  3.

  Use the Sum function to group the forecast by date

  4.

  Connect to the existing data model

  B. 1. Load the Excel spreadsheet using the data load editor

  2. Use the Crosstable function to unpivot the table

  3 Create a composite key out of the date and region

  4 Connect the new table to the data model

  C. 1. Load the Excel spreadsheet using the data load editor

  2.

  Change the sort order by date

  3.

  Create a composite key out of the forecast and region

  4.

  Connect to the existing data model

  D. 1. Load the Excel spreadsheet into the data manager

  2.

  Use the Unpivot function

  3.

  Create a composite key from the date and region

  4.

  Connect the new table to the data model

  E. 1. Load the Excel spreadsheet using the data manager

  2.

  Rename the ForecastDate field to Date

  3.

  Disable the Region

  4.

  Connect to the existing data model

  Correct Answer: D