Download Qlik Sense Data Architect Certification Exam.QSDA2018.CertKiller.2019-04-05.23q.vcex

Vendor:	QlikView
Exam Code:	QSDA2018
Exam Name:	Qlik Sense Data Architect Certification Exam
Date:	Apr 05, 2019
File Size:	3 MB

Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAMFILESCOM

Discount: 20%

Demo Questions

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?

Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use Count(Distinct LabPatientID)
load all three tables and use Count(Distinct PatientID)
load all three tables and use Count(PatientID)
Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use count (LabPatientID)

Correct answer: D

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?

Timestamp
Date
Date#
Timestamp#

Correct answer: C

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?

Switch
ApplyMap
Case
Replace

Correct answer: B

Explanation:

Reference: https://community.qlik.com/t5/QlikView-App-Development/Help/td-p/921736

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?

Link tables are created
Synthetic keys are created
An auto concatenation occurs
A circular reference occurs

Correct answer: B

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?

Correct answer: A

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.)

Right(‘$(vSalesSheet)’ as SalesYear
Left($(vSalesSheet)’ 4) as SalesYear
SubField($(vSalesSheet)’,’ ‘,2) as SalesYear
LTrim(‘$(vSalesSheet)’) as SalesYear
SubField($(vSalesSheet)’,’ ‘,1 ) as SalesYear

Correct answer: AC

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?

Section access
On-demand App Generation
Master item library
Associative data model

Correct answer: B

Explanation:

Reference: https://community.qlik.com/t5/Qlik-Sense-Enterprise-Documents/On-demand-App-Generation-ODAG-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?

Concatenate LOAD the data from the Sales and Budget tables to combine into a single table.
Create a composite key in the Sales and Budget tables that consists of the Year, EmployeeID, and ProductID
Perform a composite key in the Sales and Budget tables instead of loading Year, EmployeeID, and ProductID
Perform a mapping load for the Employees table and use ApplyMap in the Sales and Budget tables.

Correct answer: A

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?

Delete the Qualify statement
Add fields to the Qualify statement
Use a folder connection
Check the QVDs

Correct answer: B

Refer to the exhibit.

A data architect needs to build a Project Management dashboard. The ProjectStatus table lists all indexes in the fields. Descriptions for the indexes are stored in a single Master table.

To build the dashboard, all descriptions should be in a single table: