I85PREP
⌘ K
Denodo Associate study materials
Denodo Associate study resources

Denodo Associate practice questions

One question at a time. Build your Denodo Associate understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Data Virtualization and Logical Data Management Fundamentals

In Denodo Platform terminology, what does the Virtual DataPort (VDP) server primarily provide?

  1. A metadata repository that only stores ETL job schedules
  2. A logical data layer that exposes heterogeneous sources as unified views Correct answer.
  3. A BI reporting engine that renders dashboards directly from source systems
  4. A physical staging area where source data is replicated nightly

Explanation

Virtual DataPort is the core component that creates a logical layer: it models wrappers and views over heterogeneous sources and answers queries by pushing execution down to those sources at runtime. It does not require copying data into a warehouse, which is precisely what distinguishes virtualization from replication.

Question 2Data Virtualization and Logical Data Management Fundamentals

Which statement best describes a Denodo base view?

  1. A view that wraps a single data source and exposes its schema Correct answer.
  2. A view created by joining several base views in a single query
  3. A view that stores precomputed aggregates for performance
  4. A view that consolidates two or more derived views through a union

Explanation

A base view is the direct abstraction of one source's structure, created by a wrapper, and it is the raw material from which derived views are built. Derived views, by contrast, combine or transform one or more base or other derived views.

Question 3Data Virtualization and Logical Data Management Fundamentals

What is the role of a Denodo wrapper?

  1. It defines how the server connects to and reads from a specific data source type Correct answer.
  2. It caches query results in memory for repeated access
  3. It schedules periodic refreshes of materialized views
  4. It enforces row-level security policies on published views

Explanation

A wrapper is the adapter that knows a source's protocol and query dialect, letting Virtual DataPort read its data and, where supported, push down operations. Security, caching, and scheduling are handled by other platform features.

Question 4Data Virtualization and Logical Data Management Fundamentals

A developer wants to combine customer records from two different CRM systems into one logical list without duplicating data. Which Denodo construct fits best?

  1. A selection view filtering each CRM by region
  2. A union view over the two base views Correct answer.
  3. A join view matching records on customer ID
  4. An interface view exposing only one CRM

Explanation

A union view stacks rows from multiple compatible views into a single result set, which is exactly the requirement for merging customer lists from separate systems. Joins combine columns side by side, and filters or interfaces do not merge row sets.

Question 5Data Virtualization and Logical Data Management Fundamentals

In Denodo, what does query pushdown optimization achieve?

  1. It rewrites the client SQL into the source's native dialect so the source does the filtering and aggregation Correct answer.
  2. It converts views into stored procedures on the source database
  3. It copies all source tables into the VDP cache before every query
  4. It encrypts data in transit between VDP and the source

Explanation

Pushdown delegates as much of the query as the source can handle, translating operations into the source's dialect so less data crosses the network and less work happens in the VDP engine. This translation is central to virtualization performance.

Question 6Data Virtualization and Logical Data Management Fundamentals

What distinguishes logical data management from traditional physical data integration?

  1. It eliminates the need for any metadata about sources
  2. It requires all source data to be loaded into a single warehouse first
  3. It exposes data through a virtual layer without relocating the underlying records Correct answer.
  4. It forbids access to relational databases

Explanation

Logical data management keeps data in place and presents a governed virtual model over it, whereas physical integration copies and consolidates data into a target store. Metadata is more important, not less, in the logical approach.

Question 7Data Virtualization and Logical Data Management Fundamentals

Which Denodo object is used to publish a set of views as a consumable data service with controlled access?

  1. A data source configuration
  2. A database
  3. A wrapper
  4. An interface view Correct answer.

Explanation

An interface view groups the views intended for a consumer and is the usual unit for exposing and governing access to a data service. Wrappers and data sources are internal plumbing, and a database is a container rather than the published contract.

Question 8Data Virtualization and Logical Data Management Fundamentals

A team needs a view that returns only active customers from a base view. Which Denodo operation should they apply?

  1. An aggregation grouping by status
  2. A union with an archive view
  3. A selection (filter) with a condition on the status column Correct answer.
  4. A join with the orders view

Explanation

A selection applies a WHERE-style condition to restrict rows, which is the direct way to keep only active customers. Joins add columns from other views, unions add rows, and aggregation summarizes rather than filters.

Question 9Data Virtualization and Logical Data Management Fundamentals

In Denodo, what is the purpose of a cache configured on a view?

  1. To enforce column-level masking
  2. To translate SQL into the source dialect
  3. To permanently replace the source of the view
  4. To store previously retrieved results so repeated queries avoid re-querying the source Correct answer.

