Online Access Free QSDA2022 Practice Test

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.Peek
• C.IntervalMatch
• D.ApplyMap

A data architect needs to develop a script to export tables from a model based upon rules from an independent file. Thestructure of the text file with the export rules is as follows:

These rules govern which table in the model to export, what the target root filename should be, and the number of copies to export.
The TableToExport values are already verified to existin the model.
In addition, the format will always be QVD, and the copies will be incrementally numbered.
For example, the Customer table would be exported as:
What is the minimum set of scripting strategies the data architect must use?

• A.One loop and one SELECT CASE statement
• B.Two loopswithout any conditional statement
• C.Two loops and one IF statement
• D.One loop and two IF statements

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.NullAsValue*;
  Set NullValue = 'Missing Value';
• C.NullasNull *;
  Set NullValues = 'Missing Value';
• D.NullasNull *;
  Set NullValue = 'Missing Value';

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.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
• C.Use ITERNO and AUTOGENERATE to create a new calendar from max and min dates of the currency conversion table
• D.OUTER JOIN the calendar with the currency conversion table
  ORDER BY the date and use the PEEK function to fill in blank values

A dataarchitect needs to load data from two different databases Additional data will be added from a folder that contains QVDs. text files, and Excel files.
What is the minimum number of data connections required?

• A.Five
• B.Two
• C.Four
• D.Three