A data warehouse is a subject-oriented data set used for reporting and analusis. Data warehouses can be subdivided into ( ). Which store subsets of data from a warehouse.  

相似题目

• USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methodswould you use to achieve this?（）

  A . Use Data Pump to transfer the existing data to a new encrypted tablespace B . Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespace C . Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace D . Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace E . Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted

  查看最佳答案

• Which extinguishing agent is NOT recommended in the Chemical Data Guide for use on a cyclohexane fire?（）

  A . Foam B . Carbon dioxide C . Dry chemical D . Water fog

  查看最佳答案

• According to the Chemical Data Guide，epichlorohydrin is a(n)（）.

  A . corrosive B . class B poison C . oxidizer D . explosive

  查看最佳答案

• Which of the following is a characteristic of a data center core？（）

  A .  Server-to-server traffic always remains in the core layer. B .  The recommended practice is for the core infrastructure to be in Layer 3. C .  The boundary between Layer 2 and Layer 3 should be implemented in the aggregation layer. D .  The Cisco Express Forwarding hashing algorithm is the default， based on the IP address andLayer 4 port. E .  Core layer should run BGP along with an IGP because iBGP has a lower administrativedistance than any IGP.

  查看最佳答案

• A customer is evaluating PowerVM and VMware to run a data warehouse application. Which feature of PowerVM should be highlighted as a differentiator?（）

  A . PowerVM offers partition mobility. B . PowerVM can virtualize network and SAN resources. C . PowerVM supports multiple operating systems running concurrently. D . PowerVM allows an LPAR to use activated cores and memory without limitation.

  查看最佳答案

• Which data is not painted on the bow of a lifeboat?（）.

  A . Number of persons allowed B . Name of the vessel C . Weight of the boat D . Home port

  查看最佳答案

• （）is not a physical wall, but a lot of virtual data to protect the computer network.

  A . Data wall B . Data Channel C . Data base D . firewall

  查看最佳答案

• What is the international standard for transmitting data over a cable sys tem?（）

  A . PPPoE B . DOCSIS C . CMTS D . AAL5

  查看最佳答案

• For which of the following is a data warehouse optimized?（）

  A . Backup and recovery B . Transactions C . Security D . Querie

  查看最佳答案

• The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）

  A . Restore the data file and perform incomplete recovery. B . Restore the data file and perform point-in-time recover. C . Drop the tablespace and lose all data in the tablespace. D . Restore the database and lose all data since the last backup.

  查看最佳答案

• The TS7650G is a data deduplication server for open systems servers attached to storageenvironments over a（）.

  A . SAS connection  B . SCSI connection  C . iSCSI connection  D . Fibre Channel (FC) connection&e

  查看最佳答案

• A customer plans to implement a new OLTP and data base application. The records are smalland access is random, with a lot of write activity. Which RAID level is the best solution for thisapplication?（）

  A . RAID 1 B . RAID 3 C . RAID 5 D . RAID 10

  查看最佳答案

• An administrator is at a remote data center assisting a colleague who is replacing a bad fibre channel  adapter.  Which command can be used to manage a hot plug slot without powering off or rebooting the  server（）

  A . drslot B . Isslot C . Isattr D . prtconf

  查看最佳答案

• A pSeries server is being used as a file server and all data is stored on a non-root volume group and resides on mounted filesystems. Which of the following commands provides the quickest way to backup all of the data and filesystem definitions？（）

  A . tar B . cpio C . savefs D . savevg

  查看最佳答案

• Your SQL Server 2005 database contains a table that has 500 million rows of data. Some of the data is historical and some is current. You need to partition the data on a single server to increase performance and optimize maintenance. What should you do？（）

  A . Implement horizontal partitioning. B . Implement vertical partitioning. C . Implement a raw partition. D . Implement distributed partitioning.

  查看最佳答案

• A product manager has prepared catalog data using a spreadsheet and has exported the data to a file in CSV format. What is the correct sequence to execute the Loader Package tools to import the data into the WebSphere Commerce database？（）

  A . Extractor， ID Resolver， XML Transformer， Mass Loader B . ID Resolver， Text Transformer， Mass Loader C . Text Transformer， XML Transformer， ID Resolver， Mass Loader D . XML Transformer， ID Resolver， Mass Loader E . XML Transformer， Mass Loader， ID Resolver

  查看最佳答案

• _______________ is a work arrangement that does not require an employee to commute to a central and physical place of work., such as an office building, warehouse, or store.

  查看最佳答案

• A computer file is a collection of ( ) data, used to organize the shortage and processing of data by computer.

  查看最佳答案

• 37. A weather map is a synoptic data because it _____.

  查看最佳答案

• （72） is a collection of data sets, which is so large and complex that it becomes difficult to process using on-hand database management tools or traditional data processing applications.

  A．Big data B．Cluster C．Parallel computing D．Data warehouse

  查看最佳答案

• You are the administrator of a SQL Server 2000 computer. Each evening after business hours, you perform. database maintenance tasks. You create a Data Transformation Services package to populate the data warehouse. MAPI is not installed on the server.

  You want to schedule the DTS package to run each night. You want to attend to other duties while the DTS package is executing. You also want to be notified if the DTS package fails. What should you do？ A．Select the DTS packages log package execution to SQL server check box. Create a SQL server event alert to notify you if the package fails. B．Select the DTS packages write completion status to event log check box. Create a SQL server event alert to notify you if the package fails. C．Configure the DTS package to include an on failure precedence constraint and a send mail task. Configure the send mail task to notify you if the package fails. D．Configure the DTS package to include an on failure precedence constraint and a send mail task. Configure the execute process task to execute a not send command that will notify you if the package fails.

  查看最佳答案

• Examine the description of the MARKS table:SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects.Examine this SELECT statement based on the MARKS table:What is the result of the SELECT statement？（）

  <img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/1179420481e271350f195c64f9e527b9.jpg' /> <img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/a88968eec9764c2a8638e3aee2b1e23d.jpg' /> A. The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject. B. The statement returns an error at the SELECT clause. C. The statement returns an error at the WHERE clause. D. The statement returns an error at the ORDER BY clause.

  查看最佳答案

• Wiretapping to obtain data in a network is an interruptive action.（)

  是 否

  查看最佳答案

• ______ is a query language for manipulating data in a relmional database.

  A．Assemble B． SQL C． C++ D． Fortran

  查看最佳答案