QSDA2022 무료 덤프문제 온라인 액세스

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.Owner Publish, Read
• B.Owner Publish
• C.Publish, Read
• D.Publish

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) )

On executing a load script of an app, the country field needs to be normalized. The developer uses a mapping table to address the issue.
What should the data architect do?

• A.Create two different mapping tables
• B.Review the values of the source mapping table
• C.Use LOAD DISTINCT on the mapping table
• D.Use a LEFT JOIN instead of the APPLYMAP

Refer to the exhibits.

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?

• A.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 theprocess of separating a concatenated key into two parts, some split results are missing data What should the data architect do?
• B.Wrap an IF() function around the SUBFIELDQ functions to check and adapt to null values character
• C.Utilize a combination of LEFT(), MID(), and RIGHT() functions to capture the key components
• D.Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field
• E.Utilize a combination of LEFT(), MID(), and RIGHTO functions to capture the key components
• F.In the SUBFIELDfunction, replace the '- with a '|' or '-' character
• G.Wrap an IF() function around the SUBFIELD() functions to check and adapt to null values
• H.Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field

Refer to the exhibit.

A data architect is working with an app and creates some visualizations to check the data. Some visualizations showissues in the data set.
* The Sales by Country table shows a total OrderValue of 18,300 sales while the KPI shows a total OrderValue of 20,600.
* The Sales monthly trend bar chart does not work with the Month field.
Which two data issues should the data architect fix in the app? (Select two.)

• A.The Month field does not exist in the Orders table and needs to be incorporated in the table using he Calendar table.
• B.The OrderDate field values in the Calendar table do not match with the values in the OrderDate field from the Orders table
• C.In the Orders table, some CustomerlD values are null because there are orders with no customer.
  and needs to be incorporated in the table using the Calendar table, null because there are orders with no customer
• D.In the Orders table, some values in the CustomerlD field do not exist in the Customers table.