Online Access Free P2090-047 Practice Test

Which is a function of the Linux-HA heartbeat?

• A.Performs regeneration of failed disks on the hosts.
• B.Manages communication and status of services on the hosts.
• C.Manages communication and processes on the S-Blades.
• D.Performs disk partitioning and status of jobs on the S-Blades.

Which statement is true about a simple load using external tables?

• A.The load can be configured to automatically create a backup file of the table being loaded.
• B.The load can be configured to automatically create a duplicate copy of the table being loaded.
• C.The load can be configured to automatically continue to load if the S-Blade resets or fails.
• D.The load can be configured to automatically remove duplicate rows from the table being loaded.

Which statement is true?

• A.All user space is available for database expansion.
• B.When creating the database you can specify which disks to use.
• C.When you create a database you can set the maximum space it is allowed to use.
• D.Each database is assigned it's own section of disk space.

What are two considerations for usage of materialized views? (Choose two)

• A.Materialized views may improve query performance.
• B.Materialized views are not supported.
• C.Materialized views are logical entities.
• D.Materialized views are the same as database views.
• E.Materialized views are considered for usage by the Optimizer.

Which two statements are true about queries on the PureData System for Analytics Appliance? (Choose two.)

• A.Queries must be compressed before they can be executed.
• B.Queries must be uncompressed by the user and executed in parallel by the host.
• C.Queries are compiled into snippets and executed in parallel by the S-Blades.
• D.A query is compiled into a snippet which is executed across all available S-Blades.
• E.Queries are executed in parallel by the host.