单选题Which of the following is a typical data warehouse query?（）A What is this customers address?B Does this customer have any unpaid bills?C What is the balance in this customers account?D What are the total sales for each of the last 6 months?

题目
单选题
Which of the following is a typical data warehouse query?（）
A

What is this customers address?

B

Does this customer have any unpaid bills?

C

What is the balance in this customers account?

D

What are the total sales for each of the last 6 months?

相似考题

1.Which of the following is not among the basic features of a relational database?A．It does not matter what order the rows are in.B．It does not matter what order the columns are in.C．Different columns should have different column names.D．Different columns should have different data types.

2.What does the first letter require Ms. Walter to do?A.Call the Customer Service Center B.Sent payment to the utilities firm C.Review two bills from last year D.Verify her account balance

3. A user reports that their laptop does not have network connectivity, but was working fine last week. The technician executes IPCONFIG to see what the IP address is but it comes up with a 169.254.254.1 address. This address is not part of the company's subnet. Which of the following MOST likely identifies this address type?（）A、MulticastB、DHCPC、APIPAD、Broadcast

4.Examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:What is the result when the query is executed?()A.B.C.D. The query fails because the subquery returns more than one row.E. The query fails because the outer query and the inner query are using different tables.

更多“单选题Which of the following is a typical data warehouse query?（）A What is this customers address?B Does this customer have any unpaid bills?C What is the balance in this customers account?D What are the total sales for each of the last 6 months?”相关问题

  • 第1题：

    A storage specialist is assessing a customer’s tape backup environment. Which of the following questions would be the most appropriate question to identify the customer’s environment？（）

    • A、Has there been any recent loss of data？
    • B、How many tape drives are in the Library？
    • C、What tape technology is currently being used？
    • D、What software is being used for restoring the data？

    正确答案:C

  • 第2题：

    When dealing with customers on the phone that are not very comfortable with technology, which of the following techniques would be MOST helpful to ensure that effective communication is taking place?（）

    • A、Frequently paraphrase what the caller is saying.
    • B、Repeat what is being said multiple times so that the customer can understand exactly what to do.
    • C、Speak very slowly when replying to the customer.
    • D、Tell the customer to send an email stating exactly what the problem is so that the communication between the two parties is clear.

    正确答案:A

  • 第3题：

    Which service component within the prepare phase recommends the appropriate technology strategy to address a business requirement of the customer？ Select exactly 1 answer（s） from the following：（）。

    • A、identifying what a customer requires from a proposed solution
    • B、analyzes the customers business requirements and recommends the appropriate Cisco technologies to meet business requirements
    • C、determining what end-user training a customer requires
    • D、addressing a customer’s physical requirements

    正确答案:B

  • 第4题：

    A customer has a new p5-550 running AIX 5.2 that is SAN-attached to a FAStT900.  They have encountered hangs lasting over a minute on their new system during application load testing.  They called the pSeries technical specialist for advice.  Which of the following would be the most appropriate questions to determine their next step in resolving the problem？（）

    • A、Are there any errors in the error log？ Do they indicate any hardware or software errors？
    • B、Has performance data been collected？ What do the results show in terms of I/O statistics？
    • C、Has performance data been collected？ What do the results show in terms of CPU utilization？ 
    • D、What type of SAN switch is the customer using？ What are the microcode levels on the switch？

    正确答案:A

  • 第5题：

    The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) The CUSTOMER_ID column is the primary key for the table. Which two statements find the number of customers? （）

    • A、SELECT TOTAL(*) FROM customer;
    • B、SELECT COUNT(*) FROM customer;
    • C、SELECT TOTAL(customer_id) FROM customer;
    • D、SELECT COUNT(customer_id) FROM customer;
    • E、SELECT COUNT(customers) FROM customer;
    • F、SELECT TOTAL(customer_name) FROM customer;

    正确答案:B,D

  • 第6题：

    问答题
    Practice 1　　‘Mini presentation’—about 6 minutes　　In this part of the test you are asked to give a short talk on a business topic. You have to choose one of the topics from the three below and then talk for about one minute. You have one minute to prepare your ideas.　　A  WHAT IS IMPORTANT WHEN MOTIVATING STAFF?　　● FINANCIAL BENEFITS　　● CAREER DEVELOPMENT OPPORTUNITIES　　●...　　B  WHAT IS IMPORTANT WHEN SATISFYING CUSTOMERS?　　● A GOOD AFTER-SALES TEAM　　● MORE CUMMUNICATION WITH CUSTOMERS　　●...　　C  WHAT IS IMPORTANT WHEN PREPARING FOR A JOB INTERVIEW?　　● STUDYING THE JOB ADVERTISEMENT　　● STUDYING THE COMPANY　　●...

    正确答案： 【参考范例】
    Sample A:
    Well, I’m very interested in this topic—what’s important when motivating staff. As far as I am concerned, I think we should take three main important factors into consideration, that is, financial incentives, career development chances and an easy-going boss. Firstly, the most important factor should be the financial benefits. They may consist of good salary, bonus and other perks. As we know, instead of working for fun, most people work to live. And also as the saying goes, money can make the mare go, thus money is very important in develop staff’s motivationm. Secondly, career development chances are quite important. In reality, there is nobody who does not want to be promoted. If there are not any good career prospects in a job, staff will probably give up the job. Finally, an easy-going boss is also important. Nobody is willing to work with a difficult boss. In conclusion, financial incentives, career development chances and an easy-going boss are important in motivating staff.
    Sample B:
    Well, I’d like to talk about the important factors that are beneficial to improve customers’ satisfaction. Firstly, we need a group of outstanding after-sales service team. It is true that it is difficult to meet the demands of every customer, but our duties involve dealing with customers’ complaints and trying all manner of ways to solve their problems. In order to cultivate an efficient group of after-sales service team, we must arrange some staff training courses. Besides, we need to conduct researches on customers about whether they are satisfied with our products and in what aspects they are dissatisfied. On the basis of the result of the researches, we can make improvement. In a word, a excellent after-sales team and more communication with customers  can help improve customer satisfaction.
    Sample C:
    The objective of my talk is how to prepare for a job interview. I think the preparation mainly consists of studying the job advertisement, finding out information about the company and preparing yourself psychologically. First of all, you should study carefully the job advertisement so that you can match your qualifications, such as knowledge, abilities and skills, with the specifications required for the vacancy. You must make the interviewer believe that you have all the qualifications required, thus you are the right kind of person they are looking for. Secondly, you should know more about the company, for example its profile, requirements, existing problems, structure, campaigns and future plans. Finally, you should also prepare yourself psychologically and this will help you overcome stress. For example, rehearsing the interview with your friends is a good way of relaxation exercise that can put confidence in you.
    解析： 暂无解析

  • 第7题：

    单选题
    You created a tabular report for the sales department to display each customer and the sales person assign to the customer. The data is sorted by customer using the order by clause in this query. This is department manager asks you to alter the report so that data is sorted by sales person rather than by customer. What is the best way to make the needed change?（）
    A

    Recreate the query and default the layout. 

    B

    Alter the query, default the layout and redo the boiler plates. 

    C

    Query and manually change the layout to save the boiler plate. 

    D

    Alter the query and make no further change.


    正确答案： D
    解析： 暂无解析

  • 第8题：

    单选题
    Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?（）
    A

     Create a FOR trigger. 

    B

     Create an INSTEAD OF trigger. 

    C

     Create an AFTER trigger. 

    D

     Create a DDL trigger.


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    According to the last paragraph, what kind of business will make the customers think seriously? It’s the business that can
    A

    provide comprehensive after-sales service

    B

    always offer the lowest price in the market

    C

    show customers why they are the best in class

    D

    convince customers that they are the largest in this field


    正确答案： D
    解析：
    关于哪种企业会使客户认真考虑，文中最后一段第三行指出“the one who can show them just why they’re the best qualified”，对应选项C。

  • 第10题：

    单选题
    Which of the following is a typical data warehouse query?（）
    A

    What is this customers address?

    B

    Does this customer have any unpaid bills?

    C

    What is the balance in this customers account?

    D

    What are the total sales for each of the last 6 months?


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    When dealing with customers on the phone that are not very comfortable with technology, which of the following techniques would be MOST helpful to ensure that effective communication is taking place?（）
    A

    Frequently paraphrase what the caller is saying.

    B

    Repeat what is being said multiple times so that the customer can understand exactly what to do.

    C

    Speak very slowly when replying to the customer.

    D

    Tell the customer to send an email stating exactly what the problem is so that the communication between the two parties is clear.


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns: Which SELECT statement accomplishes this task?（）
    A

    SELECT*   FROM customers;

    B

    SELECT name, address   FROM customers;

    C

    SELECT id, name, address, phone   FROM customers;

    D

    SELECT cust_name, cust_address   FROM customers;

    E

    SELECT cust_id, cust_name, cust_address, cust_phone   FROM customers;


    正确答案： D
    解析： 暂无解析

  • 第13题：

    You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do？（）

    • A、Update the view to use an outer join between the Customers and Sales tables.
    • B、Create a clustered index on the v CustomerSales view.
    • C、Create two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.
    • D、Create a stored procedure for the business analysts that uses the v CustomerSales view.

    正确答案:B

  • 第14题：

    A customer reports the optical drive is no longer responding. Which of the following questionsshould be asked FIRST?（）

    • A、“Did you log in with an administrator account?”
    • B、“Have you been to any inappropriate websites?”
    • C、“What have you changed since the optical drive worked properly?”
    • D、“What has changed since the optical drive worked properly?”

    正确答案:D

  • 第15题：

    Which of the following is a typical data warehouse query?（）

    • A、What is this customers address?
    • B、Does this customer have any unpaid bills?
    • C、What is the balance in this customers account?
    • D、What are the total sales for each of the last 6 months?

    正确答案:D

  • 第16题：

    A customer has a large amount of data stored on three database servers and is concerned that at present there is no disaster recovery plan in place.  They have an existing tape backup solution that meets their backup window.  In order to analyze potential disaster recovery plans， which of the following questions is the most important？（）

    • A、What is the minimum critical backup window？
    • B、Which server is handling the most critical data？
    • C、How much data is stored on each server？
    • D、What is the throughput of the hard drives？

    正确答案:B

  • 第17题：

    Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?（）

    • A、 Create a FOR trigger. 
    • B、 Create an INSTEAD OF trigger. 
    • C、 Create an AFTER trigger. 
    • D、 Create a DDL trigger.

    正确答案:B

  • 第18题：

    单选题
    You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do？（）
    A

    Update the view to use an outer join between the Customers and Sales tables.

    B

    Create a clustered index on the v CustomerSales view.

    C

    Create two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.

    D

    Create a stored procedure for the business analysts that uses the v CustomerSales view.


    正确答案： B
    解析： 暂无解析

  • 第19题：

    单选题
    Which service component within the prepare phase recommends the appropriate technology strategy to address a business requirement of the customer？ Select exactly 1 answer（s） from the following：（）。
    A

    identifying what a customer requires from a proposed solution

    B

    analyzes the customers business requirements and recommends the appropriate Cisco technologies to meet business requirements

    C

    determining what end-user training a customer requires

    D

    addressing a customer’s physical requirements


    正确答案： D
    解析： 暂无解析

  • 第20题：

    单选题
    A customer reports the optical drive is no longer responding. Which of the following questionsshould be asked FIRST?（）
    A

    “Did you log in with an administrator account?”

    B

    “Have you been to any inappropriate websites?”

    C

    “What have you changed since the optical drive worked properly?”

    D

    “What has changed since the optical drive worked properly?”


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    Teacher: After listening, answer the following two questions according to what you have heard on the tape.(1) What is the relationship between the speakers?(2) What are the speakers’ attitudes towards each other?What listening strategy does this listening activity help to train? _____
    A

    inferring

    B

    gist listening

    C

    listening for details

    D

    dictation


    正确答案： A
    解析：
    inferring“推断”；gist listening“要求抓主旨”；listening for details“侧重于细节”；dictation“听写”。在听力训练中，教师让学生在听完录音后推测出说话人之间的关系以及对彼此的态度。从这两个问题可知，教师在训练学生的inferring能力。

  • 第22题：

    单选题
    A customer has a new p5-550 running AIX 5.2 that is SAN-attached to a FAStT900.  They have encountered hangs lasting over a minute on their new system during application load testing.  They called the pSeries technical specialist for advice.  Which of the following would be the most appropriate questions to determine their next step in resolving the problem？（）
    A

    Are there any errors in the error log？ Do they indicate any hardware or software errors？

    B

    Has performance data been collected？ What do the results show in terms of I/O statistics？

    C

    Has performance data been collected？ What do the results show in terms of CPU utilization？ 

    D

    What type of SAN switch is the customer using？ What are the microcode levels on the switch？


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    What does the first letter require Ms. Walter to do?
    A

    Call the Customer Service Center

    B

    Send payment to the utilities firm

    C

    Review two bills from last year

    D

    Verify her account balance


    正确答案： C
    解析：
    根据第2段第3句If by April 15…your residence可知信中要求Ms. Walter在4月15日之前缴纳费用，否则中断服务，故选B。

  • 第24题：

    单选题
    A user reports that their laptop does not have network connectivity, but was working fine last week. The technician executes IPCONFIG to see what the IP address is but it comes up with a 169.254.254.1 address. This address is not part of the company's subnet. Which of the following MOST likely identifies this address type?（）
    A

    Multicast

    B

    DHCP

    C

    APIPA

    D

    Broadcast


    正确答案： D
    解析： 暂无解析

相关内容