A data architect needs to build an Order Fulfillment app. The business requires front-end performance is optimized.
The OrderDate and ShipmentDate are located in different tables.
The user needs to identify thedata type and must be able to:
* Show trends for orders and shipments
* Use a single filter for both date fields
* Analyze data over fiscal periods
Which steps should the data architect take to build the data model?

• A. 1. Load the Shipments and Orders table via the data manager
  2. Create a single filter using fields from the Orders table
• B. 1. Create a master calendar table as a data island
  2. Create a single filter using fields from the master calendar
• C. 1. Create a master calendar andjoin into the Shipments and Orders table
  2. Create a single filter using fields from the Shipments table
• D. 1. Create a link table with master calendar fields
  2. Create a single filter using fields from the master calendar

A data architect needs to revise an existing app.
The number of data rows has grown rapidly recently. While the app is in production, users are becoming increasingly unhappy about the response times when they make selections Which two methods should be used toimprove performance? (Select two.)

• A. Use dynamic script generation with variables
• B. Denormalize the schema
• C. Use flags in the data model to simplify set analysis
• D. Create master items for all complex expressions
• E. Make sure any Ul variables are preceded by '='

A table is generated resulting from the following script

When the data architect selects a date, some, but NOT all, orders for that date are shown How should the data architect modify the script to show all orders for the selected date?
A)

B)

C)

D)

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

Refer to the exhibits.

A music teacher needs to know which artists are eligible to enter this year's competition.
The teacher needs to find only the artists who have a music grade rank above two and play more than one instrument.
Which expression is needed for the Number of Instruments measure in the table?

• A. Count({$<Artist={"=Count(Instrument)>=2"}, Artist={"=Grade>2"}>}Instrument)
• B. Count({S<Count(Instrument)={">=2"}, Grades={">2"}>}Instrument)
• C. Count({$<Instrument={">=2"}, Artist={"=Grade>2"}>}Instrument)
• D. Count ({S<Artist={"=Count(Instrument)>=2M}, Grades={">2"}>}Instrument)

A data architect is using an Include statement to load the collection of variables from a TextFiles folder connection into an app. The data architect needs to load the data and generate an error if it fails.
Which statement should the data architect use?

• A. $(Must_Include=lib://TextFiles/Variables.txt);
• B. (Must_Include=lib://TextFiies/Variables.txt);
• C. (Includs=lib://TextFiles/Variables.txt);
• D. $<Include=lib://TextFiles/Variables.txt);