QUESTION: 1

A company generates 1 GB of ticketing data daily. The data is stored in multiple tables Business users need to see trends of tickets processed for the past two years. Users very rarely access the transaction-level data for a specific date. Only the past two years of data must be loaded which is 720 GB of data
Which method should a data architect use to meet these requirements?

Load only two years of data in an aggregated app and create a separate transaction app for occasional use
Load only two years of data and use best practices in scripting and visualization to calculate and display aggregated data
Load only aggregated data for two years and use Direct Discovery for transaction data
Load only aggregated data for two years and use ODAG for transaction data

Answer(s): D

Reveal Solution Next Question

QUESTION: 2

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?

$<Include=lib://TextFiles/Variables.txt);
$(Must_Include=lib://TextFiles/Variables.txt);
(Must_Include=lib://TextFiies/Variables.txt);
(Includs=lib://TextFiles/Variables.txt);

Answer(s): A

Reveal Solution Next Question

QUESTION: 3

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)

Option A
Option B
Option C
Option D

Answer(s): C

Reveal Solution Next Question

QUESTION: 4

Refer to the exhibit.

The data architect needs to build a model that contains Sales and Budget data for each customer. Some customers have Sales without a Budget, and other customers have a Budget with no Sales During loading, the data architect resolves a synthetic key by creating the composite key For validation, the data architect creates a table containing Customer, Month. Sales, and Budget columns.
What does the data architect see when selecting a month?

All Customers, all Budget and all Sales records
Customer and Sales records for that month, but missing values for Budget
Customer and Budget records for that month, but missing values for Sales
Customer, Sales, and Budget records for that month

Answer(s): C

Reveal Solution Next Question

Free QSDA2019 Exam Braindumps (page: 4)

QUESTION: 1

QUESTION: 2

QUESTION: 3

QUESTION: 4