最新的Qlik QSDA2022免費考試真題

問題1

A company has different departments.
Executive and Sales should always be the first values in a Department filter pane.
Which script must the data architect use to meet this requirement?

A.

B.

C.

D.

正確答案: A

問題2

A data architect needs to write theexpression for a measure on a KPI to show the sales person with the highest sales The sort order of the values of the fields is unknown When two or more sales people have sold the same amount, the expression should return all of those sales people Which expression should the data architect use?

A. Concat (DISTINCT IF (Aggr (Rank (Sum (Sales) , 1) , Salesperson) =1, Salesperson) , ' ')

B. Concat(DISTINCT IF (Aggr (Rank (Sum (Sales) , 4) , Salesperson) =1, Salesperson) , ' ')

C. FirstSortedValue (Salesperson, -Aggr (Sum(Sales) , Salesperson) )

D. FirstSortedValue (DISTINCT Salesperson, -Aggr (Sum(Sales) , Salesperson) )

正確答案: A

問題3

Refer to the exhibit.

A data architect has a data model that includes historical order fulfillment centers. The order fulfillment centers occasionally changed location. The history of order fulfillment must be tracked on a per center, per location basis.
Which scripting function should the data architect use to meet this data modeling requirement?

A. Inner Join

B. ApplyMap

C. Peek

D. IntervalMatch

正確答案: B

說明：（僅 Fast2test 成員可見）

問題4

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. Load the key field and the three date fields into a concatenated bridge table that contains KeyField and Date

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

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

正確答案: A

問題5

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?

A. Remove the LineNo field from both tables and use the AutoNumber function on the OrderlD field

B. Create a composite key using OrderlD and LineNo

C. Create a composite key using OrderlD and LineNo, and remove OrderlD and LineNo from Shipments

D. Remove the LineNo field from Shipments and use the AutoNumber function on the OrderlD field

正確答案: B

說明：（僅 Fast2test 成員可見）

問題6

A human resources (HR) team manager is due to go on leave. The manager needs to assign permissions to colleague to help the HR team publish apps. Which action(s) should the manager assign to the colleague before going on leave?

A. Publish

B. Owner Publish, Read

C. Publish, Read

D. Owner Publish

正確答案: D

說明：（僅 Fast2test 成員可見）

問題7

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 load editor and apply a NOCONCATENATE function in the LOAD statement on the Orders table

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

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

正確答案: C

問題8

Refer to the 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:

A. 3

B. 4

C. 1

D. 6

正確答案: B

最新的Qlik Sense Data Architect Certification Exam - 2022 - QSDA2022免費考試真題

聯系我們

站內鏈接

最新更新