|
Home > Archive > microsoft.public.cert.mcdba > March 2004 > A 70-228 question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| Hi:
Just wondering if anyone can help me out on this question.
Question: 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
lockup 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: B, F.
According to Actual_Exam on the Internet, the answer is B
and F but I think answer should be A and F. What do you
think? Thanks You.
| |
|
| I would agree with you. Given the numbers in the
question, 60MB would make sense, righ? Although in real
life I would like to make it bigger.
I am wondering why C is incorrect. Does the file name
matter? BOL says you can use any file extentions.
>-----Original Message-----
>Hi:
>
>Just wondering if anyone can help me out on this
question.
>
>Question: 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
>lockup 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: B, F.
>
>According to Actual_Exam on the Internet, the answer is
B
>and F but I think answer should be A and F. What do you
>think? Thanks You.
>
>
>
>.
>
| |
| Pete Wilkinson 2004-03-26, 11:25 am |
| The reason that B is correct, as opposed to A, is that SQL
Server stores data rows in 8KB pages. Given a row size of
5000 bytes, the database would only hold one row per page,
and therefore would require 12,000 (rows) X 8060 (bytes
per page), or about 95MB. If the row size was less than
4KB then you could fit two rows per page, and half the
size of the storage space required. Hope this helps...
>-----Original Message-----
>I would agree with you. Given the numbers in the
>question, 60MB would make sense, righ? Although in real
>life I would like to make it bigger.
>I am wondering why C is incorrect. Does the file name
>matter? BOL says you can use any file extentions.
>question.
>2000
>B
>.
>
| |
|
| Thank You. I think this helps. I did not think of it
this way. Since avg row size is 5000, It will not be
able to fit more than one row per page.
>-----Original Message-----
>The reason that B is correct, as opposed to A, is that
SQL
>Server stores data rows in 8KB pages. Given a row size
of
>5000 bytes, the database would only hold one row per
page,
>and therefore would require 12,000 (rows) X 8060 (bytes
>per page), or about 95MB. If the row size was less than
>4KB then you could fit two rows per page, and half the
>size of the storage space required. Hope this helps...
>
SQL[color=blue]
contains[color=blue]
is[color=blue]
you[color=blue]
>.
>
|
|
|
|
|