Explanation

Caching stores results of prior executions so subsequent identical or contained queries can be served without hitting the source, improving performance and shielding sources. It is a performance feature, not a replacement for the source or a security control.

Question 10Data Virtualization and Logical Data Management Fundamentals

A developer needs to hide the salary column from a view consumed by HR analysts while keeping the view usable. Which Denodo capability applies?

  1. Creating a selection view filtering on department
  2. Configuring a wrapper for the source
  3. Applying column-level privileges or masking on the view Correct answer.
  4. Adding a cache to the view

Explanation

Column-level privileges or masking restrict visibility of specific fields for given users while the view remains queryable. Filtering rows, caching, or reconfiguring the wrapper does not hide a column from a consumer.

Question 11Data Virtualization and Logical Data Management Fundamentals

What does a Denodo derived view's execution plan determine?

  1. How often the view is refreshed
  2. Which wrapper version is installed
  3. Which users may query the view
  4. How the query is decomposed and which parts are pushed to which sources Correct answer.

Explanation

The execution plan shows how VDP splits a query across sources, what is delegated, and what is processed locally. Authorization, refresh scheduling, and wrapper versioning are separate concerns.

Question 12Data Virtualization and Logical Data Management Fundamentals

A developer joins a large fact view with a small dimension view and wants the dimension broadcast to avoid shuffling the fact. Which optimization concept is being applied?

  1. Union to append dimension rows
  2. Aggregation to reduce dimension cardinality
  3. Full outer join to preserve unmatched rows
  4. Broadcast join to distribute the small side to all nodes Correct answer.

Explanation

Broadcasting replicates the small input to every node so the large input need not be repartitioned, reducing data movement in a distributed execution. Join type, union, and aggregation address different problems.

Question 13Data Virtualization and Logical Data Management Fundamentals

Which statement correctly contrasts Denodo's virtual approach with an ETL pipeline?

  1. Both require copying all data into a warehouse
  2. Virtualization answers queries from sources on demand; ETL pre-computes and stores transformed data Correct answer.
  3. Virtualization cannot read relational sources, while ETL can
  4. Virtualization requires nightly batch loads; ETL queries sources in real time

Explanation

Virtualization queries sources at request time through a logical model, while ETL transforms and persists data ahead of consumption. This latency and storage difference is the core distinction between the two approaches.

Question 14Data Virtualization and Logical Data Management Fundamentals

What is the function of Denodo's metadata layer in logical data management?

  1. It replaces the need for a data catalog
  2. It stores the definitions of data sources, views, and their relationships for governance and reuse Correct answer.
  3. It physically stores all source rows for backup
  4. It executes only stored procedures on sources

Explanation

The metadata layer captures source definitions, view logic, lineage, and relationships, enabling governance, discovery, and reuse of the logical model. It is not a physical data store and complements rather than replaces cataloging.

Question 15Data Virtualization and Logical Data Management Fundamentals

A consumer queries an interface view that unions two base views, one of which is often unavailable. What is a sound design response?

  1. Convert the interface view into a wrapper
  2. Disable pushdown for all views in the database
  3. Add a cache to the interface view and define behavior for source failures Correct answer.
  4. Remove the union and query only the available source

Explanation

Caching the consolidated result and configuring failure handling lets the interface remain responsive when one source is down. Dropping the union changes the contract, and the other options misapply platform components.

Question 16Data Virtualization and Logical Data Management Fundamentals

Which Denodo feature lets a developer define a view's logic using SQL rather than the graphical wizard?

  1. A cache refresh job
  2. A VQL (Virtual Query Language) definition for the view Correct answer.
  3. A wrapper connection string
  4. A stored procedure on the source database

Explanation

Views can be defined in VQL, Denodo's SQL-like language, giving precise control over the query logic. Connection strings, source procedures, and refresh jobs do not define view logic.

Question 17Data Virtualization and Logical Data Management Fundamentals

What does Denodo's cost-based optimizer use to choose among alternative execution plans?

  1. The wrapper's license tier
  2. The number of users currently connected
  3. Statistics about source data volume and estimated operation costs Correct answer.
  4. Only the order in which views were created

Explanation

The optimizer estimates the cost of candidate plans using statistics such as row counts and selectivity, then selects the cheapest viable plan. Creation order, session counts, and licensing do not drive plan selection.

Question 18Data Virtualization and Logical Data Management Fundamentals

