QSDA2019 Exam Question 6

A data architect needs to write the expression 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?
  • QSDA2019 Exam Question 7

    A data architect creates a collection of large QVD files that propagate data into their apps This solution works well.
    However, a new app that uses a subset of the data in a QVD takes much longer than expected to reload The LOAD statement is

    Which two changes should be made to improve load performance? (Select two ) A)

    B)

    C)

    D)
  • QSDA2019 Exam Question 8

    Refer to the exhibit.

    What are the values of the variables vLoadStart and vLoadComplete after the script executes?
  • QSDA2019 Exam Question 9

    A data architect needs to create an app to analyze 30-day re-admissions at a hospital.
    * The medical record system does NOT calculate re-admission data
    * The business rule to follow: if a patient is admitted to a hospital within 30 days after being discharged from a previous hospital stay, that event should be captured in the app with a flag called "30-day Re-admission"
    * Data being used from the patient record includes hospital account ID, patient ID, admission dater and discharge dateWhich action should the data architect perform first to meet these requirements?
  • QSDA2019 Exam Question 10

    A data architect executes the following script:

    What will be the result of Table_A?
    A)

    B)

    C)

    D)