Vendor | : | Qlik |
Exam Code | : | QSDA2018 |
Exam Name | : | Qlik Sense Data Architect Certification Exam |
Questions and Answers | : | 50 Q & A |
Updated On | : | Click to Check Update |
PDF Download Mirror | : | QSDA2018 Brain Dump |
Get Full Version | : | Pass4sure QSDA2018 Full Version |
Question:40 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.)
Answer: AC
Question: 41
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?
Answer: A
Question: 42
Refer to the exhibits.
Which corrective action should be taken to achieve the expected view?
Answer: C
Question: 43
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?
Answer: B
Reference: https://community.qlik.com/t5/QlikView-App-Development/Help/td-p/921736
Question: 44
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?
Answer: B
Question: 45
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. T arget. 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?
Answer: B
Question: 46
Refer to the exhibit.
In the data load editor, the tables are loaded in the following sequence:
OrderHeader
OrderDetails
Products
The three tables CANNOT be modified as all fields are required. A data architect must create a Cost of Goods Sold (COGS) field calculated as UnitCost* Quantity. Some products may NOT have UniCost, so the COGS value must be zero for these products.
How should the data architect meet this requirement?
2. Create a new field in the OrderDetails table: Quantity * IsNull (UnitCost) as COGS
2. Create a new field in the OrderDetails table: if((UnitCost – null() or ", 0) * Quantity as COGS
2. Create a new field in the OrderDetails table: Replace(Null, 0, UnitCost) * Quantity as COGS
Create a new field to the OrderDetails table: ApplyMap (‘UnitCost_Map’, ProductID, 0) * Quantity as COGS
Answer: D
Question: 47
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?
Answer: D
Question: 48
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?
Answer: D
Question: 49
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?
Answer: C
Question: 50
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?
Answer: D