Online Access Free QSDA2022 Exam Questions

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

Refer to the exhibit.

A customer needs to load forecast data from an Excel file.
Which preceding load statement should the data architect use to load the data?

• A.
• B.
• C.
• D.

A data architect needs to upload data from ten different sources, but only if there are any changes after the last reload When data is updated, a new file is placed into a folder mapped to E A439926003 The data connection points to this folder.
The data architect plans a script which will:
1. Verify that the file exists
2. If the file exists, upload it Otherwise, skip to the next piece of code The script will repeat this subroutine for each source. When the script ends, all uploaded files will be removed with a batch procedure.
Which option should the data architectuse to meet these requirements?

• A.FileSize, IF, THEN, END IF
• B.FilePath, IF, THEN. Drop
• C.FileExists, FOR EACH, IF
• D.FilePath, FOR EACH, Peek, Drop

A data architect needs to efficiently prepare a data model for a meeting in an hour.
The data source to be used contains five date fields The app needs to display sales trends and compare the current year to date (CYTD) to last year to date (LYTD) The appis NOT going to be published It will only be used for this meeting and a single user's ad-hoc analysis.
What should the data architect do to meet these requirements?

• A.Load a calendar island
• B.Create five master calendars
• C.Use the data manager
• D.Create a canonical calendar

Refer to the exhibit.

Which changes on the database will the script capture?

• A.Insert. Update, and Remove rows
• B.Insert and Remove rows
• C.Insert and Update rows
• D.Update and Remove rows