最新なQlik QSDA2018問題集（52題）、真実試験の問題を全部にカバー！

質問 1：
An enterprise data warehouse contains 700 million records. This enterprise data warehouse has a three-tiered architecture and uses QVDs The Qhk Sense server contains 24 GB RAM and contains two processors with eight cores The company needs to allow vendors to access a Qlik Sense app anonymously to review past business transactions and current year-to-date performance.
Which method should the data architect use to meet this requirement?
A. Build an On-Demand Application Generation template app and a selection app, and require vendors to log into Qlik Sense to view the app.
B. Build a Direct Discovery app that enables users to view their individual content using dynamic QVDs
C. Build a Direct Discovery app that enables users to view their individual content using Section Access
D. Build an On-Demand Application Generation template app and a selection app, and allow vendors to access anonymously
正解：D

質問 2：

A data architect needs to build a dashboard that displays the aggregated -sales for each sales representative.
All aggregations or data must be performed in the script.
Which script should the data architect use to meet these requirements?
A)

B)

C)

D)

A. Option C
B. Option A
C. Option D
D. Option B
正解：C

質問 3：

A business analyst must see a currency conversion rate for any given date in a chart The currency conversion rate data is held in a separate table in the database and only contains a record when the rate changes. An existing master calendar exists in the data model that contains a full set of dates Which technique should the data architect use to meet this requirement?
A business analyst must see a currency conversion rate for any given date in a chart The currency conversion rate data is held in a separate table in the database and only contains a record when the rate changes. An existing master calendar exists in the data model that contains a full set of dates.
Which technique should the data architect use to meet this requirement?
A. * Join the calendar with the currency conversion table
* Order by the date and use the Peek function to fill in blank values
B. * Use IntervalMatch to load the currency conversion rate between dates the conversion changed
* Inner Join the resultant table back into the master calendar
C. * Use IterNo and autogenerate to create a new calendar from max and min dates of the currency conversion table
* Force concatenate with the master calendar
D. * Use a For loop between the start date and end date of the master calendar
* Use the Match function to add the currency conversion rates to the master calendar
正解：A

質問 4：
A customer must create a production app that pulls data from two sources Source 1 is a large legacy system It takes more than one hour to read and save the data to a QVD Reading from the QVD only takes 20 seconds The data only needs to be refreshed every month because it does not change very often Source 2 is a small online data source Reloading this data takes less than one minute The production app must be refreshed every hour to see the most updated data and needs both data sets to meet the analysis requirements How should the data architect set up the data reload?
A. 1. Create a QVD generation app for the legacy system only
2. Create a scheduled task to generate the QVD every month
3 Build the production app using the QVD and use ADD LOAD prefix to connect to the online data source
4. Create a task to run every hour to perform a partial reload on the production app
B. 1 Create the productioff app to connect to both data sources
2. Create a variable and set this to the last reload time using ReloadTimeQ function
3. Use an IF() statement and only load the legacy data when TodayO > 30 days from last reload 4 Create a task to run every hour to reload the production app
C. 1 Create two QVD generation apps
2- Create two scheduled tasks one runs every month and one runs every hour
3. Load the data in the production app from the QVDs
4. Create a task to run every hour to reload the production app
D. 1. Create a QVD generation app to pull both data sources in different script sections
2. Create two reload schedules from the QVD app based on the script section
3. Build the production app using the QVD files
4. Create a task to run every hour to reload the production app
正解：C

質問 5：
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(InMonth([Conmon Date]),'MMM-YYYY')
B. Date([Common Date],'MMM-YYYY')
C. Date(MonthStart([Common Date]), *MMM-YYYY')
D. Date (MonthsStart ([Common Dace]),'MMM-YYYY'
正解：C