A developer must expose the same logical customer view to two departments with different row visibility. Which approach is most appropriate?

  1. Create two physical copies of the customer data
  2. Create two wrappers for the same source
  3. Create two interface views with different row-level policies over the shared derived view Correct answer.
  4. Disable caching for both departments

Explanation

Reusing one derived view and applying distinct row-level policies at the interface level avoids duplication while enforcing differentiated visibility. Physical copies and duplicate wrappers add maintenance burden and do not implement the policy.

Question 19Data Virtualization and Logical Data Management Fundamentals

Which situation best justifies materializing a view in Denodo rather than leaving it purely virtual?

  1. The consumers require real-time source values
  2. The source is fast and queries are infrequent
  3. The source is slow and the same heavy aggregation is requested frequently Correct answer.
  4. The view contains only a few rows

Explanation

Materialization trades freshness for performance, so it fits slow sources with repeated heavy queries. Fast, infrequent, small, or real-time requirements argue against materializing.

Question 20Data Virtualization and Logical Data Management Fundamentals

In Denodo, what is the difference between a join view and a union view?

  1. Both append rows but differ only in performance
  2. Both combine columns but differ only in security
  3. A join appends rows; a union combines columns
  4. A join combines columns from multiple views; a union appends rows from compatible views Correct answer.

Explanation

Joins align related rows side by side using a condition, while unions stack rows from views with compatible schemas. The two operations are structurally different, not merely performance or security variants.

Question 21Data Virtualization and Logical Data Management Fundamentals

A developer notices that a filter on a derived view is not reaching the source. Which factor most likely prevents pushdown?

  1. The database contains many views
  2. The consumer uses a JDBC driver
  3. The filter uses a function the source cannot evaluate Correct answer.
  4. The view has a cache enabled

Explanation

Pushdown depends on the source's ability to evaluate the operation; unsupported functions force local processing. Caching, client drivers, and view counts do not inherently block delegation of a filter.

Question 22Data Virtualization and Logical Data Management Fundamentals

Two source systems store dates in different formats and time zones. Where should the normalization be defined in a Denodo logical model?

  1. In a derived view that casts and converts the fields to a common representation Correct answer.
  2. In each consuming BI report separately
  3. In the wrapper connection string
  4. In the cache refresh schedule

Explanation

Centralizing format and time-zone conversion in a derived view gives all consumers a consistent representation and keeps the logic maintainable. Per-report fixes duplicate logic, and connection or schedule settings cannot normalize values.

Question 23Data Virtualization and Logical Data Management Fundamentals

A query over a union of three partitioned sources returns duplicates because one source overlaps another. What is the most precise fix within the logical model?

  1. Convert the union into a join
  2. Add a cache to each base view
  3. Add a distinct or aggregation step over the union to eliminate duplicate rows Correct answer.
  4. Disable pushdown on the union

Explanation

Overlapping partitions produce duplicate rows, and a distinct or grouping operation over the union removes them while preserving the consolidated contract. Changing the operator type or cache settings does not address duplicates.

Question 24Data Virtualization and Logical Data Management Fundamentals

A team wants to guarantee that a published interface view always reflects the latest source values while still reducing source load. Which combination is most appropriate?

  1. Full materialization with nightly refresh
  2. Creating physical copies of every source table
  3. Disabling the cache and removing pushdown
  4. Cache invalidation on source change events plus pushdown for uncached queries Correct answer.

Explanation

Event-driven invalidation keeps cached results current while pushdown serves any uncached request efficiently, balancing freshness and load. Nightly materialization is stale, and the other options sacrifice either freshness or efficiency.

Question 25Data Virtualization and Logical Data Management Fundamentals

When the optimizer must choose between pushing a complex aggregation to a slow source and computing it locally after fetching base rows, which consideration is decisive?

  1. The number of views in the database
  2. The wrapper's installation date
  3. The estimated cost of each alternative based on statistics and source capability Correct answer.
  4. The alphabetical order of view names

Explanation

The optimizer compares estimated costs, weighing source capability and statistics, to decide whether delegation or local processing is cheaper. Naming, counts, and installation dates are not cost inputs.

Question 26Data Virtualization and Logical Data Management Fundamentals

In Denodo, which object represents a reusable, named query definition that can be built from base views, other derived views, or a combination of both?

  1. A cache entry
  2. A derived view Correct answer.
  3. A connection pool
  4. A data source

Explanation

A derived view is a virtual view whose definition combines other views, whether base or derived, using operations such as selection, projection, join, union, or aggregation. It stores logic rather than data, so it is the standard building block for layered logical models in Denodo.

