1Z0-070 Online Practice Questions and Answers

Correct Answer: CEF

Explanation:

The first two disks of Exadata Storage Server are system disks. Oracle Exadata Storage Server Software

system software resides on a portion of each of the system disks. These portions on both system disks are

referred to as the system area.

The default configuration on Exadata is to have 3 diskgroups - DATA, RECO, and DBFS_DG.

Correct Answer: D

Explanation:

On both physical and virtual deployments, Exadata systems use minimal Linux distributions to ensure that

just the RPMs needed to run Oracle database, are installed and enabled.

References: http://www.oracle.com/technetwork/database/exadata/exadata-x5-2-ds-2406241.pdf

Correct Answer: BC

Explanation:

DBFS SecureFiles Store Capabilities include support for file system snapshots.

Oracle ACFS includes advanced features such as file system snapshot.

References:

http://www.oracle.com/technetwork/ru/database/dbfs-sf-oow2009-v2-160969.pdf

http://www.oracle.com/technetwork/database/database-technologies/cloud-storage/benefits-of-oracle-acfs2379064.pdf

Correct Answer: DE

Explanation:

D: The storage server software manages the flash cache and can recognize different types of I/O requests so that non-repeatable data access like RMAN backup I/O does not flush database blocks from the cache. It also prioritizes frequently accessed block types such as redo logs, control files, and index root blocks.

E: RMAN block change tracking allows incremental backups to run very quickly and efficiently. With block change tracking, only the areas of the database that have been modified since the last incremental backup or full backup are read from disk.

Incorrect Answers:

C: Database Flash Cache is separate from Exadata Smart Flash Cache. The Database Smart Flash Cache feature and increase the buffercache of your database from like 100G or 200G to 300-700G on that same server.

References: https://logicalread.com/using-oracle-exadata-flash-cache-mc05/#.Wd80zmiCyUk http://www.oracle.com/technetwork/database/availability/maa-tech-wp-sundbm-backup-11202-183503.pdf

Correct Answer: ACD

Explanation:

A: An Exadata snapshot database can be either a non-container database (non-CDB) or a container database (CDB). Creating an Exadata snapshot database of a CDB enables access to all of the pluggable databases in that container.

C: You can create two types of Exadata snapshots, depending on the current setup of your environment:

1.

You have a pluggable database (PDB) and want to create a test master from it.

2.

You have a container database (CDB) and want to create test masters from all its PDBs, or you have a simple non-container database and want to create a test master from it.

D: SPARSE disk group based database snapshots is functionality included in Exadata Storage Software. It requires Exadata Storage Software version 12.1.2.1.0 and Oracle Database 12c version 12.1.0.2 with bundle patch 5 or later. This feature is designed to work on native Exadata ASM storage disk groups. It uses ASM SPARSE grid disk based thin provisioning where snapshot databases created on a SPARSE disk group need only the space for changes plus some metadata, thereby enabling storage efficient snapshot databases.

References:

http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-snapshots.htm#SAGUG-GUIDE1D6EF45-36EF-40E3-A57E-F80B749E6122 http://www.oracle.com/technetwork/database/exadata/learnmore/exadata-database-copy-twp-2543083.pdf

Correct Answer: ACDF

Explanation: C: If you need to use HTTPS for security purposes, you can set up HTTPS/SSL for the ASR Manager HTTP receiver.

D: As part of the registration process for ASR Manager, you can optionally set the ASR Manager to access the internet through a proxy server.

References: https://docs.oracle.com/cd/E37710_01/install.41/e18475/ch2_asr_manager.htm#ASRUD137

Correct Answer: BD

Explanation:

The rescue procedure is necessary when system disks fail, the operating system has a corrupt file system,

or there was damage to the boot area. If only one system disk fails, then use CellCLI commands to

recover. In the rare event that both system disks fail simultaneously, you must use the Exadata Storage

Server rescue functionality provided on the Oracle Exadata Storage Server Software CELLBOOT USB

flash drive.

Incorrect Answers:

E, F: If only one system disk fails, then use CellCLI commands to recover.

References: http://docs.oracle.com/cd/E80920_01/DBMMN/maintaining-exadata-storageservers.htm#GUID-710814E7-4691-49EE-95AD-726D2D6C5BFE

Correct Answer: ACF

Explanation:

A: Fast Incremental backups is possible with Block change tracking, which is initially introduced from version 10.2 onwards, by this tool it's very useful to reduce the RMAN incremental backup duration. If the changes are something around 20% then in this situation BCT helps a lot.

C: Exadata Storage Server offload capability combined with RMAN block change tracking will efficiently perform large I/Os at the storage-tier level, returning only individual changed blocks for incremental backups and increasing the backup performance of the system.

Note: Level 1 backup: A level 1 backup includes only those blocks that have been changed since the "parent" backup was taken. Remember a parent backup may be either a level 0 or a level 1 backup. Block change tracking allows indeed the highest benefit for databases where the changes are not so high,

Level 0 backup: A level 0 incremental backup is physically identical to a full backup and it includes every data block in the file except empty blocks. The only difference is that the level 0 backup is recorded as an incremental backup in the RMAN repository, so it can be used as the parent for a level 1 backup.

References: http://www.dba-oracle.com/t_rman_backup_types.htm http://www.oracle.com/technetwork/database/availability/maa-tech-wp-sundbm-backup-11202-183503.pdf https://www.toadworld.com/platforms/oracle/w/wiki/11124.fast-incremental-backups-active-data-guard

Correct Answer: D

Explanation:

Step 1: 1. Create a new 12.1.0.2 Exadata –based database.

Step 2: 2. Export the source system metadata using transportable Tablespace (TTS).

Step 3: 3. Transfer the files to the Database Machine and use the RMAN CONVERT command to change

them to the little endian format.

Step 4: 4. Import the metadata into the target database.

This method is often chosen when migrating between platforms with different endian formats, or in cases

where physical re-organization is not necessary.

The transportable tablespace method is generally mu

References: https://docs.oracle.com/en/cloud/paas/exadata-cloud/csexa/mig-transportabletablespace.html

Correct Answer: ABD

Explanation:

A: Creating a Table with Advanced Row Compression

The following example enables advanced row compression on the table orders:

CREATE TABLE orders ... ROW STORE COMPRESS ADVANCED;

B: ARCHIVE LOW compression (Exadata only), recommended for Archival Data with Load Time as a critical factor

Incorrect Answers:

E: QUERY LOW compression (Exadata only), recommended for Data Warehouse with Load Time as a critical factor.

References: https://docs.oracle.com/database/121/ADMIN/tables.htm#ADMIN015 https://uhesse.com/2011/01/21/exadata-part-iii-compression/