A car manufacturer has several QlikView apps. The manufacturer decides to migrate some specific apps to Qlik Sense. The manufacturer decides to migrate some specific wants to reuse front-end variables from the previous QlikView app.
Which strategy should a data architect use to meet these requirements?
- A . Use the QlikView converter within the Dev Hub of Qlik Sense
- B . Drag and drop a QVM file into the Qlik Sense hub and create a new app
- C . Export the existing LOAD script into a QVS file for later reuse in Qlik Sense
- D . Copy and paste the LOAD script of the existing QlikView app into the new app.
A healthcare organization needs an app to track patient encounters, patient lab orders, and patient medications.
– Encounters, lab orders, and medication data are maintained in three separate tables linked by PatientID
– PatientID values in all three tables are completely accurate
– Patients may have encounters without lab orders or medications
The data architect needs to make sure that the count of patient lab orders is correct.
Which method should the data architect to meet this requirement?
- A . Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use Count (Distinct LabPatientID)
- B . load all three tables and use Count(Distinct PatientID)
- C . load all three tables and use Count(PatientID)
- D . Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use count (LabPatientID)
Refer to the exhibit.
A data architect needs to build a sales dashboard. Data is stored in a legacy database. The extracted data contains the date in the format, ‘YYYDDMM’. Due to the source date format, the dates are being loaded as numbers.
Which function should the data architect use to fix this issue?
- A . Timestamp
- B . Date
- C . Date#
- D . Timestamp#
A data architect uses the Qlik GeoAnalytics connector to determine the closest airports to cities in an existing app. The built location generates data for the airport locations. The data load editor runs the script and sees a circular reference and a synthetic key.
How should the data architect fix these issues?
- A . When selecting an operation in the Qlik GeoAnalytics connector, select Only load distinct.
- B . When choosing which data to load, uncheck the non-unique field in the new data tables.
- C . Concatenate the airport table and the existing tables into one master tables.
- D . When selecting an operation in the Qlik GeoAnalytics connector, change the CRS to “None”.
Refer to the exhibits.
Which corrective action should be taken to achieve the expected view?
- A . Alias one of the fields in the Orders table.
- B . Use distinctin the LOAD statement.
- C . Use Upper () to align the SalesPerson fields.
- D . Add a link table.
Refer to the exhibit.
The business analyst previews some data and notices different values for the United States in the Country field. The analyst must be able to report the total sales for the United States. The data architect must fix this issue in the LOAD script.
Which function should the data architect use to fix data quality issue?
- A . Switch
- B . ApplyMap
- C . Case
- D . Replace
B
Explanation:
Reference: https://community.qlik.com/t5/QlikView-App-Development/Help/td-p/921736
Refer to the exhibit.
The data model shown has a synthetic key for information that contains actual sales and budget sales for a multi-national company. As a business requirement, users must be able to drill down by department and country. Data must not be lost. Due to data quality issues, some departments are NOT included in the Sales and Budget tables. The data architect needs a method to eliminate synthetic keys that generates the fastest performing data model.
Which method should the data architect use?
- A . A link table to associate the two tables.
- B . A forced concatenation statement.
- C . Field aliases or comment out redundant fields.
- D . A Left Join statement in the script.
Refer to the exhibit.
A data architect has two tables that contain Sales and target data for employees. The tables are loaded into Qlik Sense and are associated by EmployeeID. The data architect creates a bar chart of total Sales vs. Target. The architect notices some values for target are too high, and employees with NO sales should be excluded.
Which function should the data architect use to resolve these issues?
- A . Left Join
- B . Inner Join
- C . Left Keep
- D . Outer Join
Refer to the exhibit.
A data architect has two tables that contain Sales and target data for employees. The tables are loaded into Qlik Sense and are associated by EmployeeID. The data architect creates a bar chart of total Sales vs. Target. The architect notices some values for target are too high, and employees with NO sales should be excluded.
Which function should the data architect use to resolve these issues?
- A . Left Join
- B . Inner Join
- C . Left Keep
- D . Outer Join
Refer to the exhibit.
A data architect has two tables that contain Sales and target data for employees. The tables are loaded into Qlik Sense and are associated by EmployeeID. The data architect creates a bar chart of total Sales vs. Target. The architect notices some values for target are too high, and employees with NO sales should be excluded.
Which function should the data architect use to resolve these issues?
- A . Left Join
- B . Inner Join
- C . Left Keep
- D . Outer Join
Refer to the exhibit.
A data architect has two tables that contain Sales and target data for employees. The tables are loaded into Qlik Sense and are associated by EmployeeID. The data architect creates a bar chart of total Sales vs. Target. The architect notices some values for target are too high, and employees with NO sales should be excluded.
Which function should the data architect use to resolve these issues?
- A . Left Join
- B . Inner Join
- C . Left Keep
- D . Outer Join
Refer to the exhibit.
A data architect has two tables that contain Sales and target data for employees. The tables are loaded into Qlik Sense and are associated by EmployeeID. The data architect creates a bar chart of total Sales vs. Target. The architect notices some values for target are too high, and employees with NO sales should be excluded.
Which function should the data architect use to resolve these issues?
- A . Left Join
- B . Inner Join
- C . Left Keep
- D . Outer Join
Refer to the exhibit.
A data architect has two tables that contain Sales and target data for employees. The tables are loaded into Qlik Sense and are associated by EmployeeID. The data architect creates a bar chart of total Sales vs. Target. The architect notices some values for target are too high, and employees with NO sales should be excluded.
Which function should the data architect use to resolve these issues?
- A . Left Join
- B . Inner Join
- C . Left Keep
- D . Outer Join
Refer to the exhibit.
A data architect has two tables that contain Sales and target data for employees. The tables are loaded into Qlik Sense and are associated by EmployeeID. The data architect creates a bar chart of total Sales vs. Target. The architect notices some values for target are too high, and employees with NO sales should be excluded.
Which function should the data architect use to resolve these issues?
- A . Left Join
- B . Inner Join
- C . Left Keep
- D . Outer Join
Refer to the exhibit.
A data architect has two tables that contain Sales and target data for employees. The tables are loaded into Qlik Sense and are associated by EmployeeID. The data architect creates a bar chart of total Sales vs. Target. The architect notices some values for target are too high, and employees with NO sales should be excluded.
Which function should the data architect use to resolve these issues?
- A . Left Join
- B . Inner Join
- C . Left Keep
- D . Outer Join
Create a new field to the OrderDetails table: ApplyMap (‘UnitCost_Map’, ProductID, 0) * Quantity as COGS
Two companies have merged and full database integration is planned for next year.
The data architect needs an interim solution to view all employee data from both companies.
– The tables come from different systems
– Both companies have similar Employees tables
– Both tables have identifiers for Employee and some other attributes (e.g., geographical information)
– The tables also have some fields that do NOT match (e.g., Social Security Number and Bank Account)
Which problem occurs when the two tables are loaded into Qlik Sense?
- A . Link tables are created
- B . Synthetic keys are created
- C . An auto concatenation occurs
- D . A circular reference occurs
Two companies have merged and full database integration is planned for next year.
The data architect needs an interim solution to view all employee data from both companies.
– The tables come from different systems
– Both companies have similar Employees tables
– Both tables have identifiers for Employee and some other attributes (e.g., geographical information)
– The tables also have some fields that do NOT match (e.g., Social Security Number and Bank Account)
Which problem occurs when the two tables are loaded into Qlik Sense?
- A . Link tables are created
- B . Synthetic keys are created
- C . An auto concatenation occurs
- D . A circular reference occurs
Two companies have merged and full database integration is planned for next year.
The data architect needs an interim solution to view all employee data from both companies.
– The tables come from different systems
– Both companies have similar Employees tables
– Both tables have identifiers for Employee and some other attributes (e.g., geographical information)
– The tables also have some fields that do NOT match (e.g., Social Security Number and Bank Account)
Which problem occurs when the two tables are loaded into Qlik Sense?
- A . Link tables are created
- B . Synthetic keys are created
- C . An auto concatenation occurs
- D . A circular reference occurs
Two companies have merged and full database integration is planned for next year.
The data architect needs an interim solution to view all employee data from both companies.
– The tables come from different systems
– Both companies have similar Employees tables
– Both tables have identifiers for Employee and some other attributes (e.g., geographical information)
– The tables also have some fields that do NOT match (e.g., Social Security Number and Bank Account)
Which problem occurs when the two tables are loaded into Qlik Sense?
- A . Link tables are created
- B . Synthetic keys are created
- C . An auto concatenation occurs
- D . A circular reference occurs
Two companies have merged and full database integration is planned for next year.
The data architect needs an interim solution to view all employee data from both companies.
– The tables come from different systems
– Both companies have similar Employees tables
– Both tables have identifiers for Employee and some other attributes (e.g., geographical information)
– The tables also have some fields that do NOT match (e.g., Social Security Number and Bank Account)
Which problem occurs when the two tables are loaded into Qlik Sense?
- A . Link tables are created
- B . Synthetic keys are created
- C . An auto concatenation occurs
- D . A circular reference occurs
Two companies have merged and full database integration is planned for next year.
The data architect needs an interim solution to view all employee data from both companies.
– The tables come from different systems
– Both companies have similar Employees tables
– Both tables have identifiers for Employee and some other attributes (e.g., geographical information)
– The tables also have some fields that do NOT match (e.g., Social Security Number and Bank Account)
Which problem occurs when the two tables are loaded into Qlik Sense?
- A . Link tables are created
- B . Synthetic keys are created
- C . An auto concatenation occurs
- D . A circular reference occurs
Two companies have merged and full database integration is planned for next year.
The data architect needs an interim solution to view all employee data from both companies.
– The tables come from different systems
– Both companies have similar Employees tables
– Both tables have identifiers for Employee and some other attributes (e.g., geographical information)
– The tables also have some fields that do NOT match (e.g., Social Security Number and Bank Account)
Which problem occurs when the two tables are loaded into Qlik Sense?
- A . Link tables are created
- B . Synthetic keys are created
- C . An auto concatenation occurs
- D . A circular reference occurs
Two companies have merged and full database integration is planned for next year.
The data architect needs an interim solution to view all employee data from both companies.
– The tables come from different systems
– Both companies have similar Employees tables
– Both tables have identifiers for Employee and some other attributes (e.g., geographical information)
– The tables also have some fields that do NOT match (e.g., Social Security Number and Bank Account)
Which problem occurs when the two tables are loaded into Qlik Sense?
- A . Link tables are created
- B . Synthetic keys are created
- C . An auto concatenation occurs
- D . A circular reference occurs
Two companies have merged and full database integration is planned for next year.
The data architect needs an interim solution to view all employee data from both companies.
– The tables come from different systems
– Both companies have similar Employees tables
– Both tables have identifiers for Employee and some other attributes (e.g., geographical information)
– The tables also have some fields that do NOT match (e.g., Social Security Number and Bank Account)
Which problem occurs when the two tables are loaded into Qlik Sense?
- A . Link tables are created
- B . Synthetic keys are created
- C . An auto concatenation occurs
- D . A circular reference occurs
Refer to the exhibit.
A data architect needs to build a dashboard that displays the aggregated sales for each sales representative. All aggregations on the data must be performed in the script.
Which script should the data architect use to meet these requirements?
- A .
- B .
- C .
- D .
Refer to the exhibit.
A data architect needs to transform the values for SalesYear from ‘Sales 2016’ to display only the year values ‘2016’ and ‘2017’ in the table.
Which two functions can the data architect use to accomplish this in the script? (Choose 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
An enterprise data warehouse contains 700 million records. This enterprise data warehouse has a three-tiered architecture and uses QVDs.
The Qlik Sense server contains 24 GB RAM and contains two processors with eight cores. The company needs to allow vendors to access a Qlik Sense app anonymously to review past business transactions and current year-to-date performance.
Which method should the data architect use to meet this requirement?
- A . Build an On-Demand Application Generation template app and a selection app, and allow vendors to access anonymously.
- B . Build an On-Demand Application Generation template app and a selection app, and require vendors to log into Qlik Sense to view the app.
- C . Build a Direct Discovery app that enables users to view their individual content using dynamic QVDs.
- D . Build a Direct Discovery app that enables users to view their individual content using Section Access.
The dates are stored as strings in the database. The data architect must convert the dates to date format. The reload must be as fast as possible.
Which script should the data architect use?
- A .
- B .
- C .
- D .
A data architect is working on a time and expense app for an organization that has Sales, Marketing, and Finance departments/ Department managers should only be able to view the data for their department’s team members.
Where should the data architect apply this security restriction?
- A . Data load editor
- B . Qlik Management Console
- C . Expression editor
- D . Data manager
B
Explanation:
Reference: https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/ Scripting/Security/manage-security-with-section-access.htm
Refer to the exhibits.
A company notices that product sales have decreased. A data architect needs to create an app to show the correlation between the decreased revenue and the latest customer survey results.
Which Qlik Sense feature should the data architect use to meet this requirement?
- A . Section access
- B . On-demand App Generation
- C . Master item library
- D . Associative data model
B
Explanation:
Reference: https://community.qlik.com/t5/Qlik-Sense-Enterprise-Documents/On-demand-App-GenerationODAG-in-QlikSense/ta-p/1479247
Refer to the exhibit.
A data architect is reviewing an app that is under development. The app as NOT been published. All data has been validated in all charts and KPIs. The data architect notices that the data model has two fact tables with common field names that cause a synthetic join.
Which step should the data architect take to correct the data model without affecting the app?
- A . Concatenate LOAD the data from the Sales and Budget tables to combine into a single table.
- B . Create a composite key in the Sales and Budget tables that consists of the Year, EmployeeID, and ProductID
- C . Perform a composite key in the Sales and Budget tables instead of loading Year, EmployeeID, and ProductID
- D . Perform a mapping load for the Employees table and use ApplyMap in the Sales and Budget tables.
Refer to the exhibit.
A QlikView app was converted to a Qlik Sense app using the Dev Hub converter. The new Qlik Sense app was reloaded without editing the script or the server settings, which created a script error.
What should a data architect do to resolve the issue?
- A . Delete the Qualify statement
- B . Add fields to the Qualify statement
- C . Use a folder connection
- D . Check the QVDs
Payroll managers need access to the payroll system to complete a quarterly report. A username and password is required to access the payroll system through an ODBC connection. Only the system administrator should have access to the credentials and make updates as needed. Each payroll manager who access the app should only see their own employees.
Which two actions are required to set up the appropriate security? (Choose two.)
- A . Make sure that the administrator creates appropriate sync rules to access the payroll system
- B . Apply the correct section access to restrict data visibility
- C . Make sure that the administrator applies security rules to the correct stream to restrict data visibility
- D . Apply security rules to the app to restrict data visibility
- E . Make sure that the administrator applies the correct security rules to the ODBC connection