OpenStack makes its services available through Amazon EC2/S3 compatible APIs and hence the client tools written for AWS can be used with OpenStack as well.
There are 3 main service families under OpenStack
Compute Infrastructure (Nova)
Storage Infrastructure (Swift)
Imaging Service (Glance)
OpenStack Starter Guide
http://docs.openstack.org/diablo/openstack-compute/starter/content/
//This is a tutorial style beginner's guide for OpenStack™ on Ubuntu 11.10, Oneiric Ocelot. The aim is to help the reader in setting up a minimal installation of OpenStack.
//MoinMoin Wiki
2011/11/17
1-New Features in SQL Server 2008
Exam objectives in this chapter:
■ New Feature Overview
■ Reporting Services
Introduction
>A Word About the Test
New Feature Overview
>Installation
The SQL Server installation tool is used to create a new installation, or to make changes to the existing installation.
>Compressed Backups
When using T-SQL to create the backup, you’d use:
BACKUP DATABASE [robby] TO DISK = N'C:\Backup\robby.bak' WITH
NOFORMAT, NOINIT, NAME = N'robby-Full Database Backup', SKIP,
NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10
The Copy Only Backup is especially useful for taking “one off ” backups for development or testing – the advantage is it doesn’t affect transaction log backups or differential backups. Keep in mind it also cannot serve as a base for differential or transaction log backups when restoring either.
The T-SQL procedure to do a Copy Only Backup would look like:
BACKUP DATABASE [robby] TO DISK = N'C:\Backup\robby.bak' WITH COPY_ONLY,
NOFORMAT, NOINIT, NAME = N'robby-Full Database Backup', SKIP, NOREWIND,
NOUNLOAD, STATS = 10
GO
>Enhanced Configuration and Management of Audits
Auditing is available using the new Change Data Capture (CDC) feature. CDC can be used to capture insertions, updates, and deletes in an SQL table in a database and place the changes in another table.
The following SQL code demonstrates how to configure CDC for auditing of a table in a database:
--Activate CDC
EXEC sys.sp_cdc_enable_db_change_data_capture
--Enable CDC on table
EXEC sys.sp_cdc_enable_table_change_data_capture @source_schema = 'dbo',
@source_name = 'myTable', @role_name = 'cdc'
>New Table Value Parameter
Passing tables as parameters has been a long time coming. The new table type can be passed to a stored procedure. This will solve quite a few problems!
Here’s an example:
To declare a Table User Defined Type in the database:
create type MyTableType as table
(
Name varchar(150),
City varchar(20),
AddressID int
)
And here's the stored procedure that consumes it:
create procedure InsertFriends
(
@MyTable MyTableType readonly
)
as
insert
into Friends (Name, city, AddressID)
select Name, city, AddressID
from @MyTable;
--To fill create and fill the temp table:
declare @MyBestFriends_temp MyTableType
insert into @MyBestFriends_temp values ('Debbie', 'Havertown', 2)
insert into @MyBestFriends_temp values ('Chris', 'Philadelphia
insert into @MyBestFriends_temp values ('Tom', 'Garden City', 11)
insert into @MyBestFriends_temp values ('Greg', 'Lansdowne', 6)
insert into @MyBestFriends_temp values ('Steve', 'Wilmington
--And finally, to execute:
execute InsertFriends @MyBestFriends_temp
>FileStream Data Types
the database engine will store all of the data associated with the column in a disk file as opposed to the actual database. You might have used a similar home-grown scheme in earlier versions of SQL, but this integrates everything nicely into SQL Server.
must first enable it. This is accomplished via the sp_FILESTREAM_configure system stored procedure, or via the GUI in Management Studio under advanced settings.
Once FileStream is enabled, a file group must be added to the database in order for it to be able to use FileStream data types.
FileStream has the following limitations:
■ Database mirroring cannot be configured in databases with FileStream data.
■ Database snapshots are not supported for FileStream data.
■ Native encryption is not possible by SQL Server for FileStream data.
>Sparse Column Support
Sparse columns allow for the optimized storage of null columns. Sparse columns can be a good thing, but be sure to enable them only on columns that contain sparse data, or your storage requirements may go up instead of down.
To enable a column as a sparse column, use the create statement in SQL or change the properties in the column to Sparse.
The SQL to accomplish this is as follows:
CREATE TABLE dbo.Table_1
(
OID int NULL,
MyValue1 varchar(50) SPARSE NULL
) ON [PRIMARY]
GO
>Encryption Enhancements
Transparent data encryption (TDE) is available in SQL Server 2008.TDE allows you to easily encrypt the contents of your database and is designed to provide protection to the entire database. With TDE, you can encrypt the contents of your database with no changes to your application.
To enable TDE, you need to first create a master key and a certificate. Once the master key and certificate are set up, use the following to enable TDE:
ALTER DATABASE myDatabase SET ENCRYPTION ON
Once TDE is enabled, it’s designed to be transparent to the application.
>>Key Management and Encryption
Encryption requires keys to secure the database. These keys must be protected and backed up
>High Availability
Mirroring has been improved, Hot Add CPU has been added, and Hot Add Memory is available.
SQL Server 2008 can also take advantage of the new failover clustering enhancements available in Windows 2008.
failover clustering is not available in the Web edition or workgroup edition.
>Performance
>>Performance Data Management
Performance data management is a new tool available in SQL Server 2008.
Performance data management allows you to collect performance-related data from your SQL Servers over time. Performance data management consists of a warehouse database (for storing the results) and the data collector, and collection is usually scheduled to run at specific times.
>>Resource Governor (similar to Query Governor)
Resource Governor is a nice new feature to help manage workload, designed to limit the resources available to a process. The way the Resource Governor works is the DBA creates a workload group and a resource pool. Workload groups are containers to hold user sessions. Workload groups are mapped to resource pools.
User sessions are mapped to workload groups based on classifier functions. The classifier functions can be by IP address, username, application name, and so on.
>>Freeze Plan
Plan freezing is meant to offer greater predictability when it comes to executing a particular query in SQL Server 2008.
basically a cached plan that is kept around and used for a particular query.
First, you need to create the data warehouse
The actual how to is found later in this book; it’s worthwhile knowing how to use this new feature.
Figure A Data Collection Report is a sample of one of the reports available in the data collection set.
the data collection can be used only on SQL Server 2008 servers. It will not work if you connect to a SQL 2005 or SQL 2000 database server.
>SQL Server 2008 Declarative Management Framework
Declarative Management Framework (DMF). This is basically a new policy-based management system for SQL Server 2008.
The DMF is very similar to Windows policy;
you can enforce a particular naming convention for stored procedures and a different naming convention for tables.
There are three main components to the DMF: policies, conditions, and facets.
To create or apply a policy, you would right click on the policy node and proceed from there.
>Development Improvements
>>LINQ Support
basically a mapping of the database object to programming objects. This allows for a more object-oriented approach to dealing with database objects
>>MERGE Statement
The MERGE statement performs insert, update, or delete operations on a target table based on the results of a join to a source table.
For example, you can synchronize two tables by inserting, updating, or deleting all of the rows in one table based on differences in the other table.
Here is an example of MERGE code:
MERGE MyDatabase.Inventory AS
USING (SELECT ProductID, SUM(OrderQty) FROM mySales.Orders AS o
JOIN mySales.mySalesOrderHeader AS soh
ON o.mySalesOrderID = soh.mySalesOrderID
AND soh.OrderDate = @OrderDate
GROUP BY ProductID) AS source (ProductID, OrderQty)
ON (target.ProductID = source.ProductID)
WHEN MATCHED AND target.Quantity - source.OrderQty <= 0
THEN DELETE
WHEN MATCHED
THEN UPDATE SET target.Quantity = target.Quantity - source.OrderQty,
target.ModifiedDate = GETDATE()
OUTPUT $action, Inserted.ProductID, Inserted.Quantity, Inserted.ModifiedDate,
Deleted.ProductID,
Deleted.Quantity, Deleted.ModifiedDate;
>Spatial Data Type
The spatial data type is a new data type
spatial data type is used to store location-based data
do geocoding.
>Analysis Services Improvements
In Analysis Services, a better cube designer, dimension and attribute designer, and enhanced data mining structures.
>ETL/SSIS Enhancements
Many of the new features carry over to SSIS, like Change Data Capture and the MERGE statement. Another good new feature is being able to script in C#
Reporting Services
SQL Server Reporting Services. it now supports rich text format.
>No Longer Requires IIS
>Better Graphing
Reporting Services supports graphing,
>Export to Word Support
Reporting Services now has the ability to export to Word.
>Deprecated Features
■ BACKUP {DATABASE | LOG} WITH PASSWORD
■ BACKUP {DATABASE | LOG} WITH MEDIAPASSWORD
■ RESTORE {DATABASE | LOG} … WITH DBO_ONLY
■ RESTORE {DATABASE | LOG} WITH PASSWORD
■ RESTORE {DATABASE | LOG} WITH MEDIAPASSWORD
■ 80 compatibility level and upgrade from version 80.
■ DATABASEPROPERTY
■ WITH APPEND clause on triggers
■ Default setting of disallow results from triggers option = 0
■ sp_dboption
■ FASTFIRSTROW hint
■ sp_addremotelogin
■ sp_addserver
■ sp_dropremotelogin
■ sp_helpremotelogin
■ sp_remoteoption
■ @@remserver
■ SET REMOTE_PROC_TRANSACTIONS
■ sp_dropalias
■ SET DISABLE_DEF_CNST_CHK
■ SET ROWCOUNT for INSERT, UPDATE, and DELETE statements
■ Use of *= and =*
■ COMPUTE / COMPUTE BY
■ sys.database_principal_aliases
■ sqlmaint Utility
■ The RAISERROR (Format: RAISERROR integer string) syntax is deprecated.
these will still work in SQL Server 2008, they are not a recommended best practice.
>Discontinued Features
■ sp_addalias
■ Registered Servers API
■ DUMP statement
■ LOAD statement
■ BACKUP LOG WITH NO_LOG
■ BACKUP LOG WITH TRUNCATE_ONLY
■ BACKUP TRANSACTION
■ 60, 65, and 70 compatibility levels
■ DBCC CONCURRENCYVIOLATION
■ sp_addgroup
■ sp_changegroup
■ sp_dropgroup
■ sp_helpgroup
■ Northwind and pubs
■ Surface Area Configuration Tool
■ sp_makewebtask
■ sp_dropwebtask
■ sp_runwebtask
■ sp_enumcodepages
Ref>
ISBN 13: 978-1-59749-420-5
ISBN 13: 978-1-59749-420-5
1-New Features in SQL Server 2008-QA
Self Test
1. You are setting up security for your new SQL Server 2008 installation.
Management is concerned about security. What approach should you take to ensure security settings are optimal?
A. Use the Surface Area Configuration Tool to secure the installation
B. Use the new Security Analysis tool to secure the installation
C. Use SQL Server Configuration Manager to secure the installation
D. Use Windows Service Manager to enable and disable the appropriate services
2. You have been tasked with setting up standards for your SQL Server 2008 installation. You need to enforce a table naming convention. What is the best way to accomplish this in your SQL Server 2008 environment?
A. Use Windows Group Policy
B. Create DDL Triggers
C. Create DML Triggers
D. Create a Declarative Management Framework policy
3. You have been asked to create a backup of your production database and restore it on a development server. Your production server is using the full recovery model. Full backups are taken Monday and Wednesday. Transaction log backups are taken every hour. Today is Friday. The backup needs to be created as quickly as possible. What’s the fastest way to get the latest database copy while minimizing impact to production?
A. Create a normal backup. Use that to restore to development.
B. Create a Copy Only Backup. Use that to restore to development.
C. Use the Wednesday backup. Restore the transaction log backups since Wednesday.
D. Copy the .mdf and log files and use SP_attach.
4. You have a SQL Server 7.0 database and would like to move it to a new SQL Server 2008 instance. The database is part of an FDA-validated system and cannot be changed at all? How can this be accomplished?
A. Restore the 7.0 database on your new server and set the compatibility mode to 7.
B. You must upgrade the database to SQL 2005 or greater.
C. Restore the 7.0 database on your new server and set the compatibility mode to 6.5.
D. Copy the .mdf and log files and use SP_attach.
5. You have an application that is being upgraded from SQL Server 2005 to SQL Server 2008. You notice that some stored procedures are not working correctly. An excerpt is as follows:
SELECT *
FROM Territories, Region
WHERE territories.regionid *= region.regionid
What should you do to resolve the issue?
A. There is no issue. The problem lies elsewhere.
B. The join syntax is incorrect. Replace with left join.
C. The select is incorrect. You need to enumerate the fields.
D. The where clause should be = not =.
6. Your disk is almost full on the transaction log drive for a database server.
How can you resolve this issue?
A. Use BACKUP LOG WITH TRUNCATE_ONLY
B. Change the mode to simple and shrink the log
C. Reinstall SQL
D. Drop the database and restore from the last backup
7. You want to enforce a standard naming convention for stored procedures.
What’s the best way to do this in SQL Server 2008?
A. Create a DDL trigger
B. Use the performance data warehouse
C. Create DML triggers
D. Use the SQL Server 2008 Declarative Management Framework
8. You want to enforce a standard naming convention for tables and stored procedures. Your company has two SQL 2008 Servers and 60 SQL 2005 Servers. You need to use the same solution on all servers. What’s the best way to do this in SQL Server 2005 and SQL Server 2008?
A. Create a DDL trigger for all servers
B. Use the performance data warehouse
C. Create DML triggers
D. Use the SQL Server 2008 Declarative Management Framework
9. You have a database table with a varchar(600) field in it. Most of the records in the table have a null value for this field. How can you save space?
A. Move the data into a second table
B. Use sparse columns
C. Install a third-party tool on the machine to compress the data
D. Use the SQL Server 2008 Declarative Management Framework
10. You have a database table with a FileStream field in it. Most of the records in the table have a null value for this field. What’s the best way to save space?
A. Move the data into a second table
B. Use sparse columns
C. Use the SQL Server 2008 Declarative Management Framework
D. None of the above
11. You need to store images in for a Web site using SQL Server 2008. How can you accomplish this?
A. Use a FileStream data type, and the images will be stored on disk
B. Use a varchar data type and store the images in that field
C. Use an int data type and store the images in that field
D. Use an nchar data type and store the images in that field
12. You are responsible for a system that is used for both online transaction processing (OLTP) and reporting. When reports run on the server, the OLTP process slows way down. How can you allow reports to be run on the server and minimize impact to the OLTP processes?
A. Use the Resource Governor
B. Use a DDL trigger
C. Use a DML trigger
D. Use processor affinity masks
13. You are creating an application to track crime in different locations throughout a large city. What data type could prove useful for storing location data (longitude and latitude)?
A. Varchar
B. int
C. Char
D. Spatial
14. You are running out of space on the drive used to store backups. All of the servers use the same network location. What can you do to save space with your backups while maintaining the same number of backups?
A. Use data compression
B. Use compressed backups
C. Use full backups
D. Use a third-party tool
15. You need to store sensitive data in your SQL Server database. The application has already been written and works fine. What’s the easiest way to do this without having to change your application?
A. Modify the stored procedures to use xp_encryptstring
B. Use transparent data encryption
C. Use a third-party tool
D. Use a trigger
16. Within your application, you need to log all changes to one table. DDL and DML changes must be logged. What’s the best approach to solve this problem?
A. Use the built-in auditing capability
B. Create a DDL trigger
C. Create a DML trigger
D. This cannot be accomplished
17. You have a server that supports Hot Add CPU. The current CPU utilization is 95 to 100 percent most of the time. The server is mission-critical and cannot be shut down. SQL Server 2008 Standard Edition is installed. What should you do?
A. Use the Hot Add CPU feature to add another CPU
B. Use the Hot Add CPU feature to add two CPUs
C. Add more memory to the server
D. Schedule an outage and add another CPU to the server
18. You are contemplating using data compression on a table. You would like to know how much space this will save. How can you determine the savings?
A. View the table properties
B. Enable compression, then check the table size
C. Use sp_estimate_data_compression_savings
D. Use sp_check_compression
19. You have a server that supports Hot Add Memory. Performance is sluggish, and you believe adding more memory will help. The server is mission-critical and cannot be shut down. SQL Server 2008 Standard Edition is installed.
What should you do?
A. Use the Hot Add CPU feature to add another CPU
B. Use the Hot Add CPU feature to add two CPUs
C. Add more memory to the server.
D. Schedule an outage and add memory to the server.
20. You have a SQL Server 2008 installation, and you want to create a highavailability solution. What are the ideal approach(es) to solve this problem?
A. Backup and restore
B. Replication
C. Mirroring
D. Clustering
Ref>
ISBN 13: 978-1-59749-420-5
1. You are setting up security for your new SQL Server 2008 installation.
Management is concerned about security. What approach should you take to ensure security settings are optimal?
A. Use the Surface Area Configuration Tool to secure the installation
B. Use the new Security Analysis tool to secure the installation
C. Use SQL Server Configuration Manager to secure the installation
D. Use Windows Service Manager to enable and disable the appropriate services
2. You have been tasked with setting up standards for your SQL Server 2008 installation. You need to enforce a table naming convention. What is the best way to accomplish this in your SQL Server 2008 environment?
A. Use Windows Group Policy
B. Create DDL Triggers
C. Create DML Triggers
D. Create a Declarative Management Framework policy
3. You have been asked to create a backup of your production database and restore it on a development server. Your production server is using the full recovery model. Full backups are taken Monday and Wednesday. Transaction log backups are taken every hour. Today is Friday. The backup needs to be created as quickly as possible. What’s the fastest way to get the latest database copy while minimizing impact to production?
A. Create a normal backup. Use that to restore to development.
B. Create a Copy Only Backup. Use that to restore to development.
C. Use the Wednesday backup. Restore the transaction log backups since Wednesday.
D. Copy the .mdf and log files and use SP_attach.
4. You have a SQL Server 7.0 database and would like to move it to a new SQL Server 2008 instance. The database is part of an FDA-validated system and cannot be changed at all? How can this be accomplished?
A. Restore the 7.0 database on your new server and set the compatibility mode to 7.
B. You must upgrade the database to SQL 2005 or greater.
C. Restore the 7.0 database on your new server and set the compatibility mode to 6.5.
D. Copy the .mdf and log files and use SP_attach.
5. You have an application that is being upgraded from SQL Server 2005 to SQL Server 2008. You notice that some stored procedures are not working correctly. An excerpt is as follows:
SELECT *
FROM Territories, Region
WHERE territories.regionid *= region.regionid
What should you do to resolve the issue?
A. There is no issue. The problem lies elsewhere.
B. The join syntax is incorrect. Replace with left join.
C. The select is incorrect. You need to enumerate the fields.
D. The where clause should be = not =.
6. Your disk is almost full on the transaction log drive for a database server.
How can you resolve this issue?
A. Use BACKUP LOG WITH TRUNCATE_ONLY
B. Change the mode to simple and shrink the log
C. Reinstall SQL
D. Drop the database and restore from the last backup
7. You want to enforce a standard naming convention for stored procedures.
What’s the best way to do this in SQL Server 2008?
A. Create a DDL trigger
B. Use the performance data warehouse
C. Create DML triggers
D. Use the SQL Server 2008 Declarative Management Framework
8. You want to enforce a standard naming convention for tables and stored procedures. Your company has two SQL 2008 Servers and 60 SQL 2005 Servers. You need to use the same solution on all servers. What’s the best way to do this in SQL Server 2005 and SQL Server 2008?
A. Create a DDL trigger for all servers
B. Use the performance data warehouse
C. Create DML triggers
D. Use the SQL Server 2008 Declarative Management Framework
9. You have a database table with a varchar(600) field in it. Most of the records in the table have a null value for this field. How can you save space?
A. Move the data into a second table
B. Use sparse columns
C. Install a third-party tool on the machine to compress the data
D. Use the SQL Server 2008 Declarative Management Framework
10. You have a database table with a FileStream field in it. Most of the records in the table have a null value for this field. What’s the best way to save space?
A. Move the data into a second table
B. Use sparse columns
C. Use the SQL Server 2008 Declarative Management Framework
D. None of the above
11. You need to store images in for a Web site using SQL Server 2008. How can you accomplish this?
A. Use a FileStream data type, and the images will be stored on disk
B. Use a varchar data type and store the images in that field
C. Use an int data type and store the images in that field
D. Use an nchar data type and store the images in that field
12. You are responsible for a system that is used for both online transaction processing (OLTP) and reporting. When reports run on the server, the OLTP process slows way down. How can you allow reports to be run on the server and minimize impact to the OLTP processes?
A. Use the Resource Governor
B. Use a DDL trigger
C. Use a DML trigger
D. Use processor affinity masks
13. You are creating an application to track crime in different locations throughout a large city. What data type could prove useful for storing location data (longitude and latitude)?
A. Varchar
B. int
C. Char
D. Spatial
14. You are running out of space on the drive used to store backups. All of the servers use the same network location. What can you do to save space with your backups while maintaining the same number of backups?
A. Use data compression
B. Use compressed backups
C. Use full backups
D. Use a third-party tool
15. You need to store sensitive data in your SQL Server database. The application has already been written and works fine. What’s the easiest way to do this without having to change your application?
A. Modify the stored procedures to use xp_encryptstring
B. Use transparent data encryption
C. Use a third-party tool
D. Use a trigger
16. Within your application, you need to log all changes to one table. DDL and DML changes must be logged. What’s the best approach to solve this problem?
A. Use the built-in auditing capability
B. Create a DDL trigger
C. Create a DML trigger
D. This cannot be accomplished
17. You have a server that supports Hot Add CPU. The current CPU utilization is 95 to 100 percent most of the time. The server is mission-critical and cannot be shut down. SQL Server 2008 Standard Edition is installed. What should you do?
A. Use the Hot Add CPU feature to add another CPU
B. Use the Hot Add CPU feature to add two CPUs
C. Add more memory to the server
D. Schedule an outage and add another CPU to the server
18. You are contemplating using data compression on a table. You would like to know how much space this will save. How can you determine the savings?
A. View the table properties
B. Enable compression, then check the table size
C. Use sp_estimate_data_compression_savings
D. Use sp_check_compression
19. You have a server that supports Hot Add Memory. Performance is sluggish, and you believe adding more memory will help. The server is mission-critical and cannot be shut down. SQL Server 2008 Standard Edition is installed.
What should you do?
A. Use the Hot Add CPU feature to add another CPU
B. Use the Hot Add CPU feature to add two CPUs
C. Add more memory to the server.
D. Schedule an outage and add memory to the server.
20. You have a SQL Server 2008 installation, and you want to create a highavailability solution. What are the ideal approach(es) to solve this problem?
A. Backup and restore
B. Replication
C. Mirroring
D. Clustering
Ref>
ISBN 13: 978-1-59749-420-5
2011/11/16
Intel超低電壓版處理器規格對照表
intel Ultra-Low Voltage, ULV
平臺 型號 核心 執行緒 時脈 Turbo Boost最大時脈 製程
Core 2 Duo平臺
（在Core 2 Duo系列中的超低電壓版處理器，時脈普遍不高，並且沒有Turbo Boost技術） Core 2 Duo SU9600 2 2 1.6 GHz × 45奈米
Core 2 Duo SU9400 2 2 1.4 GHz × 45奈米
Core 2 Duo SU9300 2 2 1.2 GHz × 45奈米
Core 2 Duo SU7300 2 2 1.3 GHz × 45奈米
Core 2 Duo SU3500 1 1 1.4 GHz × 45奈米
Pentium Dual-Core SU4100 2 2 1.3 GHz × 45奈米
Celeron SU2300 1 1 1.2 GHz × 45奈米
Celeron M723 1 1 1.2 GHz × 65奈米
第1代Core i平臺
（在第1代Core i系列中的超低電壓版處理器，新增Hyper Threading技術，讓一顆實體核心，可以模擬成2顆邏輯核心，並且增加了Turbo Boost技術，不過整體標準時脈變得較低）
Core i7-680UM 2 4 1.46 GHz 2.53 GHz 32奈米
Core i7-660UM 2 4 1.33 GHz 2.4 GHz 32奈米
Core i7-640UM 2 4 1.2 GHz 2.266 GHz 32奈米
Core i7-620UM 2 4 1.06 GHz 2.133 GHz 32奈米
Core i5-560UM 2 4 1.33 GHz 2.13 GHz 32奈米
Core i5-540UM 2 4 1.2 GHz 2 GHz 32奈米
Core i5-520UM 2 4 1.06 GHz 1.866 GHz 32奈米
Core i3-380UM 2 4 1.33 GHz × 32奈米
Core i3-330UM 2 4 1.2 GHz × 32奈米
第2代Core i平臺
（在第2代Core i系列中的超低電壓版處理器中，強化成Turbo Boost 2.0技術，繪圖效能也能夠獲得動態提升，且標準時脈有大幅的提高）
Core i7-2677M 2 4 1.8 GHz 2.9 GHz 32奈米
Core i7-2657M 2 4 1.6 GHz 2.7 GHz 32奈米
Core i7-2637M 2 4 1.7 GHz 2.8 GHz 32奈米
Core i7-2617M 2 4 1.5 GHz 2.6 GHz 32奈米
Core i5-2557M 2 4 1.7 GHz 2.7 GHz 32奈米
Core i5-2467M 2 4 1.6 GHz 2.3 GHz 32奈米
Core i3-2367M 2 4 1.4 GHz × 32奈米
Core i3-2357M 2 4 1.3 GHz × 32奈米
Ref>
http://www.ithome.com.tw/itadm/article.php?c=70656&s=5
平臺 型號 核心 執行緒 時脈 Turbo Boost最大時脈 製程
Core 2 Duo平臺
（在Core 2 Duo系列中的超低電壓版處理器，時脈普遍不高，並且沒有Turbo Boost技術） Core 2 Duo SU9600 2 2 1.6 GHz × 45奈米
Core 2 Duo SU9400 2 2 1.4 GHz × 45奈米
Core 2 Duo SU9300 2 2 1.2 GHz × 45奈米
Core 2 Duo SU7300 2 2 1.3 GHz × 45奈米
Core 2 Duo SU3500 1 1 1.4 GHz × 45奈米
Pentium Dual-Core SU4100 2 2 1.3 GHz × 45奈米
Celeron SU2300 1 1 1.2 GHz × 45奈米
Celeron M723 1 1 1.2 GHz × 65奈米
第1代Core i平臺
（在第1代Core i系列中的超低電壓版處理器，新增Hyper Threading技術，讓一顆實體核心，可以模擬成2顆邏輯核心，並且增加了Turbo Boost技術，不過整體標準時脈變得較低）
Core i7-680UM 2 4 1.46 GHz 2.53 GHz 32奈米
Core i7-660UM 2 4 1.33 GHz 2.4 GHz 32奈米
Core i7-640UM 2 4 1.2 GHz 2.266 GHz 32奈米
Core i7-620UM 2 4 1.06 GHz 2.133 GHz 32奈米
Core i5-560UM 2 4 1.33 GHz 2.13 GHz 32奈米
Core i5-540UM 2 4 1.2 GHz 2 GHz 32奈米
Core i5-520UM 2 4 1.06 GHz 1.866 GHz 32奈米
Core i3-380UM 2 4 1.33 GHz × 32奈米
Core i3-330UM 2 4 1.2 GHz × 32奈米
第2代Core i平臺
（在第2代Core i系列中的超低電壓版處理器中，強化成Turbo Boost 2.0技術，繪圖效能也能夠獲得動態提升，且標準時脈有大幅的提高）
Core i7-2677M 2 4 1.8 GHz 2.9 GHz 32奈米
Core i7-2657M 2 4 1.6 GHz 2.7 GHz 32奈米
Core i7-2637M 2 4 1.7 GHz 2.8 GHz 32奈米
Core i7-2617M 2 4 1.5 GHz 2.6 GHz 32奈米
Core i5-2557M 2 4 1.7 GHz 2.7 GHz 32奈米
Core i5-2467M 2 4 1.6 GHz 2.3 GHz 32奈米
Core i3-2367M 2 4 1.4 GHz × 32奈米
Core i3-2357M 2 4 1.3 GHz × 32奈米
Ref>
http://www.ithome.com.tw/itadm/article.php?c=70656&s=5
2011/11/15
SP Server 2010>2-Review-22
*70-667
Review Questions-2
11. Deploying SharePoint Server 2010 on a single server with a built-in database is often used for testing SharePoint or for training. For this installation type, which of the following are required tasks? (Choose all that apply.)
A. Microsoft SQL Server 2005 Express must be installed.
B. Microsoft SQL Server 2008 Express must be installed.
C. The SharePoint Products And Technologies Wizard must create the SharePoint Central Administration website.
D. The SharePoint Products And Technologies Wizard must create all the site collections for SharePoint.
12. For the SharePoint Server 2010 on a single server with a built-in database installation, you typically run the SharePoint Products And Technologies Wizard immediately after you finish running Setup.exe. If the configuration wizard should fail, what are your options? (Choose all that apply.)
A. On the Configuration Failed page, click the available link to locate the PSCDiagnostics log files in order to determine the problem.
B. Navigate to %COMMONPROGRAMFILES%\Microsoft Shared\Web Server Extensions\14\LOGS to locate the log files and attempt to determine the problem.
C. On the Configuration Failed page, under Repair Or Remove, select Repair.
D. On the SharePoint Server 2010 splash screen, under Install, click Install SharePoint Server. When prompted to choose Repair or Remove, select Repair.
13. One of the post-installation tasks for a single-server installation with a built-in database is to create at least one web application. If you choose not to create a web application, what are your options for deploying a site collection?
A. You will be unable to create a site collection until you create the first web application.
B. The only web application created by default once SharePoint is installed is SharePoint Central Administration v4, and you can only create additional site collections using this web app.
C. The SharePoint – 80 and SharePoint Central Administration v4 web applications are created by default, but you can only use SharePoint – 80 to create site collections.
D. The SharePoint – 80 and SharePoint Central Administration v4 web applications are created by default, and you can use both web apps to create site collections.
14. You are a SharePoint Server 2010 administrator, and you have installed language packs for French, German, and Spanish so that you can create site collections using those languages for your company’s European customers. You have just deployed a partner site collection in French and have received feedback that some of the site content is still in English. Of the following, what could be the cause?
A. After installing the language pack, you forgot to rerun the SharePoint Products And Technologies Wizard, resulting in some corruption in the site collection’s content when it was created.
B. One of the other SharePoint administrators in your organization manually translated some of the content into English by mistake.
C. Some content in language packs for site collections is created in English by default, so this is no error.
D. Some content, such as error messages and dialog boxes, depend on technologies outside the language pack and may appear in English.
15. You are a SharePoint 2010 administrator, and you have just finished installing SharePoint Server 2010 as a single-server deployment. You have opened the Central Administration website but have experienced some errors. What are the likely errors and their solutions? (Choose all that apply.)
A. Internet Explorer 8 security may be interfering with Central Administration being opened correctly; you can add the Central Administration site to the Trusted Sites list in IE8.
B. The default Internet Explorer enhanced security settings on your server may be interfering with Central Administration being opened correctly; you can disable those settings for the Administrator account in Administrative Tools using the Server Manager page.
C. The Internet Explorer 8 default accessibility settings may not be correctly set; you can go into Internet Options to permit greater accessibility by using the Advanced tab.
D. If you are using a proxy server, Internet Explorer 8 may be blocking access to the proxy server; you can set IE8 to bypass the proxy server for local addresses.
16. You are the SharePoint administrator for your company, and you are in the process of upgrading your MOSS 2007 environment to SharePoint Server 2010. You are using Share-Point Visual Upgrade and giving the site administrators for the SharePoint site collections access to this tool. Of the following, what do you expect the site administrators to do with Visual Upgrade?
A. The site administrators can use the Visual Upgrade UI to perform upgrades to their site collections using a graphical tool to drag and drop sites into new topologies.
B. The site administrators can preview what their site collections will look like using Visual Upgrade and decide whether they want the sites to use the old MOSS 2007 look or the new SharePoint Server 2010 look.
C. The site administrators can use Visual Upgrade to preview site collection organization, navigational links, and application pool connections.
D. Site administrators do not have sufficient access permissions to use Visual Upgrade, which can be operated only by the SharePoint administrator group.
17. You are the SharePoint administrator for your company, and you’ve been tasked with developing a plan to upgrade your current MOSS 2007 deployment to SharePoint Server 2010. You currently administer your MOSS 2007 server farm with separate tiers for web servers, application servers, and database servers. Your environment uses the Office SharePoint Server 2007 Enterprise edition. Of the following, which are valid upgrade paths to Share-Point Server 2010? (Choose all that apply.)
A. You can upgrade to a SharePoint Server 2010 single-server deployment using SQL Server 2005.
B. You can upgrade to a SharePoint Server 2010 server farm deployment using the same topology of separate tiers for each of the three server roles.
C. You can upgrade to a SharePoint Server 2010 server farm deployment with a two-tier topology, with web and application server roles on one tier and database servers on a separate tier.
D. You can upgrade to any SharePoint Server 2010 Standard edition single or server farm deployment.
18. You are the SharePoint administrator for your organization. You have been tasked with upgrading your MOSS 2007 server farm to SharePoint Server 2010. You require an upgrade procedure that upgrades both your content databases and configuration settings at the same time. You have been assured by your CIO that you can take SharePoint offline for an extensive period of time, and you are required to perform little or no manual configuration of the system during the upgrade. Which is the most viable upgrade path for you to take given these parameters?
A. In-place upgrade
B. Database attach upgrade
C. Hybrid approach 1: read-only databases
D. Hybrid approach 2: detach databases
19. You are the SharePoint administrator for your organization, and you are going to perform an in-place upgrade of your MOSS 2007 environment to SharePoint Server 2010. You have run Setup.exe on all your web servers and are about to run the SharePoint Products And Technologies Configuration Wizard. Are there any conditions regarding which server the wizard must be run on first?
A. You must run the wizard first on the web server hosting the Central Administration website.
B. You must run the wizard first on the web server that experiences the greatest use by SharePoint users.
C. You must run the wizard first on the web server that experiences the least use by SharePoint users.
D. There is no preference.
20. You are the SharePoint administrator for your organization, and you have just upgraded your MOSS 2007 platform to SharePoint Server 2010. Now you must manage SharePoint’s taxonomy data. Taxonomy data is used to classify data so it can be standardized, shared, and used on multiple systems. The upgrade process from MOSS 2007 to SharePoint Server 2010 requires that you move this data from the shared services provider (SSP) database to the managed metadata database. How can you accomplish this task?
A. On the command line, use Stsadm.exe and the required parameters to initiate the move.
B. Use the appropriate commands and parameters in Windows PowerShell to initiate the move.
C. Use the Central Administration server farm management tools to initiate the move.
D. Rerun the SharePoint Products And Technologies Configuration wizard to initiate the move.
//
11. B, C. The built-in database for this installation is always Microsoft SQL Server 2008 Express. Microsoft SQL Server 2005 Express is bogus. Although the SharePoint Products And Technologies Wizard creates the configuration and content databases for SharePoint as well as the Central Administration website, it does not actually create the site collections.
12. A, B, D. You can either click the link on the Configuration Failed page or manually navigate to the location of the log files to determine what went wrong. You can also return to the SharePoint Server 2010 splash screen to initiate a repair, but you cannot initiate a repair directly from the Configuration Failed page.
13. C. Although both the SharePoint – 80 and SharePoint Central Administration v4 web applications are created by default, the Central Administration v4 web application is for the exclusive use of the Central Administration website. To create site collections for all other purposes, you must use the SharePoint – 80 web application, unless you choose to create additional web applications.
14. D. Assuming the default language for your SharePoint Server 2010 deployment is English, you can use one or more language packs to create site collections from templates that render the content in another language. However, some features, such as notifications, dialog boxes, and error messages, depend on other technologies like Microsoft .NET Framework, Microsoft Windows Workflow Foundation, and Microsoft ASP.NET and therefore may not be localized for the desired language. Not running the configuration wizard after installing the language pack would not have resulted in a working site collection at all, so option A is incorrect. Options B and C are bogus.
15. A, B, D. Option C is bogus. All other options are valid.
16. B. Visual Upgrade is a tool that lets you preview and determine how site collections will appear after the upgrade. All the other options are bogus.
17. B, C. You can upgrade any size MOSS 2007 server farm to any size SharePoint Server 2010 server farm but cannot upgrade from a server farm topology to any form of single-server deployment. Also, an Enterprise edition of SharePoint cannot upgrade to a Standard version, and vice versa.
18. D. Although the in-place upgrade may seem a logical choice, it is the quickest upgrade path, and part of the parameters for the upgrade is that time is not an issue. The detach databases combines the advantages of all the other methods, but it does take longer than the in-place upgrade.
19. A. The SharePoint Products And Technologies Configuration Wizard must first be run on the web server hosting Central Administration, since the Central Administration site is the interface providing administration tools for managing the rest of the farm. Afterward, you can run the wizard on your other web servers in any order. The other options are bogus.
20. B. To initiate the move, you need to open Windows PowerShell and execute the command Move-SPProfileManagedMetadataProperty -ProfileServiceApplicationProxy -Identity . All other options are bogus.
Ref>
ISBN: 978-0-470-62701-3
Review Questions-2
11. Deploying SharePoint Server 2010 on a single server with a built-in database is often used for testing SharePoint or for training. For this installation type, which of the following are required tasks? (Choose all that apply.)
A. Microsoft SQL Server 2005 Express must be installed.
B. Microsoft SQL Server 2008 Express must be installed.
C. The SharePoint Products And Technologies Wizard must create the SharePoint Central Administration website.
D. The SharePoint Products And Technologies Wizard must create all the site collections for SharePoint.
12. For the SharePoint Server 2010 on a single server with a built-in database installation, you typically run the SharePoint Products And Technologies Wizard immediately after you finish running Setup.exe. If the configuration wizard should fail, what are your options? (Choose all that apply.)
A. On the Configuration Failed page, click the available link to locate the PSCDiagnostics log files in order to determine the problem.
B. Navigate to %COMMONPROGRAMFILES%\Microsoft Shared\Web Server Extensions\14\LOGS to locate the log files and attempt to determine the problem.
C. On the Configuration Failed page, under Repair Or Remove, select Repair.
D. On the SharePoint Server 2010 splash screen, under Install, click Install SharePoint Server. When prompted to choose Repair or Remove, select Repair.
13. One of the post-installation tasks for a single-server installation with a built-in database is to create at least one web application. If you choose not to create a web application, what are your options for deploying a site collection?
A. You will be unable to create a site collection until you create the first web application.
B. The only web application created by default once SharePoint is installed is SharePoint Central Administration v4, and you can only create additional site collections using this web app.
C. The SharePoint – 80 and SharePoint Central Administration v4 web applications are created by default, but you can only use SharePoint – 80 to create site collections.
D. The SharePoint – 80 and SharePoint Central Administration v4 web applications are created by default, and you can use both web apps to create site collections.
14. You are a SharePoint Server 2010 administrator, and you have installed language packs for French, German, and Spanish so that you can create site collections using those languages for your company’s European customers. You have just deployed a partner site collection in French and have received feedback that some of the site content is still in English. Of the following, what could be the cause?
A. After installing the language pack, you forgot to rerun the SharePoint Products And Technologies Wizard, resulting in some corruption in the site collection’s content when it was created.
B. One of the other SharePoint administrators in your organization manually translated some of the content into English by mistake.
C. Some content in language packs for site collections is created in English by default, so this is no error.
D. Some content, such as error messages and dialog boxes, depend on technologies outside the language pack and may appear in English.
15. You are a SharePoint 2010 administrator, and you have just finished installing SharePoint Server 2010 as a single-server deployment. You have opened the Central Administration website but have experienced some errors. What are the likely errors and their solutions? (Choose all that apply.)
A. Internet Explorer 8 security may be interfering with Central Administration being opened correctly; you can add the Central Administration site to the Trusted Sites list in IE8.
B. The default Internet Explorer enhanced security settings on your server may be interfering with Central Administration being opened correctly; you can disable those settings for the Administrator account in Administrative Tools using the Server Manager page.
C. The Internet Explorer 8 default accessibility settings may not be correctly set; you can go into Internet Options to permit greater accessibility by using the Advanced tab.
D. If you are using a proxy server, Internet Explorer 8 may be blocking access to the proxy server; you can set IE8 to bypass the proxy server for local addresses.
16. You are the SharePoint administrator for your company, and you are in the process of upgrading your MOSS 2007 environment to SharePoint Server 2010. You are using Share-Point Visual Upgrade and giving the site administrators for the SharePoint site collections access to this tool. Of the following, what do you expect the site administrators to do with Visual Upgrade?
A. The site administrators can use the Visual Upgrade UI to perform upgrades to their site collections using a graphical tool to drag and drop sites into new topologies.
B. The site administrators can preview what their site collections will look like using Visual Upgrade and decide whether they want the sites to use the old MOSS 2007 look or the new SharePoint Server 2010 look.
C. The site administrators can use Visual Upgrade to preview site collection organization, navigational links, and application pool connections.
D. Site administrators do not have sufficient access permissions to use Visual Upgrade, which can be operated only by the SharePoint administrator group.
17. You are the SharePoint administrator for your company, and you’ve been tasked with developing a plan to upgrade your current MOSS 2007 deployment to SharePoint Server 2010. You currently administer your MOSS 2007 server farm with separate tiers for web servers, application servers, and database servers. Your environment uses the Office SharePoint Server 2007 Enterprise edition. Of the following, which are valid upgrade paths to Share-Point Server 2010? (Choose all that apply.)
A. You can upgrade to a SharePoint Server 2010 single-server deployment using SQL Server 2005.
B. You can upgrade to a SharePoint Server 2010 server farm deployment using the same topology of separate tiers for each of the three server roles.
C. You can upgrade to a SharePoint Server 2010 server farm deployment with a two-tier topology, with web and application server roles on one tier and database servers on a separate tier.
D. You can upgrade to any SharePoint Server 2010 Standard edition single or server farm deployment.
18. You are the SharePoint administrator for your organization. You have been tasked with upgrading your MOSS 2007 server farm to SharePoint Server 2010. You require an upgrade procedure that upgrades both your content databases and configuration settings at the same time. You have been assured by your CIO that you can take SharePoint offline for an extensive period of time, and you are required to perform little or no manual configuration of the system during the upgrade. Which is the most viable upgrade path for you to take given these parameters?
A. In-place upgrade
B. Database attach upgrade
C. Hybrid approach 1: read-only databases
D. Hybrid approach 2: detach databases
19. You are the SharePoint administrator for your organization, and you are going to perform an in-place upgrade of your MOSS 2007 environment to SharePoint Server 2010. You have run Setup.exe on all your web servers and are about to run the SharePoint Products And Technologies Configuration Wizard. Are there any conditions regarding which server the wizard must be run on first?
A. You must run the wizard first on the web server hosting the Central Administration website.
B. You must run the wizard first on the web server that experiences the greatest use by SharePoint users.
C. You must run the wizard first on the web server that experiences the least use by SharePoint users.
D. There is no preference.
20. You are the SharePoint administrator for your organization, and you have just upgraded your MOSS 2007 platform to SharePoint Server 2010. Now you must manage SharePoint’s taxonomy data. Taxonomy data is used to classify data so it can be standardized, shared, and used on multiple systems. The upgrade process from MOSS 2007 to SharePoint Server 2010 requires that you move this data from the shared services provider (SSP) database to the managed metadata database. How can you accomplish this task?
A. On the command line, use Stsadm.exe and the required parameters to initiate the move.
B. Use the appropriate commands and parameters in Windows PowerShell to initiate the move.
C. Use the Central Administration server farm management tools to initiate the move.
D. Rerun the SharePoint Products And Technologies Configuration wizard to initiate the move.
//
11. B, C. The built-in database for this installation is always Microsoft SQL Server 2008 Express. Microsoft SQL Server 2005 Express is bogus. Although the SharePoint Products And Technologies Wizard creates the configuration and content databases for SharePoint as well as the Central Administration website, it does not actually create the site collections.
12. A, B, D. You can either click the link on the Configuration Failed page or manually navigate to the location of the log files to determine what went wrong. You can also return to the SharePoint Server 2010 splash screen to initiate a repair, but you cannot initiate a repair directly from the Configuration Failed page.
13. C. Although both the SharePoint – 80 and SharePoint Central Administration v4 web applications are created by default, the Central Administration v4 web application is for the exclusive use of the Central Administration website. To create site collections for all other purposes, you must use the SharePoint – 80 web application, unless you choose to create additional web applications.
14. D. Assuming the default language for your SharePoint Server 2010 deployment is English, you can use one or more language packs to create site collections from templates that render the content in another language. However, some features, such as notifications, dialog boxes, and error messages, depend on other technologies like Microsoft .NET Framework, Microsoft Windows Workflow Foundation, and Microsoft ASP.NET and therefore may not be localized for the desired language. Not running the configuration wizard after installing the language pack would not have resulted in a working site collection at all, so option A is incorrect. Options B and C are bogus.
15. A, B, D. Option C is bogus. All other options are valid.
16. B. Visual Upgrade is a tool that lets you preview and determine how site collections will appear after the upgrade. All the other options are bogus.
17. B, C. You can upgrade any size MOSS 2007 server farm to any size SharePoint Server 2010 server farm but cannot upgrade from a server farm topology to any form of single-server deployment. Also, an Enterprise edition of SharePoint cannot upgrade to a Standard version, and vice versa.
18. D. Although the in-place upgrade may seem a logical choice, it is the quickest upgrade path, and part of the parameters for the upgrade is that time is not an issue. The detach databases combines the advantages of all the other methods, but it does take longer than the in-place upgrade.
19. A. The SharePoint Products And Technologies Configuration Wizard must first be run on the web server hosting Central Administration, since the Central Administration site is the interface providing administration tools for managing the rest of the farm. Afterward, you can run the wizard on your other web servers in any order. The other options are bogus.
20. B. To initiate the move, you need to open Windows PowerShell and execute the command Move-SPProfileManagedMetadataProperty -ProfileServiceApplicationProxy
Ref>
ISBN: 978-0-470-62701-3
訂閱：
文章 (Atom)