Qlik Sense Data Architect Quiz 7

Pregunta 1 de 10

1

An enterprise data warehouse contains 700 million records. This enterprise data warehouse has a three-tiered architecture and uses QVDs.
The Qlik 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?

Selecciona una de las siguientes respuestas posibles:

Build an On-Demand Application Generation template app and a selection app, and allow vendors to access anonymously.
Build an On-Demand Application Generation template app and a selection app, and require vendors to log into Qlik Sense to view the app.
Build a Direct Discovery app that enables users to view their individual content using dynamic QVDs.
Build a Direct Discovery app that enables users to view their individual content using Section Access.

Explicación

Pregunta 2 de 10

1

A data architect is working on a time and expense app for an organization that has Sales, Marketing, and Finance departments/ Department managers should only be able to view the data for their department’s team members.
Where should the data architect apply this security restriction?

Selecciona una de las siguientes respuestas posibles:

Data load editor
Qlik Management Console
Expression editor
Data manager

Explicación

Pregunta 3 de 10

1

A data architect is reviewing an app that is under development. The app as NOT been published. All data has been validated in all charts and KPIs. The data architect notices that the data model has two fact tables with common field names that cause a synthetic join.
Which step should the data architect take to correct the data model without affecting the app?

Selecciona una de las siguientes respuestas posibles:

Concatenate LOAD the data from the Sales and Budget tables to combine into a single table
Create a composite key in the Sales and Budget tables that consists of the Year, EmployeeID, and ProductIDC. Perform a composite key in the Sales and Budget tables instead of loading Year, EmployeeID, and ProductID
Perform a composite key in the Sales and Budget tables instead of loading Year, EmployeeID, and ProductID
Perform a mapping load for the Employees table and use ApplyMap in the Sales and Budget tables.

Explicación

Pregunta 4 de 10

1

Payroll managers need access to the payroll system to complete a quarterly report. A username and password is required to access the payroll system through an ODBC connection. Only the system administrator should have access to the credentials and make updates as needed. Each payroll manager who access the app should only see their own employees.
Which two actions are required to set up the appropriate security? (Choose two.)

Selecciona una o más de las siguientes respuestas posibles:

Make sure that the administrator creates appropriate sync rules to access the payroll system
Apply the correct section access to restrict data visibility
Make sure that the administrator applies security rules to the correct stream to restrict data visibility
Apply security rules to the app to restrict data visibility
Make sure that the administrator applies the correct security rules to the ODBC connection

Explicación

Pregunta 5 de 10

1

How should the account that runs the Qlik Sense Services be configured in the Section Access table?

Selecciona una de las siguientes respuestas posibles:

ADMIN, QLIK_SERVICES,
ADMIN, DOMAIN/QLIK_SERVICES,
ADMIN, QLIK_SERVICES,*
ADMIN, DOMAIN\QLIK_SERVICES,*

Explicación

Pregunta 6 de 10

1

One of the data sources a data architect must add for a newly developed app is an Excel spreadsheet. The Region field only was 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?

Selecciona una de las siguientes respuestas posibles:

CrossTable
IntervalMatch
Above
Previous

Explicación

Pregunta 7 de 10

1

A data architect loads order data for a global sales organization. The Order Details contains 100 million rows. The data architect must load only the data for the North America division.
Which WHERE clause should the data architect use in the Order Details LOAD script?

Selecciona una de las siguientes respuestas posibles:

WHERE Division = ‘North America”;
WHERE Exists(OrderNum);
WHERE OrderNum = [Order Header].[OrderNum];
WHERE Exists(‘North America’);

Explicación

Pregunta 8 de 10

1

The data model from an existing Qlik Sense app needs to be reused in another Qlik Sense app.

Selecciona una de las siguientes respuestas posibles:

Generic load
Preceding load
Binary load
QVD load

Explicación

Pregunta 9 de 10

1

The data architect needs to design a data model with a minimum number of tables.
Which tables should the data architect create to meet these requirements?

Selecciona una de las siguientes respuestas posibles:

AdmissionCalendar, DischargeCalendar, and CommonCalendar
AdmissionCalendar and DischargeCalendar
DateLink, AdmissionCalendar, and Dischange Calendar
DateLink and CommonCalendar

Explicación

Pregunta 10 de 10

1

A fashion retail company needs to analyze data product inventory. The company needs to filter by attributes by such as color, material, and size.
Which strategy should a data architect use to meet these requirements?

Selecciona una de las siguientes respuestas posibles:

Turn data rows into fields by using a generic load
Use the hierarchy load statement to expand hierarchy levels
Use crosstable in the load statement to unpivot
Loop through the table to transpose fields

	Creado por Will Becerra hace alrededor de 6 años

Sense Data Architect Test sobre Qlik Sense Data Architect Quiz 7, creado por Will Becerra el 02/10/2020.

Qlik Sense Data Architect Quiz 7

Qlik Sense Data Architect Quiz 7

Pregunta 1 de 10

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 2 de 10

A data architect is working on a time and expense app for an organization that has Sales, Marketing, and Finance departments/ Department managers should only be able to view the data for their department’s team members. Where should the data architect apply this security restriction?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 3 de 10

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 4 de 10

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 5 de 10

How should the account that runs the Qlik Sense Services be configured in the Section Access table?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 6 de 10

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 7 de 10

A data architect loads order data for a global sales organization. The Order Details contains 100 million rows. The data architect must load only the data for the North America division. Which WHERE clause should the data architect use in the Order Details LOAD script?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 8 de 10

The data model from an existing Qlik Sense app needs to be reused in another Qlik Sense app.

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 9 de 10

The data architect needs to design a data model with a minimum number of tables. Which tables should the data architect create to meet these requirements?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 10 de 10

A fashion retail company needs to analyze data product inventory. The company needs to filter by attributes by such as color, material, and size. Which strategy should a data architect use to meet these requirements?

Selecciona una de las siguientes respuestas posibles:

Explicación

A data architect is working on a time and expense app for an organization that has Sales, Marketing, and Finance departments/ Department managers should only be able to view the data for their department’s team members.
Where should the data architect apply this security restriction?

A data architect loads order data for a global sales organization. The Order Details contains 100 million rows. The data architect must load only the data for the North America division.
Which WHERE clause should the data architect use in the Order Details LOAD script?

The data architect needs to design a data model with a minimum number of tables.
Which tables should the data architect create to meet these requirements?

A fashion retail company needs to analyze data product inventory. The company needs to filter by attributes by such as color, material, and size.
Which strategy should a data architect use to meet these requirements?