Online Access Free QSDA2018 Practice Test

Refer to the exhibit

A chart for monthly hospital admissions and discharges incorrectly displays the month and year values on the x-axis.
The date format for the source data field "Common Date" is M/D/YYYY This format was used in a calculated field named "Month-Year" in the data manager when the data model was first built.
Which expression should the data architect use to fix this issue?

• A.Date(MonthStart([Common Date]), *MMM-YYYY')
• B.Date([Common Date],'MMM-YYYY')
• C.Date (MonthsStart ([Common Dace]),'MMM-YYYY'
• D.Date(InMonth([Conmon Date]),'MMM-YYYY')

A data architect needs to build a dashboard that displays the aggregated -sales for each sales representative.
All aggregations or data must be performed in the script.
Which script should the data architect use to meet these requirements?
A)

B)

C)

D)

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

Refer to the exhibits
Business analysts report data issues in the Value field of a table since the latest reload of the data What is causrng this issue?

• A.Pre-aggregated data is being used
• B.Some categories do NOT exist in the Category table
• C.Null values in the source data
• D.Hyphen characters (' -') in the source data

Refer to the exhibit.

The Country field in a CRM app is a free-form text field More spelling variations and countries are expected in the future A data architect must create a field called CountryCode based on the value in the Country field.
Which script should the data architect create to perform this task?
A)

B)

C)

D)

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

Refer to the exhibit.
A data architect needs to build a sales dashboard. Data is stored in a legacy database. The extracted data contains the date in the format, 'YYYYDDMM' Due to the source date format, the dates are being loaded as numbers.
Which function should the data architect use to fix this issue?

• A.Date#
• B.Date
• C.Timestamp
• D.Timestamp#