Question 27Data Virtualization and Logical Data Management Fundamentals

Which statement describes the role of a base view in a Denodo virtual data model?

  1. It defines row-level security policies for interface views
  2. It wraps a table or query from a source and exposes it as a read-only view Correct answer.
  3. It stores a physical copy of source rows inside the Denodo server
  4. It schedules periodic refreshes of materialized tables

Explanation

A base view is created by introspecting a source object, such as a relational table or a web service operation, and presents it as a view that the rest of the model can query. It does not itself copy data unless caching or materialization is configured separately.

Question 28Data Virtualization and Logical Data Management Fundamentals

A developer wants to expose a curated set of views to external consumers while hiding the internal staging views used to build them. Which Denodo mechanism is intended for this?

  1. Creating additional base views over the same sources for consumers
  2. Adding the staging views to a shared cache configuration
  3. Publishing an interface view that references the internal views Correct answer.
  4. Granting consumers direct privileges on the staging base views

Explanation

Interface views are the published contract presented to consumers; they reference internal derived and base views but expose only the curated schema. This separates the stable published layer from implementation details that may change.

Question 29Data Virtualization and Logical Data Management Fundamentals

Which capability is a defining characteristic of logical data management as practiced with a virtualization layer?

  1. Business rules are embedded only inside source stored procedures
  2. Each consuming application maintains its own integration code
  3. Data is copied nightly into a central warehouse before any query can run
  4. Data stays in sources and is integrated at query time through a semantic model Correct answer.

Explanation

Logical data management keeps data in its systems of record and expresses integration, transformation, and security as metadata over those sources. Consumers query a unified semantic model, and the engine rewrites requests into source queries at run time.

Question 30Data Virtualization and Logical Data Management Fundamentals

A developer needs a view that returns one row per customer with the customer attributes plus the total value of that customer's orders. Which combination of Denodo operations fits best?

  1. A union view of customer and order with a distinct applied
  2. A selection view on the order view filtered by customer identifier
  3. An intersect view of customer and order identifiers
  4. A join view between customer and order followed by a group-by aggregation on customer Correct answer.

Explanation

Producing per-customer totals requires relating the two entities and then aggregating, so a join followed by a group-by with a SUM is the natural definition. Union, intersect, and simple filters cannot compute an aggregate across related rows.

Question 31Data Virtualization and Logical Data Management Fundamentals

A developer wants to add a calculated column to an existing view without altering the underlying source query. Which Denodo operation is appropriate?

  1. Create a union view combining the base view with itself
  2. Create an interface view and grant new privileges
  3. Modify the source table to add a computed column
  4. Create a selection view over the base view and define an expression for the new field Correct answer.

Explanation

A selection view lets you project existing fields, add calculated fields defined by expressions, and rename or reorder columns while leaving the source untouched. The expression is evaluated by the virtualization engine or pushed down when possible.

Question 32Data Virtualization and Logical Data Management Fundamentals

Which Denodo element stores the technical and business descriptions, tags, and lineage of views so that analysts can discover and understand them?

  1. The source connection pool
  2. The metadata repository Correct answer.
  3. The execution engine's query cache
  4. The scheduler's job history

Explanation

The metadata repository holds descriptions, tags, ownership, and lineage information that the catalog surfaces to consumers. This is what makes virtual views discoverable and governable rather than merely executable.

Question 33Data Virtualization and Logical Data Management Fundamentals

A developer defines a union view over two branch systems and sets the union to distinct. Which outcome does this produce?

  1. Rows appearing in both branches are returned twice with an origin column
  2. Only rows present in the first branch are returned
  3. Only rows present in both branches are returned
  4. Rows appearing in both branches are returned once in the result Correct answer.

Explanation

A distinct union removes duplicate rows across the combined result, so a record present in both branches appears once. An explicit union all would instead retain both occurrences.

Question 34Data Virtualization and Logical Data Management Fundamentals

A developer needs to expose a view where each row is visible only to users whose department matches the row's department value. Which Denodo mechanism implements this?

  1. A cache invalidation schedule on the view
  2. A projection that removes the department column
  3. A row-level security policy attached to the view Correct answer.
  4. A union between the view and a department lookup

Explanation

Row-level security policies attach predicates that the engine injects into queries based on the authenticated user's context. They filter rows without requiring separate views per department.

Question 35Data Virtualization and Logical Data Management Fundamentals

