Interesting Question of 70-228
From: Vani (anonymous_at_discussions.microsoft.com)
Date: 05/27/04
- Next message: Vani: "70-228 exam"
- Previous message: Tim: "MCDBA"
- In reply to: Ron: "Interesting Question of 70-228"
- Next in thread: Mark Pevsner: "RE: Interesting Question of 70-228"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 27 May 2004 05:09:08 -0700
Hi Ron,
Can you please point to the post in MCSE. I searched it
but could not get.
I took the 70-228 exam today .. and did not get a passing
score. I am not sure which questions I had answered
corectly and which one wrongly. I do not even recollect
the questions.
Tmon,
how did you recollect the questions correctly. I also got
4 questions that you had mentioned. Wondering as to how
you could recollect.
>-----Original Message-----
>cross-post. see answer in MCSE newsgroup
>>-----Original Message-----
>>I had appeared for 70-228 last week but I don't
>understand
>>why I could not pass and have been diagnosing the
>Question
>>till Now. It looks like some questions have 2 answers.
>>
>>Please verify
>>
>>
>>
>>1.You are the administrator of two Mircosoft Windows
>2000
>>computers. One computer is running
>>Internet Information Services (IIS), and the other is
>>running SQL Server 2000. Company partners
>>need to connect by means of the Internet and query data
>>stored on the SQL Server computer.
>>Some of these partners have computers that do not use
>>Microsoft operating systems or Web
>>browsers. You need to configure the IIS and SQL Server
>>2000 computers to allow access to data
>>by means of the IIS virtual directory. IIS uses Basic
>>Authentication to allow access to the
>>virtual directory. Only company partners should have
>>access to the SQL Server computer by means
>>of the Internet. The partners should be allowed to make
>ad
>>hoc queries. You want to be able to
>>audit successful and failed logins to the SQL Server
>>computer. You want to allow the partners
>>access to the SQL Server computer while keeping your
>>security scheme as simple as possible.
>>Which two actions should you take? (Each correct answer
>>represents part of the solution.
>>Choose two.)
>>
>>A. Configure the IIS virtual directory to allow URL
>>queries.
>>B. Configure the IIS virtual directory to allow template
>>queries.
>>C. Create a new Windows user account. Create a
>>corresponding Windows Authenticated login on the SQL
>>Server
>>computer. Configure the IIS virtual directory to always
>>use this login when connecting to the SQL Server
>>computer.
>>D. Create a Windows Authenticated login on the SQL
>Server
>>computer for the IIS Internet Guest Account.
>>Configure the IIS virtual directory to always use the
>>Internet Guest Account when connecting to the SQL Server
>>computer.
>>E. Create a Windows Authenticated login for each company
>>partner on the SQL Server computer. Configure the IIS
>>virtual directory to use Windows Integrated
>Authentication
>>when connecting to the SQL Server computer.
>>
>>Answer: AC
>>Why not A&E ( Choosing E would be more secure since each
>>company would know its own password)
>>
>>
>>
>>2. You are the administrator of a SQL Server 2000
>>computer. You are configuring a database
>>for an inventory application. The hard disks on your
>>server are configured as shown in the
>>exhibit (Not Available). The operating system files are
>>located on drive C. Your database
>>will store a maximum of 6 GB of data and requires a
>>maximum of 2 GB of disk space for the
>>transaction log. You want to optimize database
>>performance. What should you do?
>>
>>A. Add a 2-GB transaction log to drive D, a 3-GB data
>file
>>to drive E, and a 3-GB data file to drive F
>>B. Add a 1-GB transaction log to drive C, a 1-GB
>>transaction log to drive D, a 3-GB data file to drive E,
>>and a 3-
>>GB data file to drive F
>>C. Add a 1-GB transaction log to drive E, a 1-GB
>>transaction log to drive F, a 3-GB data file to drive E,
>>and a 3-GB
>>data file to drive F
>>D. Add a 2-GB transaction log to drive F, a 3-GB data
>file
>>to drive D, and a 3-GB data file to drive E
>>
>>Answer: D
>>
>>Why Not A( How does Microsoft rate an answer to be
>correct
>>or wrong,In this situation both A & D are
>> correct, so How should one Mark the Answer
>>Microsoft way so that nothing goes wrong)
>>
>>
>>3. You are the administrator of a SQL Server 2000
>>database. You import a table of geographic
>>information from a Microsoft Access database into a SQL
>>Server 2000 database. The table has
>>12,000 rows. Each row averages 5,000 bytes. The table
>>contains lookup data that does not
>>change. You want to minimize the size of the data file
>and
>>the time required to back up the
>>data. Which two actions should you take?(Each correct
>>answer presents part of the solution,
>>Choose two )
>>
>>A. Create a 60-MB data file named Geography.ndf
>>B. Create a 95-MB data file named Geography.ndf
>>C. Create a 60-MB data file named Geography.mdf
>>D. Create a 95-MB data file named Geography.mdf
>>E. Place the table in the PRIMARY filegroup
>>F. Place the table in a new filegroup named LOCATION
>>
>>Answer: BF (Is this right if so How)
>>
>>*Can somebody tell me How the above is calculated. The
>way
>>I calculate it looks like onyly 57MB
>>space is occupied (12000 * 5000 /1024*1024).
>>
>>
>>4. You are the administrator of a Microsoft Windows NT
>>Server 4 0 computer The server is the
>>PDC in your domain and also runs SQL Server 2000. The
>>server has four processors and 1 GB of
>>RAM. Your network consists of 500 client computers that
>>are running Microsoft Windows
>>Millennium Edition. Users report that when they log on
>in
>>the morning their computers respond
>>slowly and occasionally return error messages. You use
>>System Monitor to monitor processor
>>performance and RAM utilization You discover that the %
>>Total Time and % User Time counters
>>average 90 percent and the % Privileged Time counter
>>averages 20 percent. The Available Mbytes
>>counter averages 800 MB. You need to improve server
>>performance for user logons. What should you
>>do?
>>
>>A. Increase the physical RAM on the computer to 2 GB
>>B. Increase the virtual RAM on the computer to 4 GB
>>C. Configure SQL Server to use only processors 1,2, and
>3
>>D. Configure SQL Server to use only processors 0, 1, and
>2
>>
>>Answer: C (Why not D)
>>
>>
>>
>>5- You are the administrator of a SQL Server 2000
>computer
>>at a bank's headquarters.
>>Customers can access their accounts from headquarters or
>>from branch offices. The server at
>>headquarters maintains a master copy of all account data
>>for all customers. When a customer
>>deposits or withdraws funds at a branch office, the
>>customer's new balance must be reflected on
>>the computers at that office and at headquarters. You
>want
>>to minimize latency between the
>>headquarters and branch offices. You want to copy
>account
>>data between the server at
>>headquarters and the servers at the branch offices. What
>>should you do?
>>
>>A. Implement merge replication. Use the DATETIME (Later
>>Wins) conflict resolver. Schedule replication for off-
>>peak hours.
>>B. Implement transactional replication. Allow immediate-
>>updating subscribers. Schedule replication to run
>>continuously.
>>C. Create a data transformation services package on the
>>server at headquarters. Configure the DTS package to
>>import new account data from each of the servers at the
>>branch offices and write it to all other servers.
>Schedule
>>the DTS package to run during off-peak hours.
>>D. Add all branch office servers to the headquarters
>>server as linked servers. Create a job on the
>headquarters
>>server. Configure the job to query each linked server
>for
>>new account data and write this data to the other
>>servers. Schedule the job to run every three minutes.
>>E. Configure log shipping between the headquarters
>server
>>and the branch office servers. Configure the
>>headquarters server as the primary server and the branch
>>office servers as secondary servers. Schedule log
>>backups and log shipping to run every 10 minutes.
>>
>>Answer: B (Why not A, coz from the description it looks
>>like the branch data should be updated
>> first)
>>
>>
>>
>>
>>
>>.
>>
>.
>
- Next message: Vani: "70-228 exam"
- Previous message: Tim: "MCDBA"
- In reply to: Ron: "Interesting Question of 70-228"
- Next in thread: Mark Pevsner: "RE: Interesting Question of 70-228"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
