You need to reduce the report processing time and minimize the growth of the database

You are reviewing the design of an existing fact table named factSales, which is loaded
incrementally from a SQL Azure database by a SQL Server Integration Services (SSIS)
package each hour. The fact table has approximately 4 billion rows and is dimensioned by
product, sales date, and sales time of day.

The database administrator is concerned about the rapid growth of the database and users
experience poor reporting performance against this database. Reporting requirements have
recently changed and the only remaining report that uses this fact table reports sales by
product name, sale month, and sale year. No other reports will be created against this table.
You need to reduce the report processing time and minimize the growth of the database.
What should you do?

You are reviewing the design of an existing fact table named factSales, which is loaded
incrementally from a SQL Azure database by a SQL Server Integration Services (SSIS)
package each hour. The fact table has approximately 4 billion rows and is dimensioned by
product, sales date, and sales time of day.

The database administrator is concerned about the rapid growth of the database and users
experience poor reporting performance against this database. Reporting requirements have
recently changed and the only remaining report that uses this fact table reports sales by
product name, sale month, and sale year. No other reports will be created against this table.
You need to reduce the report processing time and minimize the growth of the database.
What should you do?

A.
Create an indexed view over the fact table to sum orderTotal by month.

B.
Create a view over the fact table to sum orderTotal by month.

C.
Change the granularity of the fact table to month.

D.
Partition the fact table by productKey.

Show Hint

Leave a Reply 53

Your email address will not be published. Required fields are marked *

Koala

Koala

Why is B?
Why not C?

Reply

Modi

Modi

C is the right answer (and this is the same Question Number 10)

Reply

sql ninja

sql ninja

C is correct

Reply

Tien Schadle

Tien Schadle

The when I just read a weblog, Lets hope who’s doesnt disappoint me approximately this one. What i’m saying is, Yes, it was my choice to read, but I really thought youd have something interesting to mention. All I hear is usually a handful of whining about something you could fix when you werent too busy in search of attention.

http://www.aeriagames.com/user/myrledanes/

Reply

Janiece Disano

Janiece Disano

Nice post. I understand some thing tougher on different blogs everyday. Most commonly it is stimulating you just read content using their company writers and rehearse a little something from their website. I’d would prefer to use some together with the content in my small blog regardless of whether you don’t mind. Natually I’ll give you a link with your web blog. Many thanks for sharing.

https://www.plurk.com/SinaMaustxz

Reply

Jenise Nickell

Jenise Nickell

There’s some awesome information here. If more people were aware of this, the world would be a much better place! I can obviously see that you have put a lot of effort into this post. Please keep up the good work; the world deserves it!

http://eurlolberg.livejournal.com/

Reply

Barbera Tosten

Barbera Tosten

I just wanted to compose a quick message so as to express gratitude to you for all the wonderful tricks you are showing on this site. My prolonged internet research has at the end of the day been honored with reasonable know-how to share with my companions. I ‘d say that we website visitors actually are undeniably fortunate to be in a superb community with so many perfect people with helpful techniques. I feel very lucky to have used your entire webpage and look forward to plenty of more cool minutes reading here. Thank you once more for all the details.

http://www.ted.com/profiles/6607928

Reply

Kate Harrey

Kate Harrey

I’ve been gone for a while, but now I remember why I used to love this site. Thanks, I will try and check back more often. How often do you update your website?

http://www.scoop.it/t/click-link-12

Reply

Woodrow Dejong

Woodrow Dejong

Can I simply say what a aid to find someone who actually knows what theyre speaking about on the internet. You definitely know how one can bring an issue to gentle and make it important. More individuals need to learn this and perceive this aspect of the story. I cant believe youre not more well-liked since you definitely have the gift.

https://www.plurk.com/BeeMaxberry

Reply

Dallas Lertora

Dallas Lertora

There is an ending. Just remember that I meant for this to be an art game. I do feel like I spent an inordinate amount of time on the more traditional gameplay elements, which may make the meaning of the game a bit unclear. If you mess around with it though, you’ll find it.

https://www.reddit.com/user/MyrleDanesi

Reply

Judie Flesner

Judie Flesner

I do trust all of the ideas you have offered on your post. They are really convincing and can definitely work. Still, the posts are too brief for beginners. May you please extend them a bit from subsequent time? Thank you for the post.

http://www.scoop.it/t/click-link-11

Reply

Olin Westfall

Olin Westfall

Hi there, just became aware of your blog through Google, and found that it’s really informative. I’m gonna watch out for brussels. I’ll be grateful if you continue this in future. Many people will be benefited from your writing. Cheers!

http://www.colourlovers.com/lover/bernardinah

Reply

Shante Galimba

Shante Galimba

I take pleasure in, lead to I found exactly what I was taking a look for. You have ended my four day long hunt! God Bless you man. Have a great day. Bye

http://articles.org/odiliawont/

Reply

Arturo Schwenk

Arturo Schwenk

I’m impressed, I have to admit. Genuinely rarely will i encounter a weblog that’s both educative and entertaining, and let me tell you, you’ve hit the nail to the head. Your idea is outstanding; the catch is an issue that inadequate consumers are speaking intelligently about. I am very happy i always stumbled across this around my search for some thing about it.

http://www.colourlovers.com/lover/jadwigapenc

Reply

Rose Broadstone

Rose Broadstone

Hiya, I simply hopped over to your website by way of StumbleUpon. No longer one thing I’d generally learn, however I preferred your feelings none the less. Thank you for making one thing worth reading.

http://ydawrzynia.beepworld.de/

Reply

Lynn Faris

Lynn Faris

Given that trichotillomania may be a problem, it’s actually not one thing frozen shoulder in a single merely end carrying out once they look as it. People who have trichotillomania normally require assist by health experts just before they are able to halt. Using the suitable aid, nevertheless, many people get over his or her hair-pulling desires. This particular support may perhaps entail treatment, prescription medication, as well as a variety of the two.

http://thehot.me/beauty-is-everywhere/

Reply

Mckinley Vause

Mckinley Vause

hello!,I love your writing very much! share we keep up a correspondence extra approximately your post on AOL? I require an expert in this area to resolve my problem. May be that is you! Having a look forward to see you.

http://thehot.me/the-hidden-secrets-of-makeup/

Reply

Curtis Deyarmond

Curtis Deyarmond

Unquestionably believe that which you said. Your favorite reason seemed to be on the net the simplest thing to be aware of. I say to you, I certainly get annoyed while people think about worries that they plainly do not know about. You managed to hit the nail upon the top and also defined out the whole thing without having side-effects , people can take a signal. Will probably be back to get more. Thanks

http://thehot.me/how-to-be-beautiful/

Reply

Dwain Nager

Dwain Nager

The when Someone said a blog, Lets hope who’s doesnt disappoint me up to this. What i’m saying is, Yes, it was my option to read, but I personally thought youd have some thing fascinating to convey. All I hear is really a handful of whining about something you could fix in case you werent too busy searching for attention.

http://thehot.me/beauty-is-everywhere/

Reply

Wesley Prehn

Wesley Prehn

I would like to show my gratitude for your kindness for people that absolutely need help with this particular content. Your very own dedication to getting the message all-around became particularly good and have in most cases encouraged girls much like me to achieve their goals. This informative guideline implies so much to me and much more to my office colleagues. Thanks a lot; from each one of us.

http://thehot.me/beauty-is-everywhere/

Reply

Gisela Slawski

Gisela Slawski

I know this really is truly boring and you’re simply skipping to another comment, however i simply desired to toss a large many thanks — a person resolved the main things personally!

http://thehot.me/how-to-be-beautiful/

Reply