Question 1

Refer to the exhibit.

Refer to the exhibit
A data architect develops an app for Coffee4all, a coffee company with stores located throughout Europe The script runs successfully, but the Stores table does not have any values.
What should the data architect do?
  • Question 2

    Refer to the exhibit.

    A data architect is working with an app and creates some visualizations to check the dat a. Some visualizations show issues in the data set.
    * The Sales by Country table shows a total OrderValue of 18,300 sales while the KPI shows a total OrderValue of 20,600.
    * The Sales monthly trend bar chart does not work with the Month field.
    Which two data issues should the data architect fix in the app? (Select two.)
  • Question 3

    Refer to the exhibit.

    A customer needs to load forecast data from an Excel file.
    Which preceding load statement should the data architect use to load the data?
  • Question 4

    A data architect needs to load data from two different databases Additional data will be added from a folder that contains QVDs. text files, and Excel files.
    What is the minimum number of data connections required?
  • Question 5

    Refer to the exhibit.

    Refer to the exhibits.
    An app is built to analyze salesperson performance by department. Departments are unique within the Departments table, but Salespeople often move between departments. A strict business rule states that a salesperson must be associated with ONLY one department at all times.
    The data architect creates a summary of department performance and notices the values are incorrect. The total sales KPI shows the correct result.
    How should the data architect modify the data model to correct this issue?