Question 1

Exhibit.Refer to the exhibit. A data architect is provided with five tables. One table has Sales Information. The other four tables provide attributes that the end user will group and filter by. There is only one Sales Person in each Region and only one Region per Customer. Which data model is the most optimal for use in this situation?

Options :

A :

B :

C :

D :

Answer: D

Question 2

Exhibit.

Refer to the exhibit. A major healthcare organization requests a new app with the following requirements: • Users can filter AdmissionDate and DischargeDate by all fields in the Master Calendar table • Use an existing QVD file, which includes dates 20 years into the future • Users should not be able to filter on dates that have no associated encounters Which approach should the data architect take to meet these requirements?

Options :

A :

1. Load the Master Calendar and Encounters tables 2. Perform a Join Load on the Encounters table to the Resident master calendar and alias the date fields appropriately for the Admission Date 3. Perform a Join Load on the Encounters table to the Resident master calendar and alias the date fields appropriately for the Discharge Date

B :

1. Load the master calendar 2. Create two mapping tables called AdmissionCalendar and DischargeCalendar from the Resident master calendar thatfeas all fields appropriately named 3. Load the Encounters table and use ApplyMap for the AdmissionDate and DischargeDate appropriately

C :

1. Load the master calendar as AdmissionCalendar and alias the fields to reflect they are for Admission 2. Load the master calendar as DischargeCalendar and alias the fields to reflect they are for Discharge 3. Load the Encounters table

D :

1. Load the Encounters table 2. Perform a Left Join Load on the Encounters table to the master calendar and alias the date fields appropriately for the Admission Date 3. Perform a Left Join Load on the Encounters table to the master calendar and alias the date fields appropriately for the Discharge Date

Answer: C

Question 3

A data architect receives an error while running script. What will happen to the existing data model?

Options :

A : The data model will be removed from the application.

B : The latest error-free data model will be maintained.

C : Newly loaded tables will be merged with the existing data model until the error is resolved.

D : The data model will be replaced with the tables that were successfully loaded before the error.

Answer: B

Question 4

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 a transformation so that each row contains the correct Region. Which function should the data architect implement to resolve this issue?

Options :

A : Previous

B : CrossTable

C : Above

D : IntervalMatch

Answer: A

Question 5

Exhibit.

Refer to the exhibit. A data architect is provided with five tables. One table has Sales Information. The other four tables provide attributes that the end user will group and filter by. There is only one Sales Person in each Region and only one Region per Customer. Which data model is the most optimal for use in this situation?

Options :

A :

B :

C :

D :

Answer: D

Free QSDA2024 Mock Exam – Practice Online Confidently

Buying Options: