QSDA2021 Practice Exam Questions and Answers

A.  

1 Load the existing data from the QVD

2. Load the new and updated data from the database without the rows that have just been loaded from the QVD and concatenate with data from the QVD

3. Load all records from the key field from the database and use an INNER JOIN on the previous table

B.  

1. Load the existing data from the QVD

2. Load new and updated data from the database Concatenate with the table loaded from the QV

D.  

3. Create a separate table for the deleted rows and use a WHERE NOT EXISTS to remove these records

C.  

1. Use a partial LOAD to load new and updated data from the database.

2. Load the existing data from the QVD without the updated rows that have just been loaded from the database and concatenate with the new and updated records

3. Use the PEEK function to remove the deleted rows

D.  

1 Load the new and updated data from the database.

2. Load the existing data from the QVD without the updated rows that have just been loaded from the database and concatenate with the new and updated records.

3. Load all records from the key field from the database and use an INNER JOIN on the previous table.

A.  

Option A

B.  

Option B

C.  

Option C

D.  

Option D

A.  

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

B.  

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

C.  

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

D.  

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

A.  

Utilize a combination of LEFT(), MID(), and RIGHT()functions to capture the key components

B.  

In the SUBFIELD function, replace the ‘_’ with a ‘|’ or ‘_’ character.

While debugging an app, a developer loads data from an application layer QVD file.

In the process of separating a concatenated key into two parts, some split results are missing data

What should the data architect do?

C.  

Utilize a combination of LEFT(), MID(), and RIGHTO functions to capture the key components

D.  

In the SUBFIELD function, replace the '- with a ‘|’ or '-’ character

E.  

Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field

F.  

Wrap an IF() function around the SUBFIELDQ functions to check and adapt to null values character

G.  

Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field

A.  

Create a bridge table between the Departments and Salespeople tables to resolve the many-to-many relationship

B.  

Create a bridge table between the Transactions and Salespeople tables to resolve the many-to-many relationship

C.  

Join the Departments and Salespeople tables to resolve the many-to-many relationship

D.  

Join the Transactions and Salespeople tables to resolve the many-to-many relationship

A.  

Binning

B.  

Intersect

C.  

AddressLookup

D.  

Simplify

A.  

LTRIM (SUBFIELD (Key, ' ', 2), 2)

B.  

MID ( SUBFIELD (Key , ' ', 2), 3)

C.  

RIGHT(SUBFIELD (Key,' ', 2), 3)

D.  

LEFT(SUBFIELD(Key, ' ', 2), 2)