logo资料库

1z0-931-ADW-0528-converted.pdf

发布时间：2022-06-24 发布人：admin 分类：说明书 资料大小：0.09M 资料格式：pdf 举报 版权申诉
第1页 / 共21页
第2页 / 共21页
第3页 / 共21页
第4页 / 共21页
第5页 / 共21页
第6页 / 共21页
第7页 / 共21页
第8页 / 共21页
资料共21页，剩余部分请下载后查看
    1 ADW 1. The DBMS_CLOUD Package refers to source files in the Oracle Cloud Infrastructure Object Storage. If your source files reside in Oracle Cloud Infrastructure Object Storage, what is the format for a file? https://objectstorage.tenancy.oraclecloud.com/v1/object_storage _namespace/bucket/filename https://swiftobjectstorage.region.oraclecloud.com/v1/object_sto rage_namespace/bucket/filename https://objectstorage.region.oraclecloud.com/n/object_storage_n amespace/b/bucket/o/filename https://tenancy.objectstorage.oraclecloud.com/object_storage_na mespace/b/bucket/o/filename A. B. C. D. E. https://swiftobjectstorage.tenancy.oraclecloud.com/v1/object_st orage_namespace/bucket/filename ATP p.127 or ADW p.132 2. Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing? A. Undo Management B. Memory Usage C. Index Storage D. Backup Retention E. Data Organization SG p.19 3. When using Data Pump to migrate your Oracle Data to Autonomous Database, which two objects are expected? A. Tablespaces B. Schemas C. Data D. Reports
    4. Which file is NOT a component of the client credentials wallet used to connect to an ATP Database? A. sqlnet.ora B. cwallet.sso C. truststore.jks D. keystore.jks E. ewallet.p12 F. protocol.ora ADW p.30 or ATP p.29 tnsnames.ora sqlnet.ora, cwallet.sso ewallet.p12,keystore.jks truststore.jks, ojdbc.properties 5. A 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 synchronized with the ADB instance for a switch back. Which statement about the migration using Golden Gate is correct? apply-process cannot be installed on ADB. the capture-process cannot be installed on ADB. A. The fallback scenario is not possible using Golden Gate because B. Migration to ADB is not possible using Golden Gate because the C. The described scenario is correct, can be used for migration and D. Only the migration to ADB is possible from an on-premise E. Golden Gate on premise is not certified with ADB because Golden fallback scenarios. installation of Golden Gate. Gate Cloud Service exists for this. 6. Which is the correct subset of services offered via OCI-CLI(command line interface) for Aunomous Database(ADB) via calls made to the OCI API's? A. Create,Query,List,Stop,Restore B. Create,Query,Update,List,Start C. Create,Get,List,Stop,Restore D. Start,Delete,Update,Query,Stop
    7. When exporting a notebook, what type of file is created? A. XML B. SQL C. ASCII D. TXT E. JSON ML p.16 8. Which statement is true in regards to database links? A. Connect to Autonomous Database from remote database using a B. You can call PL/SQL procedures and functions using a database C. Create a database link from one Autonomous Database to another D. Connect from Autonomous Database to remote database using a Autonomous Database instance. database link. link. database link. ATP p.141 or ADW p.146 9. Which can be Scaled independently of CPUs in an Autonomous Database? A. Concurency B. Memory C. Sessions D. Storage E. Parallelism ATP p.11 or ADW p.13 10. When scaling OCPUs in Autonomous Database, which statement is ture in regards to active transactions? A. Active transactions are paused. B. Scaling cannot happen while there are active transactions in the database. C. Active transactions continue running unaffected. D. Active transactions are terminated and rolled back. ATP p.11 or ADW p.13
    11. Which is NOT required to connect to Autonomous Database from SQL developer? A. Username and password B. Wallet file C. Database name D. Service name SG p.98 username & password, connection type, configuration file ( credential zip file), service 12. Which two methods can you use to create users and grant roles in Autonomous Database services? A. through SQL/Developer B. through the Oracle Cloud Infrastructure service console C. using DBMS_CLOUD_ADMIN package D. through SQLPlus ATP p.80 or ADW p.84 13. Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls? A. Navigate to Identify, select Users panel on the console and select 'Add Public Key'. B. On the Autonomous Database Console. C. SSH keys are not required in Oracle Cloud Infrastructure. D. SSH keys cannot be added from console. They have to be added using REST APIs only. 14. Which two are correct actions to take in order to Download the Autonomous Database Credentials? A. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet. B. Click on the Autonomous Data Warehouse section, pick a database, C. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client credentials(Wallet). D. Click on the Object Storage and find your Autonomous Bucket and then Choose Actions, then Download the Wallet. Download the Wallet Credentials.
    E. Click the Computer section of the menu, then choose Instance Configurations, then Download Wallet. ATP p.28 or ADW p.29 and SG p.89 15. Which two statements are true about the The Oracle Cloud Infrastructure(OCI)? domain is one or more data centers located within a region. A. An OCI region is a localized geographic area, and an availability B. Because 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. C. A single fault domain can be associated with multiple regions D. Regions are dependent on other regions and must be located with and availability domains. 5 thousand kilometers of each other. 16. The default eight day retention period for Autonomous Database performance data can be modified using which DBMS_WORKLOAD_REPOSITORY subprogram procedure? A. CREATE_BASELINE_TEMPLATE B. MODIFY_SNAPSHOT_SETTINGS C. UPDATE_OBJECT_INFO D. UPDATE_OBJECT_INFO ATP p.90 or ADW p.94 17. Which operating system can Data Visualization Desktop be run on? A. Linux B. Windows C. AIX D. Solaris 18. What are three methods to load data into the Autonomous Database? A. Transportable Tablespace B. Oracle Data Pump
    C. SQL*Loader D. RMAN Restore E. Oracle GoldenGate ATP p.50 or ADW p.51 19. Which three data dictionary views contain information about analytic view objects? A. ALL_ANALYTIC_VIEW_KEYS B. ALL_ANALYTIC_VIEW_LVLGRPS C. ALL_ANALYTIC_VIEW_PATHS D. ALL_ANALYTIC_VIEW_ID_ATTRS E. ALL_ANALYTIC_VIEW_DIM_CLASS REF p.12 ALL_ANALYTIC_VIEW_ATTR_CLASS ALL_ANALYTIC_VIEW_BASE_MEAS ALL_ANALYTIC_VIEW_CALC_MEAS ALL_ANALYTIC_VIEW_CLASS ALL_ANALYTIC_VIEW_COLUMNS ALL_ANALYTIC_VIEW_DIM_CLASS ALL_ANALYTIC_VIEW_DIMENSIONS ALL_ANALYTIC_VIEW_HIER_CLASS ALL_ANALYTIC_VIEW_HIERS ALL_ANALYTIC_VIEW_KEYS ALL_ANALYTIC_VIEW_LEVEL_CLASS ALL_ANALYTIC_VIEW_LEVELS ALL_ANALYTIC_VIEW_LVLGRPS ALL_ANALYTIC_VIEW_MEAS_CLASS ALL_ANALYTIC_VIEWS
    20. What is the default retention period for both Automatic and Manual Autonomous Database Backups? A. 7 days B. 90 days C. One year D. 30 days E. 60 days ATP p.99 or ADW p.104 21. What are the two methods that could be used during the migration of your existing Oracle Database to Autonomous Database？ A. Data Pump B. CSV files copied to Autonomous Database block storage C. Recovery Manager(RMAN) D. Golden Gate ATP p.50 or ADW p.51 22. Which Java Database Connectivity(JDBC) thin client version supports the user of HTTP proxy settings that dose NOT support TCP to connect to Autonomous Data Warehouse? A. 12c Release 2 onwards B. Any version C. 17.4 onwards D. 18.1 onwards ADW p.43 23. As a database architect you are asked 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? A. MEDIUM B. TP C. TPURGENT D. HIGH ATP p.94 TPURGENT: The highest priority application connection service for time critical transaction processing operations. This connection
    service supports manual parallelism. 24. Users 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? A. Low provides highest concurrency,lowest resources,and DoP=1. B. High provides highest concurrency and lowest resources,and Dop C. Medium provides intermediate resource and concurrency,and D. High provides highest resources,lowest concurrency,and Dop is queries run in a serial. is 1. 1. SG p.96 HIGH • Highest resources, lowest concurrency • Queries run in parallel MEDIUM • Less resources, higher concurrency • Queries run in parallel LOW • Least resources, highest concurrency • Queries run serially 25. Migrating 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? in 1 set of wizard steps. for data loading scenarios. A. SQL Developer can be stared from the ADB Cloud console but only B. SQL Developer can be used to export/import of a database to ADB C. SQL Developer can import .csv file into ADB wich are located on D. SQL Developer can only export/move/import files using datapump E. SQL Developer can import files(.dmp and .csv for example) into the system where SQL Developer is running. from databases running on Linux systems. ADB which are located on Amazon S3 Object storage.
    分享到：
    赞 收藏

    相关推荐

    资料库

    数据库

    共收录1218份资料，累计14个分类，关注成员有19位，主要包括：NoSQL,MongoDB,Redis,SQLite,Memcached,DB2,Sybase,Informix,PostgreSQL,MySQL,SQLServer,Access,Oracle,其它

    热门标签

    NoSQL MongoDB Redis SQLite Memcached DB2 Sybase Informix PostgreSQL MySQL SQLServer Access Oracle 其它

    最新资料