Question No 1:

A company builds several apps to help analyze product performance

• Each app is for a specific business area: Marketing,Sales, or Production
• Users must see updated data daily
• Data is taken from the enterprise data warehouse (EDW)
• Change requests for the data warehouse take approximately 6 weeks
• One of the dimensions used across all of the apps is product group
• There are six different product groups

To provide users with an intuitive way of working with data, the colors that represent the product groups must be the same in all apps The RGB color codes for each product group will be provided to the data architect by e-mail
How should the data architect add consistent colors for the product group dimension that are easy to maintain?

A. Add the color codes using a text file
B. Add the color codes using expressions
C. Add the color codes in the EDW
D. Add the color codes using variables

Answer: A

Question No 2:

Refer to the exhibit.

The data model shown has a synthetic key for information that contains actual sales and budget sales for a multi-national company As a business requirement, users must be able to drill down by department and country. Datajnust not be lost. Due to data quality issues, some departments are NOT included in the Sales and Budget tables.

The data architect needs a method to eliminate synthetic keys that generates the fastest performing data model Which method should the data architect use?

A. A link table to associate the two tables

B. A forced concatenation statement

C. Field aliases or comment out redundant fields

D. A Left Join statement in the script

Answer: A

Question No 3:

Ahealthcare organization needs anapp to track patient encounters, patient lab orders, and patient medications.

• Encounters, lab orders, and medication data are maintained in three separate tables linked by PatientID
• PatientID values in all three tables are completely accurate
• Patients may have encounters without lab orders or medications
The data architect needs to make sure that the count of patient lab orders is correct. Which method should the data architect to meet this requirement?

A. Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use Count(DistinctLabPatientID)
B. Load all three tables and use Count{Distinct PatientID)
C. Load all three tables and use Count(PatientlD)
D. Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use Count(LabPatientlD)

Answer: A

Question No 4:

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 (MonthsStart ([Common Dace]),’MMM-YYYY’

B.  Date(MonthStart([Common Date]), •MMM-YYYY’)

C.  Date([Common Date],’MMM-YYYY’)

D.  Date(InMonth([Conmon Date]),’MMM-YYYY’)

Answer: D

Question No 5:

Refer to the exhibit.

One of the data sources a data architect must add for a newly developed app is an Excel spreadsheet The Region field only has values for the first record for the region. The data architect must perform atransformation so that each rowcontains the correct Region. Which function should the data architect implement to resolve this issue?

A.  CrossTable

B.  IntervalMatch

C.  Above

D.  Previous

Answer: B

Leave a Reply

Your email address will not be published. Required fields are marked *