Create Next App

Exam contains 88 questions

Page 9 of 15

Question 49 🔥

Which three are recommended options on an X5 Exadata Database machine, for staging files that will be loaded as external tables?

Which database solution meets these requirements?

A. on an ACFS file system stored in a staging database on the Database Machine

Highly voted

B. a ZFS over NFS file system mounted on a database server where the external table will be accessed

Highly voted

C. an Exadata-based ACFS file system on the Database Machine

Highly voted

D. a DBFS file system stored in a staging database on the Database Machine

Highly voted

E. on local storage on one or more storage servers that are accessible to the database server where the load will be performed

Highly voted

Discussion of the question

Question 50 🔥

Which three are true concerning Hybrid Columnar Compression (HCC) deployed on Exadata storage?

Which database solution meets these requirements?

A. HCC can be used only when the Exadata Smart Flash Cache is configured in Write-Through mode.

Highly voted

B. HCC data is never cached in the Exadata Smart Flash Cache.

Highly voted

C. By default, decompression is performed by Exadata Storage Servers.

Highly voted

D. Rows residing in HCC compressed segments, are always self- contained in a single database block.

Highly voted

E. Rows residing in HCC compressed segments, are always self- contained in a single compression unit.

Highly voted

F. Row-level locks are supported on HCC compressed data.

Highly voted

Discussion of the question

Question 51 🔥

Which three statements are true about Recovery Manager (RMAN) daily differential incremental backup strategies on an X5 Database Machine for a database having 25% or more of its blocks modified each day and which has an 8 k block size?

Which database solution meets these requirements?

A. Fast incremental backups when 50% or more of the blocks have changed since the last backup, will run as slowly as normal incremental backup.

Highly voted

B. Enabling Block Change Tracking (BCT) on the database can result in reduced consumption of storage network bandwidth.

Highly voted

C. Enabling Block Change Tracking (BCT) on the database can result in a reduction of physical I/O on the cells during incremental backups.

Highly voted

D. For level-1 backups, Block Change Tracking (BCT) is most beneficial when more than 25 percent of the blocks have changed since the last backup.

Highly voted

E. For level-0 backups, Block Change Tracking (BCT) is most beneficial when more than 25 percent of the blocks have changed since the last backup.

Highly voted

F. cellsrv returns only blocks that have changed since the last backup.

Highly voted

Discussion of the question

Question 52 🔥

You plan to consolidate multiple mission-critical databases onto a single rack Exadata X6 database Machine.You do not plan to use virtualization on the database servers.You have identified two database categories, based on differing availability and maintenance objectives.Which two choices will be the best solution?

Which database solution meets these requirements?

A. Create a single database cluster that accesses a single storage grid.

Highly voted

B. Create a single database cluster that accesses multiple storage grids.

Highly voted

C. Partition the Exadata storage servers into two separate storage grids.

Highly voted

D. Create a single storage grid and share space on the celldisks using Exadata storage realms.

Highly voted

E. Partition the database servers into two separate clusters.

Highly voted

Discussion of the question

Question 53 🔥

The InfiniBand switches on your X5 Database Machine contain the software version as confirmed using the version command:[root@exampsw ib2 bin] # versionSUN DCS 36p version: 1.3.3-2 -Build time: Apr 4 2015 11:15:19 -SP board info:Manufacturing Date: 2014.05.05 -Serial Number: "NCD3X0178"Hardware Revision: 0x0006 -Firmware Revision: 0x0102 -BIOS version: NOW1R112 -BIOS date: 04/24/2014 -Which two tools are useful for monitoring the InfiniBand switches for fan problems and by which users should they be run?

Which database solution meets these requirements?

A. Run the env_test command on the switches after logging in as the ilom-admin user.

Highly voted

B. Run the getfanspeed command on the switches after logging in as root.

Highly voted

C. Run the env_test command on the switches after logging in as root.

Highly voted

D. Run the showtemps command on the switches after logging in as the ilom-admin user.

Highly voted

Discussion of the question

Question 54 🔥

Which three are true concerning Exadata Smart Flash Cache on X6 Database Machines with High Capacity Storage Servers?

Which database solution meets these requirements?

A. The "keep" cache is limited to a maximum of 80% of the total Smart Flash Cache capacity.

Highly voted

B. Smart Scan will always use the Smart Flash Cache for all I/Os fast full index capacity.

Highly voted

C. Smart Scan will always use the Smart Flash Cache for all I/Os for full table scans.

Highly voted

D. Single block reads can benefit from Smart Flash Cache.

Highly voted

E. Multiblock reads can benefit from Smart Flash Cache.

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_070

Exam contains 88 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us