Qlik Sense Data Architect Sample Questions

The Qlik Certification Program was developed to certify the expertise of Qlik Partners. The expert-level Qlik Sense and QlikView Certification examinations were developed for people with practical expertise using a variety of Qlik applications or deployments. The gold standard for a new generation of analytics is set by Qlik Sense, a comprehensive data analytics platform. The Qlik Sense Qualifications are entry-level tests intended to show that candidates have both fundamental and applied expertise. Your capacity to identify requirements for data models, create and build data models, and validate the data is evaluated in the Qlik Sense Data Architect Certification Exam.The article provides a list of Qlik Sense Data Architect Sample Questions that cover core exam topics including –

• Identify Requirements for Data Models
• Design Data Models
• Build Data Models
• Validate Data

Q1)A car maker has a number of QlikView applications. The maker chooses to move some particular apps to Qlik Sense. The manufacturer chooses to migrate a few particular variables in order to reuse front-end data from the previous QlikView application. Which approach should a data architect choose to fulfil these needs?

• A. Utilize the QlikView converter found in Qlik Sense’s Dev Hub.
• B. Drag a QVM file onto the Qlik Sense portal and start a new app from there.
• C. Create a QVS file from the existing LOAD script so that it may be used again in Qlik Sense.
• D. Insert the LOAD script from the previous QlikView app into the newly created app.

Correct Answer: D

Q2)The Qlik GeoAnalytics connector is used by a data architect to find the closest airports to cities in an existing app. Data for the airport locations is generated by the built location. When the script is performed by the data load editor, it detects a synthetic key and a circular reference. How ought the data architect to address these problems?

• A. Select Only load distinct when choosing an operation in the Qlik GeoAnalytics connection.
• B. Uncheck the non-unique field in the new data tables when deciding which data to import.
• C. Combine the airport table with the current tables to create a single master table.
• D. Set the CRS to “None” when choosing an operation in the Qlik GeoAnalytics connection.

Correct Answer: D

Q3)Sales and employee target data are stored in two tables that belong to a data architect. The tables are added to Qlik Sense and linked together using the EmployeeID. An overall Sales vs. Target bar chart is made by the data architect. The architect observes that some target values are excessively high and that personnel with NO sales should be disqualified. Which function ought the data architect to apply to deal with these problems?

• A. Left Join
• B. Inner Join
• C. Left Keep
• D. Outer Join

Correct Answer: B

Q4)Seven hundred million records are found in a corporate data warehouse. This enterprise data warehouse uses QVDs and has a three-tiered architecture. The Qlik Sense server has two CPUs, each with eight cores, and 24 GB of RAM. The business must provide vendors anonymous access to a Qlik Sense app so they may examine previous business dealings and current year-to-date performance. Which approach ought the data architect to take to fulfil this demand?

• A. Create a template app for On-Demand Application Generation and a selection app, and enable anonymous vendor access.
• B. Create a template app for On-Demand Application Generation and a selection app, and mandate that vendors log into Qlik Sense in order to access the apps.
• C. Create a Direct Discovery application that allows users to access dynamic QVDs to view their particular content.
• D. Create a Direct Discovery app that enables users to access Section Access to view their particular material.

Correct Answer: A

Q5)An organisation with departments for sales, marketing, and finance is working on a time and expense app. Department managers should only be able to view the data for their department’s team members. The data architect should implement this security constraint where?

• A. Data load editor
• B. Qlik Management Console
• C. Expression editor
• D. Data manager

Correct Answer: B

Q6)A business observes a decline in product sales. To demonstrate the relationship between the declining sales and the findings of the most recent customer survey, a data architect must develop an app. The data architect should use the Qlik Sense functionality to fulfil this requirement.

• A. Section access
• B. On-demand App Generation
• C. Master item library
• D. Associative data model

Correct Answer: D

Q7)An app that is still in development is being examined by a data architect. The app has NOT been made available. All charts and KPIs use only data that has been verified. The data architect observes that there are two fact tables in the data model with similar field names that result in a synthetic join. Which action should the data architect take to make the data model correction without harming the application?

• A. Concatenate LOAD the information from the Budget and Sales tables into one table.
• B. Create a composite key consisting of the Year, EmployeeID, and ProductID in the Sales and Budget columns.
• C. Use a composite key instead of loading Year, EmployeeID, and ProductID in the Sales and Budget tables.
• D. Use ApplyMap in the Sales and Budget tables and do a mapping load for the Employees table.

Correct Answer: A

Q8)Using the Dev Hub converter, a QlikView app was transformed into a Qlik Sense app. Without changing the script or the server configuration, the new Qlik Sense app was reloaded, resulting in a script error. What steps should a data architect take to fix the problem?

• A. Delete the Qualify statement
• B. Add fields to the Qualify statement
• C. Use a folder connection
• D. Check the QVDs

Correct Answer: B

Q9)In order to complete a quarterly report, payroll managers require access to the payroll system. To use an ODBC connection to access the payroll system, you must have a login and password. The only person who should be able to view the credentials and make any necessary adjustments is the system administrator. Only the employees of each payroll manager who accesses the app should be visible. What are the two steps needed to set up the right security? (Select two.)

• A. Ensure the administrator develops suitable sync rules to access the payroll system.
• B. Use the proper section access to limit the visibility of the data.
• C. Verify that the administrator implements security controls on the appropriate stream to limit data visibility.
• D. Use the app’s security rules to limit data visibility.
• E. Ensure that the administrator configures the ODBC connection with the proper security rules.

