Quiz
1Z0-931 Oracle Autonomous Database Cloud 2019 Specialist
Questions in this quiz (68)
1What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database? (Choose two.)
- AData Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database.
- BData Pump is platform independent - it can migrate Oracle Databases running on any platform.
- CData Pump is faster to migrate database than using RMAN (= Recovery MANager).
- DData Pump creates the tablespaces used by your Autonomous Database.
2The default eight-day retention period for Autonomous Database performance data can be modified using which DBMS_WORKLOAD_REPOSITORY subprogram procedure?
- AUPDATE_OBJECT_INFO
- BMODIFY_SNAPSHOT_SETTINGS
- CCREATE_BASELINE_TEMPLATE
- DMODIFY_BASELINE_WINDOW_SIZE
3Which task is NOT automatically performed by the Oracle Autonomous Database?
- ABacking up the database.
- BMask your sensitive data.
- CPatching the database.
- DAutomatically optimize the workload.
4Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)
- AThe DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse
- BThe DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
- CThe DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.
- DThe DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database
- EThe DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.
5Which of these database features is NOT part of the Autonomous Database?
- AOnline Indexing
- BFlashback Database
- CReal Application Clusters (RAC)
- DJava in the Database
6Which two statements are true with regards to Oracle Data Sync? (Choose two.)
- AData Sync can connect to any JDBC compatible source like MongoDB, RedShift and Sybase.
- BData Sync can use a normal OCI (thick) client connection to connect to an Oracle database.
- CData Sync can load your data in parallel in order to speed up the loading process.
- DData Sync has default drivers available that supported loading data from DB2, Microsoft SQL Server, MySQL and Teradata.
7Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)?
- AIn addition to the Oracle Client Credential Wallet, a user must have a username and password in order to connect to the Autonomous Database.
- BThe Oracle Client Credential file is downloaded as a ZIP file
- CThe Wallet for the Autonomous Database is the same as the Transparent Data Encryption (TDE) wallet.
- DYou MUST have an Oracle Client Credential Wallet in order to connect to the Autonomous Database.
8What is the predefined role that exists in Autonomous Database that includes common privileges that are used by a Data Warehouse developer?
- AADBDEV
- BADMIN
- CDWROLE
- DADWC
9Which two system privileges does a user need to create analytic views? (Choose two.)
- ACREATE ANALYTIC MEASURE
- BCREATE ANALYTIC LEVEL
- CCREATE ANALYTIC HIERARCHY
- DCREATE ANALYTIC VIEW
- ECREATE ATTRIBUTE DIMENSION
10What are three methods to load data into the Autonomous Database? (Choose three.)
- AOracle GoldenGate
- BTransportable Tablespace
- CRMAN Restore
- DOracle Data Pump
- ESQL*Loader
- FMV2ADB
11While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?
- AAutonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations
- BAutonomous Data Warehouse workloads are optimized for mixed workloads
- CAutonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.
- DData that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar
12When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?
- AActive transactions continue running unaffected
- BActive transactions are paused
- CScaling cannot happen while there are active transactions in the database
- DActive transactions are terminated and rolled back
13Which three statements are correct when the Autonomous Database is stopped? (Choose three.)
- AUser with DWROLE can still access the database
- BTools are no longer able to connect to a stopped instance
- CCPU billing is halted based on full-hour cycles of usage
- DIn-flight transactions and queries are stopped
14Which two are correct actions to take in order to Download the Autonomous Database Credentials? (Choose two.)
- AClick on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet
- BClick on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet
- CFind the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
- DClick on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.
- EClick the Compute section of the menu, then choose Instance Configurations, then Download Wallet
15How many pre-defined service names are configured in tnsnames.ora for a single Autonomous Transaction Processing database instance, and what are they called?
- ATwo. They are called ATP and ADW.
- BNone. There are no pre-defined service names in tnsnames.ora
- CThree. They are called high, medium and low
- DFive. They are called tpurgent, tp, high, medium and low
16If you need to connect to Autonomous Data Warehouse (ADW) using Java Database Connectivity (JDBC) via an HTTP proxy, where do you set the proxy details?
- Atnsnames.ora
- Bkeystore.jks
- Csqlnet.ora
- Dcwallet.sso
- Eojdbc.properties
17Your customer receives information in various formats like .csv files from their suppliers. The business user would like to collect all of this information and store it in a ATP environment. The Oracle adviser recommends to use Oracle Data Sync for this.
Which statement is true regarding Oracle Data Sync?- AData Sync can only load files into tables (insert-only), the customer has to write the additional code.
- BData Sync can not transform your data while loading it into the destination table
- CData Sync can load a combination of data source, such as .csv, .xlsx and Oracle relational files
- DData Sync can only load data from one source into one destination table
18The 3rd party application that your customer wants to migrate to Autonomous Database (ADB) has some specific demands like tablespace names, usernames and init.ora parameters. The decision was made to adhere to the suggested migration method using an instant client and the datapump version that was suggested (and came with it).
Which statement is true about the migration of the application's database success?- AThe migration can be technically a success but the 3-rd party vendor needs to support the result
- BThe suggested datapump version will create an alias for non-standard tablespace names so the migration is successful.
- CThe tablespace names will result in a blocking error during datapump import because of ADB limitations
- DThe migration can be a success, both technically and functional due to datapump enhancements
19A customer wants to migrate to Autonomous Database (ADB) but only allows for a very small window of downtime. Golden Gate was advised to be used during the migration. For maximum reassurance of their end-users, the customer also would like to use Golden Gate as a fall-back scenario for the first 6 months after the migration. If customers complain, the on-premise data can be synchronised with the ADB Instance for a switch back. Which statement about the migration using Golden Gate is correct?
- AMigration to ADB is not possible using Golden Gate because the apply-process cannot be installed on ADB
- BOnly the migration to ADB is possible from an on-premise installation of Golden Gate
- CGolden Gate on premise is not certified with ADB because Golden Gate Cloud Service exists for this
- DThe fallback scenario is not possible using Golden Gate because the capture-process cannot be installed on ADB
- EThe described scenario is correct, can be used for migration and fallback scenarios
20Which statement is true regarding database client credentials file required to connect to your Autonomous Database?
- APlace the credential files on a share drive that all users can use to connect to the database
- BThe Transparent Data Encryption (TDE) wallet can be used for your client credentials to connect to your database
- CStore credential files in a secure location and share the files only with authorized users to prevent unauthorized access to the database
- DWhen you share the credential files with authorized users, mail the wallet password and the file in the same email
21In which way can a SQL Developer help you test your data loading scenario to Autonomous Database (ADB)?
- AIn the TEST phase of the wizard, a subset of accepted records is displayed based on your definition
- BIn the TEST phase of the wizard a list is generated containing the records that would be rejected during import.
- CIn the Column Definition Phase, the system cross-references with the file-contents and shows the conflicts with the definition
- DIn the TEST phase, a temporary table will be populated with the records before inserting them in the destination table
22Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?
- AOn the Autonomous Database Console
- BSSH keys are not required in Oracle Cloud Infrastructure
- CSSH keys cannot be added from console. They have to be added using REST APIs only
- DNavigate to Identity, select Users panel on the console and select "Add Public Key"
23Which statement is true in regards to database links?
- AYou can call PL/SQL procedures and functions using a database link
- BConnect from Autonomous Database to remote database using a database link
- CConnect to Autonomous Database from remote database using a database link
- DCreate a database link from one Autonomous Database to another Autonomous Database instance
24How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?
- AUsing Database Configuration Assistant (DBCA) on the database server.
- BIt cannot be done
- CConnecting to the Cloud Infrastructure Command console via SSH wallet
- DUsing the Oracle Cloud Infrastructure Command Line interface tool or REST API calls
25Which Autonomous Database Cloud service ignores hints in SQL Statements by default?
- AAutonomous Transaction Processing
- BAutonomous Data Warehouse
- CNeither service ignores hints by default
- DBoth services ignore hints by default
26Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)?
- AReplicate the table using Golden Gate
- BCreate a Data Set
- CLoad data using Data Pump
- DImport Table
27Which is correct about security features that are available in Oracle Autonomous Database?
- ATDE but not Data Redaction
- BData Redaction and TDE are both supported
- CData Redaction but not TDE
- DNeither Data Redaction nor TDE are supported
28What is the default retention period for both Automatic and Manual Autonomous Database Backups?
- AOne Year
- B7 days
- C60 days
- D30 days
- E90 days
29Which three statements are true regarding how Autonomous Database provides data security? (Choose three.)
- AData is encrypted at rest using transparent data encryption
- BNetwork connections from clients to Autonomous Database are encrypted using the client credentials wallet.
- CUsers are given OS logons or SYSDBA privileges to prevent phishing attacking
- DOracle automatically applies security updates to ensure data is not vulnerable to known attack vectors
30When exporting a notebook, what type of file is created?
- AXML
- BTXT
- CJSON
- DSQL
- EASCII
31What two tasks can be executed from the service console for Autonomous Databases? (Choose two.)
- AAutonomous Databases monitoring for usage and query performance
- BCreating schemas
- CCreating and scaling of Autonomous Database service
- DWizard to download connection wallet for connection from desktop tools
32What predefined user is created when an Autonomous Database (ADB) instance is created that you connect to in order to create other users and grant roles?
- ASCOTT
- BADMIN
- CSYS
- DDWDEV
33What REST verb is used to create an Autonomous Database service using REST APIs?
- AA "POST" REST call
- BA "PUT" REST call
- CAn "INSERT" REST call
- DA "GET" REST call
34Which operating system can Data Visualization Desktop be run on?
- AAIX
- BLinux
- CWindows
- DSolaris
35Which two PL/SQL functions can be used to validate an analytic view? (Choose two.)
- AVALIDATE_LEVELS
- BVALIDATE_HIERARCHY
- CVALIDATE_DIMENSION
- DVALIDATE_ANALYTIC_VIEW
- EVALIDATE_MEASURES
36Which three tasks by default are taken care of by the Autonomous Database? (Choose three.)
- ABackups
- BFirmware Patching
- CData Loading
- DDatabase Upgrades
- EApplication User Creation
37A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during non-peak hours. The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well.
Which Oracle Cloud Infrastructure database service is appropriate for this scenario?- ASince the application needs to be highly available, it should to be deployed on a Kubernetes Cluster
- BADW since operational reporting is a higher priority in this scenario
- CIt is best to build a separate data warehouse, and move the OLTP data on a nightly basis
- DATP. Using 'tpurgent' and 'high' TNS services to separate connection types
38As a database architect you are tasked with configuring a high concurrency, production OLTP application to connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode.
Which connection service is appropriate for such a workload?- AHIGH
- BTP
- CMEDIUM
- DTPURGENT
39Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)
- AThe source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.
- BThe source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage
- CA valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure
- DThe source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully
- EThe target table will be created in Autonomous Database if it does not already exist
40Autonomous Data Warehouse configures and optimizes your database for you, therefore you do not need to perform some of the administration operations for configuring the database.
Which statement is true regarding the default configuration of the Autonomous Data Warehouse?- AIn Autonomous Data Warehouse direct access to the database node and the local file system is allowed
- BDegree of parallelism for SQL statements is set based on the number of OCPUs in the system and the database service the user is connecting to
- CAdding, removing, or modifying tablespaces is allowed
- DCompression is not enabled by default and you must specify the compression method for your tables with the compression clause in your CREATE TABLE and ALTER TABLE commands
41What are two security features enabled by default by the Autonomous Database?
(Choose two.)- ATransparent Data Encryption
- BEncrypted Database Links
- CSQL Net Encryption
- DOne SYSDBA account
- ERead Only access to OS Audit logs
42Which method can be used to migrate on-premises databases to Autonomous Databases in cloud?
- AOriginal Import/Export tools
- BPhysical migration method like database cloning
- CData Pump
- DRMAN backup & restore
43Which two statements are true about the Oracle Cloud Infrastructure (OCI)? (Choose two.)
- AAn OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region
- BBecause availability domains do not share infrastructure such as power or cooling, or the internal availability domain network, a failure at one availability domain within a region is unlikely to impact the availability of the others within the same region
- CA single fault domain can be associated with multiple regions and availability domains
- DRegions are dependent on other regions and must be located with 5 thousand kilometers of each other
44Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)
- Athrough the Oracle Cloud Infrastructure service console
- Bthrough SQL/Developer s
- Cusing DBMS_CLOUD_ADMIN package
- Dthrough SQLPIus
45Which Autonomous Database Service is NOT used to conned to an Autonomous Transaction Processing instance?
- ATPURGENT
- BMEDIUM
- CHIGH
- DLOW
- ETPPERFORMANT
46When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage?
- AStorage in TB cannot be larger than the number of OCPUs
- BOCPUs and storage must remain in sync
- CIncreasing OCPUs will automatically increase storage
- DOCPUs and storage can be scaled independently
47Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)
- ABackup and recovery must be done using Recovery Manager(RMAN).
- BSelect the snapshot of the backup.
- CSelect the archived redo logs.
- DSelect the backup from which restore needs to be done
- ESpecify the point in time (timestamp) to restore.
48Which is NOT required to connect to Autonomous Database from SQL developer?
- ADatabase name
- BService name
- CWallet file
- DUsername and password
49What are the two methods that could be used during the migration of your existing Oracle database to Autonomous Database? (Choose two.)
- AGolden Gate
- BRecovery Manager (RMAN)
- CCSV files copied to Autonomous Database block storage
- DData Pump
50Which open source orchestration tool can be used to provision autonomous database resources in Oracle Cloud Infrastructure?
- ATerraform
- BREST API
- CDlocker
- DEnterprise Manager
51Which is the correct subset of services offered via OCI-CLI (command line interface) for Autonomous Database (ABD) via calls made to the OCI API's?
- ACreate, Query, Update, List, Start
- BCreate, Get, List, Stop, Restore
- CStart, Delete, Update, Query, Stop
- DCreate, Query, List, Stop, Restore
52What two methods can you use to define Machine Learning Users? (Choose two.)
- AUse DBMS_CLOUD_ADMIN package
- BSQL/Developer
- COracle Cloud Infrastructure Console
- DClient tools
53Migrating an on-premise database to Autonomous Database (ADB) for large amounts of data involves multiple steps like creating a credential object, creating (access to) a storage object/location, running datapump export and running a datapump import.
Which three statements are true for SQL Developer (18.3 and up) in combination with ADB Data Loading? (Choose three.)- ASQL Developer can be used to export/move/import of a database to ADB in 1 set of wizard steps
- BSQL Developer can import files (.dmp and .csv for example) into ADB which are located on Amazon S3 Object storage
- CSQL Developer can import .csv files into ADB which are located on the system where SQL Developer is running
- DSQL Developer can only export/move/import files using datapump from databases running on Linux systems
- ESe puede ejecutar SQL Developer desde la consola
54Which Java Database Connectivity (JDBC) thin client version supports the use of HTTP proxy settings that does NOT support TCP to connect to Autonomous Data Warehouse?
- A18.1 onwards
- BAny version
- C17.4 onwards
- D12c Release 2 onwards
55Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production.
How should the customer unplug their database to migrate to Autonomous Database (ADB)?- APluggable databases cannot be migrated to ADB using plug, unplug or clone
- BCreate a database link from source database to the ADB environment and clone the PDB.
- CUnplug to an xml file so database files and xml file can be uploaded to object storage
- DUnplug into a pdb archive which can be uploaded to object storage
56Given the steps:
1. Create Oracle Machine Learning User
2. Create projects
3. Create workspaces
4. Create Notebooks
5. Run SQL Scripts
Which two steps are out of order when working with Oracle Machine learning? (Choose two.)- ACreate Oracle Machine Learning User
- BCreate workspaces
- CCreate Notebooks
- DRun SQL Scripts
- ECreate projects
57Which can be Scaled independently of the number of CPUs in an Autonomous Database?
- AMemory
- BConcurrency
- CSessions
- DParallelism
- EStorage
58Which statement about the Export Wizard used to export database objects and data is NOT correct?
- AIf "Dependents" is checked as a DDL Option, for non-privileged users, only dependent objects in their schema are exported.
- BExport DDL includes features such as "Show schema," "Storage," and "Terminator."
- CIf "Grants" is checked as a DDL Option, GRANT statements are included for any grant objects on the exported objects, including those owned by the SYS schema
- DIf "Clipboard" is selected as the "Output," the output will be placed on the system clipboard, so that it can be pasted into a file, a command line, or other location appropriate for the format
59When you connect Oracle Analytics Cloud to the Autonomous Data Warehouse, what file needs to be uploaded?
- ATNSNAMES.ORA
- BCWALLET.SSO
- COJDBC.PROPERTIES
- DSQLNET.ORA
60Users are required to select a service when connecting to Autonomous Data Warehouse and these services match to one of three different consumer groups: High, Medium, and Low.
Which statement about these consumer groups is correct?- AMedium provides intermediate resource and concurrency, and queries run in a serial
- BLow provides highest concurrency, lowest resources, and DoP =1
- CHigh provides highest resources, lowest concurrency, and DoP is 1
- DHigh provides highest concurrency and lowest resources, and DoP is 1
61When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection?
- ADBNAME_MEDIUM
- BDBNAME_HIGH
- CDBNAME_CONCURRENT
- DDBNAME_LOW
62Which three data dictionary views contain information about analylic view objects?
- AALL_ANALYTIC_VIEW_PATHS
- BALL_ANALYTIC_VIEW_DIM_CLASS
- CALL_ANALYTIC_VIEW_ID_ATTRS
- DALL_ANALYTIC_VIEW_LVLGRPS
- EALL_ANALYTIC_VIEW_KEYS
63Which is the default port number for ADW and ATP?
- A1521
- B1522
- C1523
- D1524
- E1525
- F1526
64Depending on your JDBC or UCP connections are set up, you will need to do some of the following.
- AYou will need JDK 8 or higher, specifically the JDK8u161 or higher, installed.
- BAlso, there are specific JAR files needed to be in place.
- CIf you're using JDBC Thin Driver 12.2.0.1 ojdbc8.jar, then you will need the 12.2.0 upc.jar.
- DIf you're using the patched JDBC Thin Driver 12.1.0.2 ojdbc7.jar, then you will need the 12.1.0.2 upc.jar.
65Elementos que te llevas al importar en Data Pump (Elegir 2 opciones)
- AData
- BSchema
- CTablespaces
66Sobre que infraestructura esta funcionando ADB:
- ABar-metal
- BExadata
- COracle Linux
67A la hora de cargar datos, que procedimientos de DBMS_CLOUD se utilizan (elegir 2)
- ACOPY_DATA
- BCREATE_EXTERNAL_TABLE
- CGET_DATA
- DCREATE TABLE AS SELECT
68¿Qué dos diferencias hay en cuanto a optimización entre ATP y ADW?
- AUndo Manage
- BMemory usage
- CData format
- DIndex storage
- EBackup
Information
- Description
- Oracle Autonomous Database Cloud 2019 Specialist
- Author
- Dani Rodrigáñez
- Language
- Español
- Views
- 451
- Tags
- Rating
- No ratings yet Rate this quiz