QLIK QSDA2024
Q: 1
Exhibit.
While performing a data load from the source shown, the data architect notices it is NOT appropriate
for the required analysis.
The data architect runs the following script to resolve this issue:
How many tables will this script create?
While performing a data load from the source shown, the data architect notices it is NOT appropriate
for the required analysis.
The data architect runs the following script to resolve this issue:
How many tables will this script create?Options
Q: 2
Exhibit.
Refer to the exhibit.
A data architect wants to transform the input data set to the output data set. Which prefix to the Qlik
Sense LOAD command should the data architect use?
Refer to the exhibit.
A data architect wants to transform the input data set to the output data set. Which prefix to the Qlik
Sense LOAD command should the data architect use?Options
Q: 3
A data architect executes the following script:
What will be the result of Table.A?
A)
B)
C)
D)
What will be the result of Table.A?
A)
B)
C)
D)
Options
Q: 4
A data architect inherits an app that takes too long to load and overruns the data load window.
The app pulls all records (new and historical) from three large databases. The reload process puts a
heavy load on the source database servers. All of the data is required for analysis.
What should the data architect do?
Options
Q: 5
A company's analytics team is migrating from QlikView to Qlik Sense. During the transition there is
an opportunity to improve overall reporting.
Which set of criteria must the data architect consider while planning for the migration?
Options
Q: 6
A data architect implements Section Access on an app to reduce the data for each user when the user
logs in. Each user is allowed to see their specific territory only.
The app is set for a scheduled reload every three hours. Without Section Access added, the app loads
successfully. When Section Access is added and the script runs, the app fails to load.
What is causing this issue?
Options
Q: 7
Exhibit.
Refer to the exhibit.
The data architect needs to build a model that contains Sales and Budget data for each customer.
Some customers have Sales without a Budget, and other customers have a Budget with no Sales.
During loading, the data architect resolves a synthetic key by creating the composite key.
For validation, the data architect creates a table that contains Customer, Month, Sales, and Budget
columns.
What will the data architect see when selecting a month?
Refer to the exhibit.
The data architect needs to build a model that contains Sales and Budget data for each customer.
Some customers have Sales without a Budget, and other customers have a Budget with no Sales.
During loading, the data architect resolves a synthetic key by creating the composite key.
For validation, the data architect creates a table that contains Customer, Month, Sales, and Budget
columns.
What will the data architect see when selecting a month?Options
Q: 8
A Chief Information Officer has hired Qlik to enhance the organization's inventory analytics. In the
initial meeting, the client's focus was determined to be forecasting inventory levels.
Which stakeholder should be consulted first when gathering requirements?
Options
Q: 9
A company needs to analyze daily sales data from different countries. They also need to measure
customer satisfaction of products as reported on a social media website. Thirty (30) reports must be
produced with an average of 20,000 rows each. This process is estimated to take about 3 hours.
Which option should the data architect use to build this solution?
Options
Q: 10
Exhibit.
Refer to the exhibit.
A data architect is loading the tables and a synthetic key is generated.
How should the data architect resolve the synthetic key?
Refer to the exhibit.
A data architect is loading the tables and a synthetic key is generated.
How should the data architect resolve the synthetic key?Options
Question 1 of 10
