Exit demo QSDA2022 Qlik Sense Data Architect Certification - 2022 PDF format · free preview

QlikView QSDA2022 - Questions & Answers

Free preview · every answer includes a full explanation

Product page: https://prepkeys.com/qsda2022.html

Question 1
Single choice

A company has a stream with multiple apps One of the apps is a multi-regional sales app.

A data architect must set up security for users to access the stream, enter the app, and view specific sheets and data.

Which features should the data architect use to meet these requirements?

A.

Section access and set analysis

B.

QMC security rules and section access

C.

QMC security rules and custom properties

D.

Section access and sheet properties

Question 2
Single choice

Refer to the exhibit

A data architect is working on an app that contains orders, invoices, and shipping data. There are three different date fields within the data:

* OrderDate

* InvoiceDate

* ShippingDate

The business analyst needs to replicate the chart above to show Order and Shipping amounts on the same Month axis.

What should the data architect do?

A.

Create a Month field for each of the three dates in the fact table and use that in the chart

B.

Load the key field and the three date fields into a concatenated bridge table that contains KeyField and Date

C.

Left Join the three date fields onto one bridge table using the key field containing KeyField and Date

Question 3
Single choice

A data architect executes the following script.

Which values does the OrderDate field contain after executing the script?

A.

20210131, 2020/01/31, 31/01/2019, 0

B.

20210131,2020/01/31,31/01/2019

C.

20210131, 2020/01/31, 31/01/2019, 9999

D.

20210131, 2020/01/31, 31/01/2019, 31/12/20

Question 4
Single choice

Refer to the exhibits.

Some business users created an app by using the Add data functionality and loading two Excel files Orders and Customers.

The app is used to analyze the number of orders by customer. When the users create a bar chart to review the figures, the data shown is incorrect.

What should the data architect do to resolve this issue?

A.

Open the data manager, split the Customers table, and associate both tables on CustomerlD field

B.

Open the data manager, split the Customers table, and JOIN Orders and Customers on the CustomerlD field

C.

Open the data load editor and use JOIN instead of concatenate to combine Orders and Customers by CustomerlD

D.

Open the data load editor and apply a NOCONCATENATE function in the LOAD statement on the Orders table

Question 5
Multiple choice

Refer to the exhibit.

A data architect is working with an app and creates some visualizations to check the data. Some visualizations show issues in the data set.

* The Sales by Country table shows a total OrderValue of 18,300 sales while the KPI shows a total
OrderValue of 20,600.

* The Sales monthly trend bar chart does not work with the Month field.

Which two data issues should the data architect fix in the app? (Select two.)

A.

The Month field does not exist in the Orders table and needs to be incorporated in the table using he
Calendar table.

B.

In the Orders table, some CustomerlD values are null because there are orders with no customer and needs to be incorporated in the table using the Calendar table, null because there are orders with no customer

C.

In the Orders table, some values in the CustomerlD field do not exist in the Customers table.

D.

The OrderDate field values in the Calendar table do not match with the values in the OrderDate field from the Orders table

Question 6
Single choice

Refer to the exhibit.

Refer to the exhibits.

While using an app, the users report that some Sales Reps do NOT have personal details, like Division or Address Number A data architect has been called in to investigate.

The data architect uses the data model viewer to determine the relationship between the SalesRepMaster and CustomerMaster tables.

What is the cause of the issue?

A.

26 values for Sales Rep are null in CustomerMaster

B.

40.7% of the Sales Rep have CustomerMaster information

C.

59.3% of the Sales Rep have CustomerMaster information

D.

Density is 100% while Total Distinct and Present Distinct are NOT the same

Question 7
Single choice

A data architect needs to upload different data sources. To properly handle null values, the data architect decides to set all of these values to "Missing Value".

Which syntax should the data architect use?

A.

NullAsValue*; Set NullValues = 'Missing Value';

B.

NullasNull *;
Set NullValues = 'Missing Value';

C.

NullasNull *;
Set NullValue = 'Missing Value';

D.

NullAsValue*;
Set NullValue = 'Missing Value';

Question 8
Single choice

On executing a load script of an app, the country field needs to be normalized. The developer uses a mapping table to address the issue.

What should the data architect do?

A.

Use a LEFT JOIN instead of the APPLYMAP

B.

Use LOAD DISTINCT on the mapping table

C.

Create two different mapping tables

D.

Review the values of the source mapping table

Question 9
Single choice

Refer to the exhibit.

A business analyst reports that the 'CompanyAge' field does NOT display for users The data architect examines the LOAD script and wants to place the breakpoint in the script to check the field name.

Which line number should the data architect use?

A.

242 because field name appears in the output Panel of the debugger

B.

251 because the field name appears in the Variable panel of the debugger

C.

251 because the field name appears in the Qlik Log files

D.

251 because the field name appears in the Output panel of the debugger

Question 10
Single choice

A data architect completes development of a new app with two data sources Both data sources will also be used by other apps in the future The sources have different data refresh frequencies

Source 1 Contains frequently updated data and must be refreshed hourly Source 2 Contains data that is transferred from a partner and must be refreshed weekly Tasks must be created to load the data sources and make sure that the new app uses the most current data The data will be stored in two QVDs

Which tasks should be created to meet these requirements'?

A.

1. Schedule Task 1 to run hourly and refresh data from Source 1

2. Schedule Task 2 to run weekly and refresh data from Source 2
3. Schedule a task for the app that is dependent on completion of Tasks 1 or 2 that loads the two QVDs

B.

1. Schedule Task 1 to run hourly and refresh data from Source 1
2. Schedule Task 2 that is dependent on Task 1 to refresh data from Source 2
3. Schedule a task for the app that is dependent on completion of Task 2 that loads the two QVDs

C.

1. Schedule Task 1 to run hourly and refresh data from Source 1
2. Schedule Task 2 that is dependent on Task 1 to refresh data from Source 2
3. Schedule a task for the app that is dependent on completion of Tasks 1 and 2 that loads the two
QVDs

D.

1. Schedule Task 1 to run hourly and refresh data from Source 1
2. Schedule Task 2 to run weekly and refresh data from Source 2
3. Schedule a task for the app that is dependent on completion of Task 2 that loads the two QVDs

Showing 10 of 77 questions · Unlock the full set