102 Part I EXAM PREPARATION APPLY YOUR KNOWLEDGE
102 Part I EXAM PREPARATION APPLY YOUR KNOWLEDGE 3. In a large office with hundreds of users, you have several servers that are centrally located in a secured room that only IT staff can access. One server is used as a security server and also acts as a DHCP server. A second dual processor server is running SQL Server and another machine runs an e-mail system with IIS operational. The office does not permit any other user access to the Internet nor does it expose any information to the Internet through a web site. You must select an application architecture suitable to this configuration. No other software is available on the servers. What application architecture would be best suited? A. Single-tier B. Two-tier thin client C. Two-tier thick client D. N-tier E. Internet 4. You are creating a database for a large government office. The Primary Key has already been established but you need to supply another column that has to have different values for each record. What data types could you use without creating additional constraints? Choose all that apply. A. timestamp B. bigint C. uniqueidentifier D. nvarchar E. sql_variant 5. You are creating a database for a large government office. The Primary Key has already been established, but you need to supply another column that has to have different values for each record. What implementation techniques are available other than data type selection? Choose all that apply. A. Identity B. Foreign Key C. Unique index D. Unique constraint E. Rule 6. You are putting together the logical design for a database. Tables to be included in the database are Employees, Customers, Supplies, Products, and Sales. The table used to store customer data has the following attributes: CustomerID (Primary Key), CustomerName, StreetAddress, City, State, ZipCode, BalanceOwing, SalesmanID, SalesmanName. Which of the following rules of normalization are not being maintained? Select all that apply. A. First normal form B. Second normal form C. Third normal form
For reliable and cheap web hosting services please check cheap web hosting website.