Correct Answer: C and D

Q10)An Excel spreadsheet is one of the data sources a data architect must include for a freshly created app. Only the first record for the area’s region has values in the Region field. To ensure that each row has the appropriate Region, the data architect must convert the data. Which procedure should the data architect use to address this problem?

• A. CrossTable
• B. IntervalMatch
• C. Above
• D. Previous

Correct Answer: D

Q11)Online systems that only retain data for the current period are used to store stock levels. What steps should the data architect take to make it possible to analyse the patterns in stock levels?

• A. Create new apps using On-Demand App Generation (ODAG) during the given time period
• B. Store the periodic data in an incremental QVD file so that it may be used in an app.
• C. Use document chaining and make an app for each period as it changes.
• D. Make a single app using a binary load job and make an app for each time period.

Correct Answer: B

Q12)To display only the years 2016 and 2017 in the table, the values for SalesYear must be transformed from the value “Sales 2016”. Which two scripted functions may the data architect use to do this? (Select two.)

• A. Right(‘$(vSalesSheet)’ as SalesYear
• B. Left($(vSalesSheet)’ 4) as SalesYear
• C. SubField($(vSalesSheet)’,’ ‘,2) as SalesYear
• D. LTrim(‘$(vSalesSheet)’) as SalesYear
• E. SubField($(vSalesSheet)’,’ ‘,1 ) as SalesYear

Correct Answer: A and C

Q13)Following the merger of two businesses, a complete database integration is anticipated for 2019. For a temporary solution to examine all employee data from both firms, the data architect is in demand. The tables come from different system. Both businesses have comparable employee tables. Employee identities and a few other attributes (such geographic data) are present in both tables. Additionally, some of the fields in the tables are mismatched (e.g., Social Security Number and Bank Account) Which issue arises when Qlik Sense loads the two tables?

• A. Link tables are created
• B. Synthetic keys are created
• C. An auto concatenation occurs
• D. A circular reference occurs

Correct Answer: B

Q14)When the business analyst analyses some data, he or she observes that the United States’ Country column contains several values. The analyst must be able to provide the overall sales figures for the US. This error in the LOAD script has to be fixed by the data architect. Which tool should the data architect use to address a data quality problem?

• A. Switch
• B. ApplyMap
• C. Case
• D. Replace

Correct Answer: B

Q15)For information containing actual sales and budget sales for a multinational corporation, the data model displayed has a synthetic key. Users must be able to dig down by department and nation as a matter of business necessity. Data loss must not occur. Some departments are NOT included in the Sales and Budget tables due to data quality concerns. The data architect requires a technique for getting rid of fake keys that produces the most efficient data model. Which approach ought the data architect to take?

• A. A link table linking the two tables together
• B. A statement with forced concatenation.
• C. Use field aliases or leave redundant fields uncommented.
• D. The script’s Left Join clause.

Correct Answer: B

Q16)Two tables in a data architect house sales and employee target information. When the tables are put into Qlik Sense, EmployeeID is used to link them together. A bar chart of total Sales vs. Target is produced by the data architect. The architect observes that some target values are unreasonably high and that workers who make NO sales ought to be disqualified. Which function has to be applied by the data architect to address these problems?

• A. Left Join
• B. Inner Join
• C. Left Keep
• D. Outer Join

Correct Answer: B

Q17)To keep track of patient interactions, lab orders, and medication, a healthcare company requires an app. Data about encounters, test orders, and prescriptions are kept in three different tables connected by the patient ID. PatientID values are accurate in all three tables. Patients may receive care without being given any medication or lab orders. The patient lab order count needs to be verified by the data architect to be accurate. Which approach should the data architect use to fulfil this need?

• A. After loading all three tables, use the Count function to make a copy of PatientID in the lab orders table as LabPatientID (Distinct LabPatientID)
• B. Use Count and load all three tables (Distinct PatientID)
• C. Use Count and load all three tables (PatientID)
• D. Load all three tables, make a copy of PatientID as LabPatientID in the lab orders table, and employ count (LabPatientID)

Correct Answer: D

Q18)A sales dashboard must be created by a data architect. A legacy database is used to store the data. The date in the extracted data is in the format “YYYDDMM.” The dates are being loaded as numbers because of the format of the source dates. Which function ought the data architect to employ to address this problem?

• A. Timestamp
• B. Date
• C. Date#
• D. Timestamp#

Correct Answer: C

Q19)The Qlik GeoAnalytics connector is used by a data architect to find the closest airports to cities in an existing app. Data for the airport locations is generated by the built location. When the script is performed by the data load editor, it detects a synthetic key and a circular reference. How ought the data architect to address these problems?

• A. Select Only load distinct when choosing an operation in the Qlik GeoAnalytics connection.
• B. Uncheck the non-unique field in the new data tables when deciding which data to import.
• C. Combine the airport table with the current tables to create a single master table.
• D. Set the CRS to “None” when choosing an operation in the Qlik GeoAnalytics connection.

Correct Answer: D

Q20)When the business analyst analyses some data, he or she observes that the United States’ Country column contains several values. The analyst must be able to provide the overall sales figures for the US. This error in the LOAD script has to be fixed by the data architect. Which tool should the data architect use to address a data quality problem?

• A. Switch
• B. ApplyMap
• C. Case
• D. Replace

Correct Answer: B