QSDA2018 by Qlik Actual Free Exam Questions And Answers

Question 1

A customer must create a production app that pulls data from two sources Source 1 is a large legacy system It takes more than one hour to read and save the data to a QVD Reading from the QVD only takes 20 seconds The data only needs to be refreshed every month because it does not change very often Source 2 is a small online data source Reloading this data takes less than one minute The production app must be refreshed every hour to see the most updated data and needs both data sets to meet the analysis requirements How should the data architect set up the data reload?

A. 1 Create the productioff app to connect to both data sources
2. Create a variable and set this to the last reload time using ReloadTimeQ function
3. Use an IF() statement and only load the legacy data when TodayO > 30 days from last reload 4 Create a task to run every hour to reload the production app

B. 1. Create a QVD generation app to pull both data sources in different script sections
2. Create two reload schedules from the QVD app based on the script section
3. Build the production app using the QVD files
4. Create a task to run every hour to reload the production app

C. 1. Create a QVD generation app for the legacy system only
2. Create a scheduled task to generate the QVD every month
3 Build the production app using the QVD and use ADD LOAD prefix to connect to the online data source
4. Create a task to run every hour to perform a partial reload on the production app

D. 1 Create two QVD generation apps
2- Create two scheduled tasks one runs every month and one runs every hour
3. Load the data in the production app from the QVDs
4. Create a task to run every hour to reload the production app

Discussion 0

Correct Answer: D Vote an answer

Question 2

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, 'YYYYDDMM' 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. Date#

B. Timestamp#

C. Timestamp

D. Date

Discussion 0

Correct Answer: A Vote an answer

Question 3

Refer to the exhibit

A chart for monthly hospital admissions and discharges incorrectly displays the month and year values on the x-axis.
The date format for the source data field "Common Date" is M/D/YYYY This format was used in a calculated field named "Month-Year" in the data manager when the data model was first built.
Which expression should the data architect use to fix this issue?

A. Date([Common Date],'MMM-YYYY')

B. Date(MonthStart([Common Date]), *MMM-YYYY')

C. Date(InMonth([Conmon Date]),'MMM-YYYY')

D. Date (MonthsStart ([Common Dace]),'MMM-YYYY'

Discussion 0

Correct Answer: B Vote an answer

Question 4

Refer to the exhibit.
How should the account that runs the Qlik Sense Services be configured in the Section Access table?

A. ADMIN, QUK_SERVICES,

B. ADMIN, DOMAIN\QLIK_SERVICES, *

C. ADMIN, DOMAIN\QLIK_SERVICES.

D. ADMIN, QLIK_SERVICES, *

Discussion 0

Correct Answer: D Vote an answer

Question 5

Refer to the exhibit.
A data architect is reviewing an app that is under development. The app has 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. Create a composite key in the Sales and Budget tables that consists of the Year, EmployeelDr and ProductID

B. Create a composite key in the Sales and Budget tables instead of loading Year Employee!^ and ProductID

C. Perform a mapping load for the Employees table and use ApplyMap in the Sales and Budget tables

D. Concatenate LOAD the data from the Sales and Budget tables to combine into a single table

Discussion 0

Correct Answer: C Vote an answer

Question 6

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. Datajnust 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 Left Join statement in the script

B. A link table to associate the two tables

C. A forced concatenation statement

D. Field aliases or comment out redundant fields

Discussion 0

Correct Answer: B Vote an answer

Qlik Sense Data Architect Certification Exam - June 2018 Release - QSDA2018 Exam Practice Test

Contact Us

Useful Links

Latest Updated