QlikView QlikView Certifications QSDA2022 Questions & Answers

• Question 61:

  A data architect needs to add the UnitCost field from the ProductCost table in the Dim_Products Table. Which script code should the data architect use?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C

• Question 62:

  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({$=2"}, Artist={"=Grade>2"}>}Instrument)

  B. Count({S=2"}, Grades={">2"}>}Instrument)

  C. Count({$=2"}, Artist={"=Grade>2"}>}Instrument)

  D. Count ({S=2M}, Grades={">2"}>}Instrument)

  Correct Answer: A

  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-innovation-today-and-tomorrow

  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/

• Question 63:

  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?

  A. Use HidePrefix variable

  B. Add fields to master items

  C. Use security rules

  D. Use HideField variable

  Correct Answer: C

  Explanation: The best way for a data architect to meet the requirements of not allowing some fields to appear in any field list is to use security rules. Security rules can be used to restrict access to certain fields, which will ensure that they don't appear in any field list or visualization. Additionally, security rules can also be used to restrict access to certain data models, ensuring that only users with the right permissions can view and analyze the data.

  Row-level security (RLS) with Power BI - Power BI | Microsoft Learn https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls What Is Data Visualization? Definition and Examples | Tableau https://www.tableau.com/learn/articles/data-visualization 80+ Top Power BI Interview Questions and Answers [Updated 2023] https://www.edureka.co/blog/interview-questions/power-bi-interview-questions/

• Question 64:

  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: BD

  Explanation: Option B involves loading the Excel spreadsheet using the data load editor and then using the Crosstable function to unpivot the table, creating a composite key out of the date and region, and connecting the new table to the existing data model. Option D involves loading the Excel spreadsheet using the data manager, using the Unpivot function, creating a composite key from the date and region, and connecting the new table to the existing data model.

• Question 65:

  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 is composed 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. LTRIM (SUBFIELD (Key, ' ', 2), 2)

  B. MID ( SUBFIELD (Key , ' ', 2), 3)

  C. RIGHT(SUBFIELD (Key,' ', 2), 3)

  D. LEFT(SUBFIELD(Key, ' ', 2), 2)

  Correct Answer: D

  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

• Question 66:

  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: BE

  Explanation: The best answer choices are B. ODAG and E. QIik NPrinting. ODAG (On Demand Application Generation) is a product from Qlik that can be used to quickly generate reports from large datasets. It can produce reports with up to 20,000 rows and can do so in less than three hours. NPrinting is a product from Qlik that can be used to distribute the reports in Excel format according to the defined security rules.

• Question 67:

  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

  Correct Answer: D

• Question 68:

  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. Drag and drop, map-based visualization of this data is required. Which two steps should the data architect take to support this data? (Select two.)

  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: BE

• Question 69:

  Refer to the exhibit.

  

  A data architect is loading the tables and a synthetic key is generated.

  How should the data architect resolve the synthetic key?

  A. Create a composite key using OrderlD and LineNo

  B. Remove the LineNo field from Shipments and use the AutoNumber function on the OrderlD field

  C. Remove the LineNo field from both tables and use the AutoNumber function on the OrderlD field

  D. Create a composite key using OrderlD and LineNo, and remove OrderlD and LineNo from Shipments

  Correct Answer: A

  Explanation: This is the recommended approach to resolving synthetic keys, as it allows you to maintain the integrity of the data by combining two or more fields into a single key. The composite key can then be used to join the two tables together, ensuring that the data is consistent and accurate.

• Question 70:

  

  The Section Access security table for an app is shown. User ABC\PPP opens a Qlik Sense app with a table using the field called LEVEL on one of the table columns. What is the result?

  A. The user gets a "Field not found" error.

  B. The table is removed from the user interface.

  C. The user gets an "incomplete visualization" error

  D. The table is displayed without the LEVEL column.

  Correct Answer: C