Online Access Free QSDA2022 Practice Test

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.6
• B.3
• C.4
• D.1

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.Remove the LineNo field from Shipments and use the AutoNumber function on the OrderlD field
• D.Create a composite key using OrderlD and LineNo, and remove OrderlD and LineNo from Shipments

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 Output 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 Variable panel of the debugger

Refer to the exhibits.

A business analyst needs to see the currency conversion provided by a third party process, and only contains a record when the rate changes in a chart. The currency conversion rate data is An existing master calendar exists in the data model that contains a full set of dates.
Which technique should the data architect use to meet this requirement?

• A.Utilize INTERVALMATCH to load the currency conversion rate between dates theconversation changed INNER JOIN the resultant table back into the master calendar
• B.Use ITERNO and AUTOGENERATE to create a new calendar from max and min dates of the currency conversion table
• C.Leverage a FOR loop between the start date and end date of the master calendar Use the MATCH function to add the currency conversion rates to the master calendar
• D.OUTER JOIN the calendar with the currency conversion table
  ORDER BY the date and use the PEEK function to fill in blank values

Refer to the exhibit.

A data architect builds a simple data model to show the relationship between students and exams. The data is loaded. Every StudentID in the Exams table should be found in the Students table. Some students have NOT taken an exam.
The data architect selects the field "StudentID" from the Students table and sees the following:

A data architect needs to fix this anomaly.
What should the data architect do to ensure data integrity?

• A.In the LOAD script, add DISTINCT before the Students and Exams tables
• B.Remove records from the Exams table where StudentID is null
• C.Update the Exams table and add 33.4% of the missing records
• D.Update the Students table and add 16.7% of the missing records