Which statement best explains why a Denodo model can adapt to a renamed source column with limited impact on consumers?

  1. The engine automatically rewrites consumer SQL to match the new source name
  2. Consumers connect directly to the source using the original column names
  3. Source renames are blocked by the connection pool until consumers migrate
  4. Consumers query interface views whose column names are decoupled from source column names Correct answer.

Explanation

Because the published interface view defines its own column names, a source rename is absorbed by adjusting the internal derived view mapping. Consumer queries against the interface view remain unchanged.

Question 36Data Virtualization and Logical Data Management Fundamentals

A developer wants a single view to present order amounts in a common currency, converting from each source's local currency using a rates view. Which design fits Denodo best?

  1. A selection view on the orders view filtering out non-local currencies
  2. A union view combining orders and rates into one row set
  3. A join view between the orders view and the rates view with a calculated conversion column Correct answer.
  4. An interface view granting consumers access to the raw rates view

Explanation

Conversion needs each order to be matched with the applicable rate, which is a join, and the converted amount is expressed as a calculated column. The resulting derived view can then be published as an interface view.

Question 37Data Virtualization and Logical Data Management Fundamentals

A developer must decide whether to build a new report from a published interface view or from the underlying base view that the interface view already uses. Which consideration favors using the interface view?

  1. It provides a stable, governed contract that shields the report from internal model changes Correct answer.
  2. It removes the need for the optimizer to generate an execution plan
  3. It bypasses row-level security so aggregations are simpler to write
  4. It always returns results faster because interface views are cached by default

Explanation

Interface views are the supported contract for consumers, so building on them keeps reports insulated from refactoring of internal derived views. They also carry the intended security and semantics of the published layer.

Question 38Data Virtualization and Logical Data Management Fundamentals

A developer needs to combine two customer lists that have different column orders and one extra column in the second list, producing a single consistent schema. Which approach is correct in Denodo?

  1. Create a join view on the customer identifier and accept the extra column as a new field
  2. Create an intersect view so only matching customers survive
  3. Create a selection view on each list and query them separately
  4. Create a union view and map each branch's columns to the output fields explicitly Correct answer.

Explanation

A union view requires each branch to be mapped to the output schema, so differing column order and extra fields are resolved by explicit field mapping. This yields one consistent row set for consumers.

Question 39Data Virtualization and Logical Data Management Fundamentals

An architect is designing a three-layer Denodo model with base, derived, and interface layers. Which principle best justifies keeping transformation logic in the derived layer rather than in the interface layer?

  1. Transformation logic in the interface layer is never pushed down to sources
  2. The interface layer cannot reference more than one derived view
  3. The interface layer should stay a thin published contract so internal logic can change without altering the consumer-facing schema Correct answer.
  4. The derived layer is the only layer where row-level security can be applied

Explanation

Separating concerns keeps the interface layer stable for consumers while integration and business logic evolve in the derived layer. This reduces the blast radius of model changes and keeps published contracts meaningful.

Question 40Data Virtualization and Logical Data Management Fundamentals

A team wants a view that returns customers along with the count of their orders, and the order source cannot perform aggregation efficiently. Which statement about the Denodo design is most accurate?

  1. The join and aggregation can be defined logically, and the optimizer may fetch detail rows and aggregate locally when pushdown is not beneficial Correct answer.
  2. The aggregation must be moved into the customer source because joins cannot be aggregated
  3. The view cannot be created unless the order source supports GROUP BY
  4. The aggregation must be performed by the consuming reporting tool outside Denodo

Explanation

Denodo expresses the join and aggregation declaratively and leaves the placement decision to the optimizer, which can aggregate locally when pushing to a slow source is not worthwhile. Source aggregation capability is a performance factor, not a prerequisite for defining the view.

Question 41Denodo Platform Architecture and Components

In a Denodo deployment, which component is responsible for storing the metadata that describes virtual databases, views, and data sources?

  1. The Denodo Scheduler server
  2. The ITPilot wrapper generator
  3. The Virtual DataPort server's metadata database Correct answer.
  4. The Solution Manager diagnostics agent

Explanation

Virtual DataPort keeps all elements it manages, such as databases, views, data sources and users, in a relational metadata database that the server reads at startup and updates as elements change. This catalog is what makes the elements persistent across restarts and is distinct from the actual data, which stays in source systems.

Question 42Denodo Platform Architecture and Components

Which Denodo component acts as the client-facing layer that receives SQL queries from BI tools and JDBC/ODBC applications and routes them to Virtual DataPort?

  1. The Denodo Embedded MPP
  2. The Solution Manager
  3. The Denodo Scheduler server
  4. The Virtual DataPort server Correct answer.

Explanation

Virtual DataPort is the query engine and the server that accepts client connections over JDBC, ODBC, REST and other interfaces, parses incoming SQL, plans execution and returns results. Other components such as Scheduler and Solution Manager orchestrate or monitor but do not serve analytic queries to BI clients.

Question 43Denodo Platform Architecture and Components

What is the primary purpose of the Denodo Platform's caching mechanism in the context of the overall architecture?

  1. To convert relational data into graph format for storage
  2. To permanently replace source systems with a copy of their data
  3. To store query results locally so repeated queries can be served without re-accessing the sources Correct answer.
  4. To encrypt metadata at rest

Explanation

Caching in Virtual DataPort stores the results of views or queries in the server's own storage so that subsequent identical requests can be answered without hitting remote sources. It is a performance optimization and does not replace the sources as the system of record.

Question 44Denodo Platform Architecture and Components

In the Denodo architecture, what role does the Solution Manager play?

  1. It provides centralized monitoring, configuration management, and deployment of Denodo servers Correct answer.
  2. It stores the actual business data returned by queries
  3. It executes federated SQL queries against sources
  4. It generates web automation wrappers

Explanation

Solution Manager is the management console that centralizes monitoring, health diagnostics, configuration and deployment across Denodo servers in an environment. It does not execute user queries or store business data itself.

Question 45Denodo Platform Architecture and Components

A developer needs to connect a Java application to a Denodo virtual database using a standard driver. Which interface is the appropriate choice?

  1. The Solution Manager diagnostics port
  2. The ITPilot wrapper SDK
  3. The JDBC driver provided with the Denodo Platform Correct answer.
  4. The Scheduler REST API

Explanation

Virtual DataPort exposes a JDBC driver that Java applications use to connect, issue SQL and retrieve results like any relational database. The other listed interfaces serve orchestration, web automation or monitoring purposes rather than application query access.

Question 46Denodo Platform Architecture and Components

Which Denodo component is designed to orchestrate scheduled tasks such as periodic cache loads and data exports?

  1. Virtual DataPort
  2. Denodo Scheduler Correct answer.
  3. ITPilot
  4. Solution Manager

Explanation

Denodo Scheduler is the job scheduling and orchestration component that runs tasks on a defined timetable, including cache preloading, exports and data movement jobs. It works alongside Virtual DataPort, which performs the actual query execution.

Question 47Denodo Platform Architecture and Components

What does a Denodo virtual database contain?

  1. A physical copy of all source tables
  2. A set of views and data source definitions that expose integrated data without moving it Correct answer.
  3. A standalone graph database engine
  4. Only stored procedures written in Java

Explanation

A virtual database is a logical container holding views, data source connections, and related metadata that define how data is integrated and exposed. The underlying data stays in the sources and is retrieved at query time.

Question 48Denodo Platform Architecture and Components

Which statement best describes the relationship between data sources and views in a Denodo virtual database?

  1. Views and data sources are the same object with different names
  2. Data sources define connections to external systems, and views are defined over them to expose integrated data Correct answer.
  3. Views store data that sources read at runtime
  4. Data sources must be relational databases only

Explanation

Data sources hold the connection details and credentials needed to reach external systems, while views are the logical definitions built on top of them that present integrated, transformed data to consumers. Views depend on data sources but do not themselves store the source data.

Question 49Denodo Platform Architecture and Components

A team wants to expose a REST API from a Denodo view so that a mobile app can retrieve JSON results. Which Denodo capability supports this?

  1. The Solution Manager deployment API
  2. The Scheduler job history API
  3. The Virtual DataPort REST web service interface Correct answer.
  4. The ITPilot navigation log

Explanation

Virtual DataPort can publish views as REST web services, returning results such as JSON to consuming applications. The other APIs are administrative or orchestration interfaces and do not expose view data as a queryable service.

Question 50Denodo Platform Architecture and Components

An architect wants to reduce load on a slow source system that is queried repeatedly with the same aggregation. Which architectural feature of Virtual DataPort is most directly relevant?

  1. Enabling caching on the relevant view or query Correct answer.
  2. Deploying additional Solution Manager instances
  3. Configuring the source as a graph database
  4. Adding more Scheduler jobs

Explanation

Caching stores the results of a view or query so repeated identical requests are served from the Denodo server instead of re-querying the slow source. This directly reduces source load and improves response time for repetitive aggregations.